Manage Entity Records

Once the entities and their attributes are created in your eSpace, you have the following facilities to manage the entity records.

Entity Actions

Entity Actions are used when you just want to handle single records and you don't need extra clauses, for example if you have an order in a SELECT. Learn more about Entity Actions.

Simple Query

Used when you want to query more than one entity and you need to use the SELECT statement with its full possibilities (order by, joins and conditions). In this case, you have to use the Query element. Learn more about Simple Queries.

Advanced Query

Used when you want to execute any SQL statement for the entities. In this case, you have to use the Advanced Query element. Learn more about Advanced Queries.

Use static entities to design your application using static data such as constants or enumerations. Learn more about Static Entities and Managing Static Entities Records.

The Query element and Advanced Query element are executed in an Action flow; they can read more than one entity at the same time and their results are stored in a record list.

When you want to list the contents of a single row, you can use the Get<Entity name> entity action; however, if you want to list the contents of several rows, you must use a query, simple or advanced.