cancel
Showing results for 
Search instead for 
Did you mean: 

Query to list SI_FILE1 from SI_PROCESSINFO.SI_FILES

Former Member
0 Kudos

Hi,

Can anyone please suggest a query for listing SI_FILE1 from SI_PROCESSINFO.SI_FILES?

I tried this query

SELECT SI_PROCESSINFO.SI_FILES.SI_FILE1 FROM CI_INFOOBJECTS

but showing below result.
1/1000

2/1000 etc

regards,

Sarath

Joe_Peters
Active Contributor
0 Kudos

There is no si_files property back in si_scheduleinfo. What are you trying to do?

Former Member
0 Kudos

Sorry Joe,

I have updated my question

Accepted Solutions (1)

Accepted Solutions (1)

Joe_Peters
Active Contributor

You can't SELECT a sub-property of a property bag in a CMS query, only the parent bag. So use:

SELECT SI_PROCESSINFO.SI_FILES FROM CI_INFOOBJECTS

then extract the si_file1 property from the result.

Former Member
0 Kudos

Thanks much Joe..

Answers (0)