Main Entity Component

The Main Entity component serves as the foundation for your query, specifying the base data source from which records are pulled. This is equivalent to the FROM clause in an SQL SELECT statement.

The entity selected during query creation is automatically pre-filled here and can be changed as needed.

Features of the Main Entity Component

1. Main Entity Dropdown

   • The Main Entity selected during query creation is automatically set in the Main Entity component.

   • The Main Entity can be changed using the dropdown menu, determining the starting point of the query, with other query elements built on top of this entity.

   • If the entity is changed after setting conditions or joins, those elements will be reset, requiring configuration again.

2. Available Actions for the Main Entity Component

   • Add Related Entity (Joins): The main entity can be joined with related entities by clicking the Add Related Entity icon on the component’s header. This action allows connecting different data sources.

   • Add Group: Groups allow bundling multiple conditions together for more advanced logical filtering.

   • Add Condition Row: Conditions allow filtering data based on specific properties of the entity.

3. Specify Outputs for the Main Entity

   • The Outputs icon allows selecting the properties to return from this entity in the query results.