6 Replies Latest reply: Nov 25, 2013 3:03 AM by user8013558 RSS

    Search by custom metadata in framework folders

    user8013558

      Hi everyone,

       

      I have framework folders in Webcenter Content. I have seen the FLD_FOLDER_SEARCH service and it works fine when I search by metadata like owner, fParentGUID, etc.

       

      When I want to search by custom metadata (other metadata field that I created) with this service, It doesn't work. The metadata field is an invalid identifier for the FolderFolders table....

       

      I have seen that it concats in the QueryText parameter the different metadata field...

      QueryText=fParentGUID+%3Cmatches%3E+%6007430A15D82B558DD51F16E112AE3CEB%60++%3CAND%3E++fOwner+%3Csubstring%3E+%60XXXXXXX%60++%3CAND%3E++xCustom+%3Csubstring%3E+%60FAV%60

       

      The exception is: java.sql.SQLSyntaxErrorException: ORA-00904 invalid identifier

       

      How can I search by custom metadata? Is it the FLD_FOLDER_SEARCH service the right service?

       

      Thanks in advance

      Carlos