Create data reader patterns - SmartPlant Foundation - IM Update 48 - Help - Hexagon

The data reader pattern is used for retrieving information from a database. It consists of predefined statements that retrieve selective data from the database. You can do the following to create a data reader pattern.

• Add table joins to combine records from different tables.

• Add look up file path to refer to a look up file. The look up file is an XML file that can be used for calculation and to modify the data display.

• Add unit of measurements for specific properties.

• Add WHERE condition to specify condition for the data to be retrieved.

• Create mappings to modify the display of the extracted data.

• Apply converters to change the data.

Click a box in the diagram to go to the associated procedure.

What do you want to do?

• Create a data reader pattern

• Define the data reader pattern

• Join tables

• Map selected fields

• Create a WHERE clause

• Create custom properties