Open topic with navigation

ADHOCQUERY (4.0SP12)

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

Each row in the ADHOCQUERY table corresponds to a user-defined query definition, including all of the information required to build a valid sql statement.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
QUERYVIEWCATALOGID	uniqueidentifier	false	QUERYVIEWCATALOG.ID	FK to QUERYVIEWCATALOG
QUERYCATEGORYCODEID	uniqueidentifier	true	QUERYCATEGORYCODE.ID	FK to QUERYCATEGORYCODE
DATAFORMINSTANCEID	uniqueidentifier	true	DATAFORMINSTANCECATALOG.ID	FK to DATAFORMINSTANCECATALOG
OWNERID	uniqueidentifier	false	APPUSER.ID	ID of the application user who created the query.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
SITEID	uniqueidentifier	true	SITE.ID	FK to SITE
FOLDERID	uniqueidentifier	true	ADHOCQUERYFOLDER.ID	FK to ADHOCQUERYFOLDER

Fields
Field	Field Type	Null	Notes	Description
NAME	nvarchar(255)	false	''	Name of the query
DESCRIPTION	nvarchar(1024)	false	''	Description for the query
QUERYDEFINITIONXML	xml	false		xml field containing the entire query definition structure, including all output fields, criteria, and sorting.
OTHERSCANMODIFY	bit	false	0	Indicates whether or not other users can modify this query.
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
SECURITYLEVEL	tinyint	false	0	0 - All roles, 1 - Selected Roles
DISPLAYORDER	int	false	0
SECURITYLEVELEDIT	tinyint	false	0	0 - All roles, 1 - Selected Roles
MOBILIZE	bit	false	0	Flag indicating whether the ad-hoc query is available to mobile devices.
ISBROWSABLE	bit	false	0	Flag indicating whether the ad-hoc query is browsable.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_ADHOCQUERY_DATEADDED	DATEADDED	False	False	True
IX_ADHOCQUERY_DATECHANGED	DATECHANGED	False	False	False
IX_ADHOCQUERY_FOLDERID	FOLDERID	False	False	False
IX_ADHOCQUERY_MOBILIZE	MOBILIZE	False	False	False
IX_ADHOCQUERY_QUERYCATEGORYCODEID	QUERYCATEGORYCODEID	False	False	False
IX_ADHOCQUERY_QUERYVIEWCATALOGID	QUERYVIEWCATALOGID	False	False	False
IX_ADHOCQUERY_SITEID	SITEID	False	False	False
PK_ADHOCQUERY	ID	True	True	False
UC_ADHOCQUERY_NAME	NAME	True	False	False

Triggers
Trigger Name	Description
TR_ADHOCQUERY_DELETE_IDSET
TR_ADHOCQUERY_AUDIT_UPDATE
TR_ADHOCQUERY_AUDIT_DELETE

Referenced by
Referenced by	Field
ADHOCQUERYIDSETDEPENDENCY	ADHOCQUERYID
ADHOCQUERYRUNINFO	ID
ADHOCQUERYSTATUS	PARAMETERSETID
APPUSERADHOCQUERYFAVORITE	ADHOCQUERYID
CMSQUERYPUBLISHING	ID
EXPORTPROCESS	ADHOCQUERYID
FAFEVENTADHOCQUERY	ADHOCQUERYID
IDSETREGISTERADHOCQUERY	ADHOCQUERYID
MKTSOURCEANALYSISRULEFIELDS	ADHOCQUERYID
SYSTEMROLEPERM_ADHOCQUERYINSTANCE	ADHOCQUERYID
SYSTEMROLEPERM_ADHOCQUERYINSTANCEEDIT	ADHOCQUERYID