Simple Query Structures

In your simple query you can add entities and structures, through the Simple query editor.

Usually you will only require entities in your simple query, but in some situations structures will facilitate certain operations, for example:

When you want to add business logic that is not mapped in your database model. If you want to present some computed value not directly derivable from the row data (and by definition not available in your database model), you can add a structure to your simple query and evaluate it during Preparation. Suppose you have an entity that has the Amount attribute and you want to display in each row of your Table Records or List Records the cumulative value of this attribute.

When you want to add inputs to your Table Records or List Records that are not mapped to your entities attributes. Suppose you want to add a Check Box that will allow the end-user to delete more than one row at the same time. Simply add a structure with a boolean attribute, ToBeDeleted, to your query and then the logic associated with the Delete button can delete all the rows in which the user set ToBeDeleted to true (by checking the Check Box).