Once the entities and their attributes are created in your eSpace, you have the following facilities to manage the entity records.
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.
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 Aggregate element.
Used when you want to execute any SQL statement for the entities. In this case, you have to use the SQL element. Learn more about SQL 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 Aggregate element and SQL 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 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 an aggregate or SQL query.