Entity AdHocQueryRec

Description of Entity AdHocQueryRec

This entity would record all the possible queries used by the user after a successful login. This entity would also record the type of query used, the Quick query or the Custom query. The query record can only use one type of query, but can store both queries. The storage of the query is in the Query and Custom Query, actual SQL is recorded. When the query type is for a quick query, it would retrieve or store the actual SQL statement from the attribute Query. Otherwise, it would retrieve or store the actual SQL statement from the Custom Query.


List of all Dependencies of the Entity AdHocQueryRec

Name

Code

Class Name

Relation_7185

Relation_7185

Reference

Relation_15322

Relation_15322

Reference

Relation_9786

Relation_9786

Reference


List of Attributes of the Entity AdHocQueryRec

Name

Code

Query Rec ID

QueryRecId

Description

QueryRecDesc

Query Type

QueryType

Custom Query

CustomQuery

Security Query Type

SecurityQueryType

Custom Query Entities

CustomQueryEntities


Entity Attribute Query Rec ID of the Entity AdHocQueryRec

Card of Attribute Query Rec ID of the Entity AdHocQueryRec

Name

Query Rec ID

Code

QueryRecId

Data Type

char(60)

Mandatory

Yes


Description of Attribute Query Rec ID of the Entity AdHocQueryRec

This attribute would record the identity of the list of queries belonging to a particular user. This is also the primary key for the AdHocQueryRec table.


Entity Attribute Description of the Entity AdHocQueryRec

Card of Attribute Description of the Entity AdHocQueryRec

Name

Description

Code

QueryRecDesc

Data Type

char(150)

Mandatory

No


Description of Attribute Description of the Entity AdHocQueryRec

Stores a description about the query record.


Entity Attribute Query Type of the Entity AdHocQueryRec

Card of Attribute Query Type of the Entity AdHocQueryRec

Name

Query Type

Code

QueryType

Data Type

char(1)

Mandatory

No


Description of Attribute Query Type of the Entity AdHocQueryRec

Shows the type of query.


Entity Attribute Custom Query of the Entity AdHocQueryRec

Card of Attribute Custom Query of the Entity AdHocQueryRec

Name

Custom Query

Code

CustomQuery

Data Type

char(8192)

Mandatory

No


Description of Attribute Custom Query of the Entity AdHocQueryRec

This attribute records the actual SQL query that will be executed by the program for any custom query.


Entity Attribute Security Query Type of the Entity AdHocQueryRec

Card of Attribute Security Query Type of the Entity AdHocQueryRec

Name

Security Query Type

Code

SecurityQueryType

Data Type

char(1)

Mandatory

No


Description of Attribute Security Query Type of the Entity AdHocQueryRec

This attribute would act as a flag to separate out between security or adhoc's query.


Entity Attribute Custom Query Entities of the Entity AdHocQueryRec

Card of Attribute Custom Query Entities of the Entity AdHocQueryRec

Name

Custom Query Entities

Code

CustomQueryEntities

Data Type

char(200)

Mandatory

No


Description of Attribute Custom Query Entities of the Entity AdHocQueryRec

A custom query for the entity.