Genesys Cloud - Main

 View Only

Sign Up

  Thread closed by the administrator, not accepting new replies.
  • 1.  Architect - Logical Switch - Datatable

    Posted 08-19-2020 10:37
    No replies, thread closed.
    I am trying to leverage the Logical switch function in my Inbound flow, but can't figure out the correct expression to use. I want to search multiple data tables at a time, without having to stack them one after another. 


    Customer inputs account number, then logical switch, with 4 data tables, 1 for each case on the switch. Search tables, first one that has that account number listed in it, is the flow that is used. 

    Thanks in advance Genesys Community! 

    #ArchitectureandDesign

    ------------------------------
    Blake Anderson
    Celink
    ------------------------------


  • 2.  RE: Architect - Logical Switch - Datatable

    Posted 08-19-2020 19:14
    No replies, thread closed.
    You will have to cascade the searches and that will prioritize the tables for the search.  If you are looking to look at all for at once, either you need to combine into a single table or use a web service that can search and then make a determinization about which is valid.

    ------------------------------
    Robert Wakefield-Carl
    Avtex Solutions, LLC
    Contact Center Innovation Architect
    robertwc@avtex.com
    https://www.Avtex.com
    https://RobertWC.Blogspot.com
    ------------------------------



  • 3.  RE: Architect - Logical Switch - Datatable

    Posted 08-21-2020 19:41
    No replies, thread closed.
    Hi Blake:

    Data Tables work more like Excel 'VLOOKUP' than SQL 'SELECT' ...

    So to 'nest' the data you will have to save the output/s from each Data Table Lookup as a Task Variable, then use that as the Key in your subsequent Lookups.

    Cheers!

    ------------------------------
    Thanks and regards,

    Malcolm Green (GCP - PureCloud)
    Nexon Asia Pacific
    ------------------------------