Integration Data Source Queries
- Last UpdatedMar 14, 2024
- 1 minute read
The data that is transferred into AVEVA Engineering is taken from the results the following pre-defined SQL queries if they are available, rather than directly from the database tables:
|
SR# |
Item Type |
Query Name |
|---|---|---|
|
1 |
Lines |
EXCEL_LINELIST |
|
2 |
Instruments |
EXCEL_INSTLIST |
|
3 |
Equipment |
EXCEL_EQULIST |
|
4 |
Line Fittings |
EXCEL_INLNLIST |
|
5 |
Nozzles |
EXCEL_NOZLIST |
|
6 |
Valves |
EXCEL_VLVLIST |
These queries are supplied by default with the AVEVA P&ID database and can be viewed, and if required edited using facilities provided by AVEVA P&ID Reports (refer to the "Creating Reports using User Defined Queries" topic in the AVEVA P&ID Reports documentation for details).
The queries include the following columns: Name, Drawing No + Sheet No, and Branch Id (for the Lines query) or Handle (for the other queries). These are required by the interface and must not be deleted if the queries are edited.
If the queries are not available, the tables will be used by the interface instead.