Associated with: Tables other than the Event Journal (CDBEventJournal), Data Grids, and Data Tables
We recommend that Id is always included in a List’s SELECT Clause (other than when querying CDBEventJournal (whereupon you would specify RecordId instead), a Data Grid, or a Data Table).
The Id field enables SQL to retrieve dynasets of data. As such, typically only a subset of the data that is requested for a List is retrieved at any one time, rather than all of the specified data. This minimizes the loading on both the server and client, particularly when requesting large quantities of data. When a List is displayed, for those entries that are presently visible on a client, data is retrieved for all of the fields specified by that List’s SELECT clause. For the remaining entries in the List, only the Id of every required entry is retrieved from the database. Whenever the vertical scroll bar is used to display further List entries, the additional fields of data for those entries is retrieved from the database.
The Id field also enables pick action(s) to be associated with List entries.