...
The back office table is imported into iShare as a Standard Data Share Connection so that this status information is in the iShare PostgreSQL database. A PostgreSQL view is then defined which will be the source data used by the Data Share Lookup which contains a row for all cases in at_incidents, the relevant information from the back office table where it exists and default values for new records. An example view definition is shown below:
...
Once the view is defined in order to use it with a Data Share Lookup you must define an Internal Data Share Connection which simply selects all records from the view e.g.
...