Use the examples in this section as an aid when creating your own ‘custom’ Lists. The examples demonstrate how to produce:
- A List of Points that have Invalid Configuration
- A List that Contains Information that is Relevant to a Particular Group Instance
- A Custom Pick Action to Display a List of Out of Service Points
- Lists in Which only the Entries in Particular Columns Change Color.
ATTENTION: Any SQL queries for ‘custom’ Lists should be written by engineers who have the appropriate experience and knowledge of the SQL language. Running a badly designed SQL query can have an adverse affect on the system. All queries should include suitable restrictions to limit the number of records that are retrieved from the database. An SQL query that queries vast amounts of data will affect the performance of the server while that query executes.