SearchEngine
An in-depth guide to the CRMScript SearchEngine
The SearchEngine is a tool for building SQL queries by adding fields, criteria, and data.
It was initially created for searching and fetching data from the database. Thereby its name. Since then, it has been extended with features for inserting and updating rows.
When you construct a query, the SearchEngine automatically joins tables using dot-syntax - for example ticket.title.
All queries are sent to NetServer instead of directly to the database. This ensures that sentry rules are followed. It is possible to circumvent this behavior, but if you do, you need to handle any security implications yourself.
Note
Udefs and interests are not available through SearchEngine! You need to access these through NetServer entities.
If SearchEngine is your only option or you need to be able to profile these fields, they could be synchronized to an extra field with a regular task.