BPM, Workflow, and Case

BPM, Workflow, and Case

Come for answers. Stay for best practices. All we’re missing is you.

 View Only

  • 1.  Content Integration Task: Search

    Posted Wed March 18, 2020 02:29 PM
    Hi,

    Anybody familiar with the Content Integration Task called Search? I find limited documentation on this.
    What I need is to search for a folder based on 2 properties. I'm struggeling with the CMIS Query.

    "Select * FROM cmis:folder WHERE cmis:name = '12345'"

    I seem to get a result, but all my resultSet is empty.


    ------------------------------
    Patrick Nagtzaam
    ------------------------------


  • 2.  RE: Content Integration Task: Search

    Posted Thu March 19, 2020 05:00 AM
    Your query works fine in my environment (of course given that '12345' is changed to the name of an existing folder). Do you get anything in the result set if you remove the WHERE clause? Are you searching in the right repository? (Is it correctly configured in the Process App Settings > Servers tab?)
    Rgds, Jan

    ------------------------------
    Jan Andersson
    ------------------------------

    Original Message


  • 3.  RE: Content Integration Task: Search

    Posted Thu March 19, 2020 10:39 AM
    If you are not used to CMIS queries against the BPM (or other) Content Store, I would suggest the feature from Desktop PD (which is unfortunately not yet ported to Web PD - at least as of BAW 19.0.0.2) that automatically builds CMIS query strings for you. 

    To do this, open Desktop PD, create an Integration Service, add a Content Integration to your diagram, select the server and use the "Search" operation in the step's implementation section. A "Content Filters" tab will magically appear at the top of your diagram. From there you'll be able to create a query by adding search criteria. This will help build a CMIS query string in your step's CMIS query Data Mapping.

    If nothing else it will give you a hint about the available properties you can query -- And it will show you "live" the result of your queries on the "Content Filters" tab.

    ------------------------------
    Eric Ducos
    ------------------------------

    Original Message


  • 4.  RE: Content Integration Task: Search

    Posted Thu March 19, 2020 11:03 AM
    These queries mostly follows CMIS specification with addition to some IBM specific keywords like IBM_BPM_Document_UserId, IBM_BPM_Document_FileType etc. 

    If you are looking for documentation of CMIS specification, here is one URL - http://docs.oasis-open.org/cmis/CMIS/v1.0/os/cmis-spec-v1.0.html

    ------------------------------
    AtanuRoy
    IBM Digital Business Automation Expert
    Barclays
    ------------------------------

    Original Message


  • 5.  RE: Content Integration Task: Search

    Posted Mon May 24, 2021 11:20 AM
    Edited by Ailin Cao Mon May 24, 2021 11:27 AM
    I encountered this problem. For future reference, some objects (e.g. Map data type) display as <Empty> in the debugger, although the data does exist and the code will run as normal. 

    You can confirm this hidden data by creating DEBUG variables e.g. tw.local.DEBUG_resultsLength = tw.local.ecmSearchResult.resultSet.row.listLength; or just running the code and viewing the results.

    More info here: https://www.ibm.com/mysupport/s/question/0D50z00005q4LCz/why-cant-i-see-the-values-when-using-a-map-data-type-as-a-return-value-of-a-nested-service-from-within-my-client-side-human-service?language=en_US

    ------------------------------
    Ailin Cao
    ------------------------------

    Original Message