Skip to Content
0

Query to list SI_FILE1 from SI_PROCESSINFO.SI_FILES

Aug 03, 2017 at 11:48 AM

62

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded

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

0
Former Member
Joe Peters

Sorry Joe,

I have updated my question

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Joe Peters Aug 03, 2017 at 12:04 PM
1

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks much Joe..

0