trinity/search

Trinity Search bundle

Installs: 4 066

Dependents: 4

Suggesters: 0

Security: 0

Stars: 1

Watchers: 15

Forks: 0

Open Issues: 0

Type:symfony-bundle

v1.0.4 2017-12-02 18:56 UTC

This package is not auto-updated.

Last update: 2020-07-01 19:18:38 UTC


README

#Trinity Search

Coverage Status Build Status

Trinity search is part of Trinity package.

Description:

  • Finds array of objects by given query

Base route:

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

##Syntax Append query to the base route. Query can be composed of:

  • (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

#####Example

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