Skip to Content
avatar image
Former Member

Query to list SI_FILE1 from SI_PROCESSINFO.SI_FILES

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 03, 2017 at 12:04 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded