Automate

 View Only
  • 1.  Query syntax for Reference List data in Automate Evolve Composer

    Posted 20 days ago

    Hello all,

    I am using the Query form element to connect to reference list data in order to populate a table within my form. My issue is that I want to filter on a column in the reference list that has multiple values that are comma separated. Does anyone know the correct syntax to use here for something like CONTAINS in SQL? I could always use JavaScript to populate the table as well but would like to find a way with the query. 

    I am attaching a screenshot of the reference list and what I currently have in the form. For my example, I want a query that will return only the Forwarding Agents that contain the listed Sales Org and have the Active column set as 'Y'. So if a user inputs 1087 as the sales org in the form, it should return 306360 and 306367 on the list in the table.

    Any thoughts or assistance anyone can provide would be appreciated!

    Thanks,

    Knavis



    ------------------------------
    Knavis McGowan
    Master Data Specialist
    ABBOTT RAPID DX INTERNATIONAL LIMITED
    FL
    ------------------------------


  • 2.  RE: Query syntax for Reference List data in Automate Evolve Composer

    Employee
    Posted 20 days ago

    Hi Knavis

    If you are using a raw query, that is SQL. So try it like a WHERE clause

    Active = 'Y' and OnlySalesOrg like '%[xpath-to-selected-sales-org]%'

    Hope that helps,

    Sigrid



    ------------------------------
    Sigrid Kok
    Precisely Software Inc.
    ------------------------------



  • 3.  RE: Query syntax for Reference List data in Automate Evolve Composer

    Posted 19 days ago

    This worked for me, thanks Sigrid!



    ------------------------------
    Knavis McGowan
    Master Data Specialist
    ABBOTT RAPID DX INTERNATIONAL LIMITED
    FL
    ------------------------------



  • 4.  RE: Query syntax for Reference List data in Automate Evolve Composer

    Employee
    Posted 19 days ago

    Excellent, Knavis!  Thanks for letting us know!

    Best Regards,

    Sigrid



    ------------------------------
    Sigrid Kok
    Precisely Software Inc.
    ------------------------------