> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SearchEngine

> An in-depth guide to the SuperOffice CRMScript SearchEngine - a tool for building SQL queries by adding fields, criteria, and data.

## 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][1], the SearchEngine automatically joins tables using [dot-syntax][2] - 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.
</Note>

## Related content

* [Database basics][11]
* [Dot-syntax][12]
* [Building a query][13]
* [Running a query][14]
* [Exploring search results][15]
* [Insert, update, and delete][16]
* [Using the SearchEngine class (blog post)][17]

[1]: ./se-select

[2]: ./dot-syntax

[11]: ./db-basics

[12]: ./dot-syntax

[13]: ./se-select

[14]: ./se-run

[15]: ./se-results

[16]: ./se-insert-update-delete

[17]: ./using-the-searchengine-class-blog-post


## Related topics

- [SearchEngine](/en/automation/crmscript/reference/CRMScript.Native.SearchEngine.md)
- [Using the SearchEngine class in ejScript](/en/automation/crmscript/searchengine/using-the-searchengine-class-blog-post.md)
- [Exploring search results](/en/automation/crmscript/searchengine/se-results.md)
- [Building a query](/en/automation/crmscript/searchengine/se-select.md)
- [GenericSearch](/en/automation/crmscript/reference/CRMScript.Native.GenericSearch.md)
- [CRMScript best practices](/en/automation/crmscript/code-quality/best-practices.md)