• String
  • Including Special Characters in String Filters
• Date & Time
  • Basic Structure of Date and Time Filters
  • Absolute Dates
  • Relative Dates
• Boolean
• Number
• Interval Notation
  • Open Interval
  • Closed Interval
  • Half-open Interval
  • Non-ending Interval
  • Multiple Intervals
  • Intervals and Numbers at the Same Time
  • Using NOT

Filter expressions are an advanced way to filter Seven Senders Portal queries, and this page describes how to write them. In the Explore section of Seven Senders Portal you can use them by adding a filter and choosing the matches (advanced) option. 

 String

Including Special Characters in String Filters

Note these rules for including special characters in string filters:

• To include % or _, prefix with the escape character, ^. For example: ^% and ^_
• To include ^, escape it as ^^.
• To include a comma in a string filter, prefix the comma with a backslash character, \. For example: Santa Cruz\, CA.
• To include a comma with the matches (advanced) option in a filter, prefix the comma with the escape character, ^. For example: Santa Cruz^, CA.
• To include a comma in a filter expression in Seven Senders Portal, prefix with the escape character, ^. For example: 

  
  

  field: filtered_count {

    type: count

    filters: {

      field: city

      value: "Santa Cruz^, CA"

    }

  }

Date & Time

Seven Senders Portal date filtering allows for English phrases to be used instead of SQL date functions. For all the examples below assume today is Friday, 2018/05/18 18:30:02. In Seven Senders Portal Analytics, weeks start on Monday.

Basic Structure of Date and Time Filters

For the following examples …

• {n} is an integer.

• {interval} is a time increment such as hours, days, weeks, or months.

  The phrasing you use determines whether the {interval} will include partial time periods or only complete time periods. For example, the expression 3 days includes the current, partial day as well as the prior two days. The expression 3 days ago for 3 days includes the previous 3 complete days and excludes the current, partial day. See the Relative Dates section for more information.

• {time} is a time of the form YYYY-MM-DD HH:MM:SS or a date of the form YYYY-MM-DD.

These are all the possible combinations of date filters:

• this {interval} - For example: this day
• {n} {interval} - For example: 3 days
• {n} {interval} ago - For example: 3 days ago
• {n} {interval} ago for {n} {interval}
• before {n} {interval} ago
• before {time}
• after {time}
• {time} to {time}
  The initial time value is inclusive. The latter time value is not. So the expression 2018-05-18 12:00:00 to 2018-05-18 14:00:00 will return data with the time “2018-05-18 12:00:00” through “2018-05-18 13:59:59”.
• {time} for {n} {interval}
• today
• yesterday
• tomorrow
• next {week, month, quarter, fiscal quarter, year, fiscal year}
  The next keyword is unique in that it requires one of the intervals listed above, and will not work with other intervals.
• {n} {interval} from now
• {n} {interval} from now for {n} {interval}

Date filters can also be combined together:

• To get OR logic: Type multiple conditions into the same filter, separated by commas. For example today, 7 days ago means “today or 7 days ago”.
• To get AND logic: Type your conditions, one by one, into multiple date or time filters. For example you could put after 2014-01-01 into a Created Date filter, then put before 2 days ago into a Created Time filter. This would mean “after January 1st, 2014 and before 2 days ago”.

Absolute Dates

Absolute date filters use the specific date values to generate query results. These are useful when creating queries for specific date ranges.

Relative Dates

Relative date filters allow you to create queries with rolling date values relative to the current date. These are useful when creating queries that update each time you run the query.

Seconds

Minutes

Hours

Days

Weeks

Months

Quarters

Boolean

Filtering on true or false type values in Seven Senders Portal requires you to know what type of true or false value you’re interacting with.

Number

Filters on numbers support both natural language expressions (for example 3 to 10) and relational operators (for example >20). Seven Senders Portal supports the OR operator to express multiple filter ranges (for example 3 to 10 OR 30 to 100). The AND operator can be used to express numeric ranges with relational operators (for example >=3 AND <=10) to specify a range.

Interval Notation

Filters on numbers can also use algebraic interval notation to filter numeric fields.

Open Interval

While this notation resembles an ordered pair, in this context it refers to the interval upon which you are working.

Closed Interval

Half-open Interval

Non-ending Interval

Note: inf may be omitted and the above may be written as (a,) or (,a]

Multiple Intervals

The union of multiple intervals may be expressed with a comma. For example:

Intervals and Numbers at the Same Time

Using NOT