
Function | Desription |
---|---|
COUNT | Retrieves the number of distinct values of a property |
TOP | specifies the maximum number of object to be returned |
SELECT TOP 10 * FROM CI_INFOOBJECTS WHERE SI_KIND = 'WEBI' ORDER BY SI_CHILDREN DESC
Operators |
---|
= |
!= |
< |
> |
<= |
>= |
IN |
LIKE |
BETWEEN |
ALL |
InfoObject property | Property description |
---|---|
SI_ID | Unique id generated for the Infobject within the environment |
SI_NAME | Name of the InfoObject |
SI_KIND | Type of the Infoobject |
SI_CUID | Cluster Unique Identifier of the InfoObject |
SI_GUID | Global Unique Identifier of the InfoObject |
SI_RUID | Unique id of the Infobject within the Object package |
SI_PARENTID | Parent Objects SI_ID |
SI_OWNERID | SI_ID of the InfoObject's owner |
SI_CREATION_TIME | Creation time of InfoObject |
SI_UPDATE_TS | Last updated time of InfoObject |
SELECT SI_ID, SI_KIND, SI_NAME,SI_CUID, SI_GUID, SI_RUID, SI_PARENTID, SI_OWNERID, SI_CREATION_TIME,SI_UPDATE_TS FROM CI_INFOOBJECTS WHERE SI_KIND='WEBI'
BusinessObjects Query builder - Basics
BusinessObjects Query builder – Best practices & Usability
Sample Queries
BusinessObjects Query builder queries
BusinessObjects Query builder queries - Part II
BusinessObjects Query builder queries - Part III
BusinessObjects Query builder queries - Part IV
BusinessObjects Query builder – Exploring Visualization Objects
BusinessObjects Query builder – Exploring Monitoring Objects
BusinessObjects Query builder - Exploring Lumira & Design studio Objects
Use cases
BusinessObjects Environment assessment using Query builder
BusinessObjects Environment Cleanup using Query builder
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
20 | |
19 | |
9 | |
7 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 |