Tables mapped to the CDR are available (Select Tables for External Product Direct Cache SQL Access field).
In the User Definition and User Role Definition forms, CDR SQL tables names display the Caché namespace, the SQL Schema, and SQL table name. For example, in the SQL table 'CWSLiveSYSTEM.nutrition_assessment' myAvatar CWSLive is the namespace, SYSTEM is the table schema, and 'nutrition_assessment' is the table name.
Display User Role
Adding SQL tables to the CDR affects the parent application only.
The report generated in this form contains assigned CDR tables sorted by SQL Schema for a user role. The table schema is listed as the Caché namespace and child application schema. The individual SQL tables are listed under the schema heading.
Forms in Child Applications
Envelope Definition
Place user-defined data collection instruments in the CDR. All SQL tables in the envelope are included.
In the following myAvatar forms, a CDR database can be selected for a direct SQL report.
The report can be run against all SQL tables in the parent application database:
