Skip to Content
0
Former Member
Aug 04, 2016 at 06:04 AM

BI Query Builder - How to get Scheduling Info

1957 Views

Hello,

When running SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND='Publication'

One gets all the different info fields of each Publication. these are grouped under "Properties", "Scheduling Info" and "Processing Info" chapters.

How can I retrieve selected fields (e.g. SI_MACHINE) from the Scheduling Info chapter or use them in the WHERE clause.

I tried

SELECT SI_MACHINE FROM CI_INFOOBJECTS WHERE SI_KIND='Publication'

but that returned only empty lines with no info

When I try this

SELECT top 10000 SI_NAME FROM CI_INFOOBJECTS WHERE SI_KIND='Publication'

and SI_MACHINE is not null

it returns 0 lines.

Can anyone help me here, please?

Thanks

Misch