Overview of Database Tables

Owned by Trello (Unlicensed)
Last updated: Oct 21, 2014 by Eileen Reilly-Horch (Unlicensed)
1 min read

Swift MEAPâ„¢ uses a local database containing a number of tables that store information for the Swift MEAPâ„¢ client application. The tables store information about, for example, the configurations for the Swift MEAPâ„¢ client application, the records that are accessible in the client application, and the requests waiting to be synchronized with the data source.

You can access the local database tables using the Swift MEAP client application and JavaScript. For example:

  • You can use the tables as part of the filter criteria for JavaScript Object Notation (JSON)
  • You can directly query the tables using the JSON Select action.
For example, cad_menuitems stores a list of modules that are enabled on user devices. 

 

The following example for a Select action queries for AttendeeCalls (Module 64) in cad_menuitems and invokes the isAttendeeCallModuleExist function, which checks the results to determine if the module is enabled.

If the module is enabled, then certain actions are performed. If the module is not enabled, then no other actions are performed.

return "[{\"action\":\"select\",\"invoke\":\"isAttendeeCallModuleExist\",\"parameters\": [ {\"modulefields\": [ {\"module\":\"cad_menuitems\", \"fields\":\"module_id\"} ], \"filter\":\"module_id=64\"} ] } ]";


You can use the tables when trying to diagnose issues that occur, especially when using JavaScript in Swift MEAP client application.
For more information, see "Swift MEAP Local Database Tables".