DATA EXPORT
WelcomeKnowledge BaseFAQStart Today
  • ✨Welcome to Data Export Documentation
  • 🏠Data Export Website
  • 💻Data Export App
  • 🛒Shopify Testimonials
  • 📌Getting Started
    • Pre-Made Reports
    • Reports
    • Scheduler
    • Settings
    • Data Synchronization
    • Data Export: Basic Functionality
  • 🧠Knowledge Base
    • Welcome to the Knowledge Base
    • Reports
      • Customized Reports
      • Filters
        • 'Contains' & 'Not contains'
        • 'is' & 'is not'
        • 'include' & 'exclude'
        • 'is BLANK' & 'is not BLANK'
        • 'Begins with' & 'Ends with'
        • '= Equals' & '!= Not equals'
        • '> Greater than' & '< Lesser than'
        • '>= Greater than or equal' & '<= Lesser than or equal'
      • Sort
      • Custom Columns
        • Calculated Columns
          • Add Order line item properties to your report
          • Add Metafields to your report
        • Static Column
      • Formatting Tools
      • Clone & Delete
    • Scheduler
      • ⌚Hourly Schedule
      • 🌞Daily Schedule
      • 🗒️Weekly Schedule
      • 📅Monthly Schedule
      • 🔽Output Options
        • Email
        • FTP
        • Google Drive
        • Google Sheets
  • ❓FAQ
    • Welcome to Data Export FAQ
    • Reports
    • Schedule
    • Sales & Billing
    • Data Sync
    • Service
  • 📋Changelog
Powered by GitBook
On this page

Was this helpful?

  1. Knowledge Base
  2. Reports
  3. Filters

'Contains' & 'Not contains'

PreviousFiltersNext'is' & 'is not'

Last updated 1 year ago

Was this helpful?

How does contains & not contains filter work

They contain filter is used when you have any specific word contained in a phrase.

Example: I want to filter the products which contain apples.

Consider that the store contains many products like Sony headphones, Bose headphones, Sony tv, Apple charger, Apple iPhone 5, Apple iPhone 6, Apple iPhone 7, Apple Mac computer, Apple headphones, Apple mouse, SanDisk music player, SanDisk Pen drive, Seagate hard disk, HP laptop, etc.

When the contains a filter for the product Apple is applied, the report will pull only the Apple products since all the products have the name Apple in common, i.e., Apple iPhone 5, Apple iPhone 6, Apple iPhone 7, Apple Mac computer, apple headphones, and Apple mouse.

Similarly, when not contains a filter for the product Apple is applied, the report will pull only the Non-Apple products, i.e. Sony Headphones, Bose Headphones, Sony TV, SanDisk music player, SanDisk Pen drive, Seagate Hard disk, HP Laptop.

🧠