The "Get from DB" activity is a convenient way to quickly retrieve data from a database, independent of the type of database. The result of this activity is a list of entities, which can be used in the flow. For example, this can be used in the loop activity or the List Operation activities.
Activity properties
begin var CustomersList: ICodolexList<HelpAndManualScreenshots.DataSource.Codolex.ICustomers>; var SQL := 'SELECT Customers.* '+ sLineBreak + 'FROM Customers AS Customers ';
var Params: IDatabaseParams := TDatabaseParams.Create;
CustomersList := HelpAndManualScreenshots.DataSource.Codolex.CustomersDataBroker.GetList(SQL, Params); end; |
Resulting code
To get started, select an entity from the search list. Codolex will fill in the basic select statement. Using the "where, order by and limit results tabs" you can specify the exact statement. The return value will be a list, or a single entity if you select "first" at the Limit results tab.
