trinity/search

Trinity Search bundle

Trinity Search

, _(*1)

Trinity search is part of Trinity package., _(*2)

Description:, _(*3)

• Finds array of objects by given query

Base route:, _(*4)

/admin/search/{entity}/?q=

Syntax

Append query to the base route. Query can be composed of:, _(*5)

• (optional) Column selection - put columns which you want to return into simple brackets. If you want to access column from associated table, simply put colon and name of the column from associated table

(column1,column2,column3,column4:attributeFromAssociatedTable:anotherAttribute)

• (optional) Conditions - put conditions into curly brackets. Available operators: <, >, =, <=, >=, !=, AND, OR

{column1 > 500 AND column2 < 800 OR (column3 = <str>JohnDoe</str> AND column4 <= 20)}

• String Values must be wrapped inside block

{name = <str>Jack</str> AND description LIKE <str>%it started as "game"%</str>}

• (optional) Limit - for limit 5 rows simply append

LIMIT=5

• (optional) Offset - for offset 10 rows simply append

OFFSET=10

• (optional) Ordering - for ordering result, append keyword ORDER BY and then columns and directions by which you want to order, multiple columns ordering are supported - separate columns by comma

ORDERBY column1 ASC, column2 DESC

, _(*6)

Example

/admin/search/product/?q=
(id,name,defaultBillingPlan:initialPrice)
{defaultBillingPlan:initialPrice > "14"} LIMIT=10 OFFSET=0 ORDERBY clients:name ASC, defaultBillingPlan:initialPrice DESC