Table DESKI_QUERY_OBJECTS

Desktop Intelligence Result and Condition objects in the query panel.

 

Column Name

Data Type

Description

CLASSID

int

Foreign key to UNV_CLASSES.CLASSID

CLASSNAME

nvarchar

Class name to which this deski query objec belongs

CONDITIONOPERAND

nvarchar

Condition operand

CONDITIONOPERATOR

nvarchar

Condition operator

CONDITIONTYPE

nvarchar

Type of condition

CREATED

datetime

The datetime an object was created (for the first time) in the BusinessObjects CMS; Equivalent to SI_CREATION_TIME

DESKI_DATAPROVIDERS_ID

int

Foreign key to DESKI_DATAPROVIDERS.ID

DESKI_DOCUMENTS_ID

int

Foreign key to DESKI_DOCUMENTS.ID

DESKI_QUERIES_ID

int

Foreign key to DESKI_QUERIES.ID

DESKICUID

varchar

CUID of the Deski document

DESKIMUID

varchar

MUID of the Deski document

FORMULA

nvarchar

Formula of the query object

ID

int

Unique ID of the Object (globally unique)

ISCONDITIONOBJECT

bit

Is the object a condition object?

ISFROMDATAPROVIDER

bit

Is the object sourced from a dataprovider?

OBJECTID

int

Unique OBJECTID of the Deski result or condition object

OBJECTNAME

nvarchar

Name of the object

QUALIFICATION

nvarchar

Qualification of the object

UNIVERSECUID

varchar

CUID of the universe to which the object belongs

UNIVERSEMUID

varchar

MUID of the universe to which the object belongs

UNV_OBJECTS_ID

int

Foreign key to UNV_OBJECTS.ID: NOT USED

UNV_UNIVERSES_ID

int

Foreogin key to UNV_UNIVERSES.ID: NOT USED

UPDATED

datetime

Datetime that this object was updated in the BusinessObjects CMS

 

 

 
See also

MetaMiner Database Fields

 

© 2013-2015 by Infolytik