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
- 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:
- return rows whose “ticket” column is “regular”
- returns rows that have “regular” in any column
Use “|” to OR results and “&” to AND results.
Note: ORing breaks the ANDing
cnd1 & cnd2 | cnd3 | cnd4 & cnd5 & cnd6
Conditions 1 and 2 must be satisfied for a student to show
Condition 3 must be satisfied for a student to show
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.