The find query is used to get entries from the database. For more information about filtering, see on the search query page.
If you don't specify, which collection fields should be got, all collection fields will be returned
Every time, where a collection is a parameter, you could choose between the database collection object or just the name as a string
To simple get fields, just write all fields in the get method as strings.
query.get("field1", "field2", "field3")
Getting fields from specific database collection¶
This is used, if you join in multiple database collections, and one collection field is multiple times represented.
Getting with an alias¶
This is used, if you want to have another name of the field in your result. It is needed, if you want to get two or more fields, which are multiple represented in the result, for example because of a join.
This is also available with a database collection.
query.get(collection, "field1", "someOtherName")
Getting with an aggregation¶
This is used, if you would like to handle your result with an aggregation, like summing all numbers of a field.
Getting with a function¶
These functions are available