-
Notifications
You must be signed in to change notification settings - Fork 9
GPVQuery
Peter Girard edited this page Apr 29, 2017
·
2 revisions
Each layer in the GPV can have one or more queries associated with it. These queries display data about the selected features in the selection data grid. Queries can also filter the selected features based on certain criteria.
- QueryID - The unique identifier for this query (not null). This can be the same as the display name. This does not currently appear as a foreign key in other tables -- it is here for consistency and to support future expansion.
- LayerID - The ID of the GPV layer this query is connected to (not null). Links to GPVLayer.
- DisplayName - The name of this query on the interface (not null).
- ConnectionID - The database connection for the stored procedure. If null, defaults to the configuration database. Links to GPVConnection.
- StoredProc - The name of the stored procedure which provides the result set for this query (not null).
- SequenceNo - A number specifying the display order of this query (not null).
- Active - Specifies whether this query should be available for use, 1 for yes and 0 for no. If null, defaults to 0 (no).