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