Reference specific columns by their camel-case name. Ex: quantity, ticket, id, paymentId, email, eventName, eventId …

Available Conditional Operations:

  • “=”:  will return data that is equal
  • “>”  :  will return data that are strictly less
  • “<”:  will return data that are strictly more
  • “>”=:  (only for date search) will return data that are equal or more
  • “<”=:  (only for date search) will return data that are equal or less

Search examples:

  • quantity > 2 : will return rows with quantity greater than 2
    Note that spaces are disregarded, so quantity > 2 is valid
  • If you want to fetch all bookings for a specific ticket:
    • ticket=regular
      • return rows whose “ticket” column is “regular”
    • regular
      • returns rows that  have “regular” in any column

Use “|” to OR results and “&” to AND results.

Note: ORing breaks the ANDing

Example:

cnd1 & cnd2 | cnd3 | cnd4 & cnd5 & cnd6

Translates to:

Conditions 1 and 2 must be satisfied for a student to show
OR
Condition 3 must be satisfied for a student to show
OR
Conditions 4, 5 and 6 must be satisfied for a student to show

You cannot use (cond1 | cond2) & cond3.

To do this you will have to use:  cond1 & cond3 | cond2 & cond2

Search Examples and some shortcuts:

  • regular& quantity > 2
    • ticket=regular & quantity > 2 is equivalent but stricter (discussed above)
  • amount < 300 & quantity < 4 
    • returns rows that have amount less than 300 and quantity less than 4
  • amount < 300 & quantity < 4  | quantity < 3
    • fetches rows that either have math amount less than 300 and quantity less than 4 or quantity less than 3
  • V.I.P | V.V.I.P  
    • fetches rows with either tickets
    • again: ticket=V.I.P | ticket=V.V.I.P is equivalent but stricter
  • Regular & summer will return rows that have regular tickers and used coupon summer.
    • You can omit the “&” between strings.
    • Regular summer is identical to Regular & summer
  • Regular summer quantity > 1  DOESNT WORK, conditions should be coupled with &
    • Regular & summer & quantity > 1   WORKS

 

The above should give you an idea about the search engine. If you have any question please email me.