DataMgr Build 2 Documentation: Check Existence
DataMgr Information
|
| Subscribe to DataMgr |
| Visit this group |
Check Existence
While DataMgr is very good at retrieving data, sometimes you don't need to actually get the data - you just need to know that it is there.
For that, DataMgr has a method called "hasRecords" that takes the same arguments as "getRecords"
hasRecords() Arguments:
- tablename (required): The table from which to return a record.
- data (optional): A structure with the data for the desired record. Each key/value indicates a value for the field matching that key. (for tables with a single-field primary key a simple value matching that field will also work)
- advsql (optional): A structure of SQL statements (only the "WHERE" is relevant here)
- filters (optional): An array of filters
The "hasRecords" argument is more efficient for this purpose as it only returns a boolean instead of a query an internally runs a query that does an EXISTS check rather than running a full query and checking for RecordCount.
Check for Table
You can also check to see if DataMgr is aware of a table by running the "hasTable" method (which just takes a "tablename" argument).