Genesys Cloud - Main

 View Only

Sign Up

  Thread closed by the administrator, not accepting new replies.
  • 1.  Route multiple queues if found in data table

    Posted 04-22-2025 22:56
    No replies, thread closed.

    I have 15 queues that I want to route if found in a data table that I've created. My expression coding is very rusty . I'm trying to use Update Data to add all of the queues so the Data table lookup can search but I'm getting "not found" error. Any help will be appreciated.


    #ArchitectureandDesign

    ------------------------------
    Reuben Goodwin
    Sr. Telephony Engineer
    ------------------------------


  • 2.  RE: Route multiple queues if found in data table

    Posted 04-23-2025 11:41
    No replies, thread closed.

    Hi Reuben,

    Can you give a bit more detail on how you are updating the tables? Via API etc and maybe an example of the data and expression you are using?



    ------------------------------
    Sam Jillard
    Online Community Manager/Moderator
    Genesys - Employees
    ------------------------------



  • 3.  RE: Route multiple queues if found in data table

    Posted 04-23-2025 13:41
    No replies, thread closed.

    I am running a Voice post survey in our flow and a data table that will list queue(s) that we can turn the survey on or off based on 1 queue or all 15 queue . Ive got it work in the flow using Flow.RoutingQueue == "Queue" for 1 queue but I can get an expression together to lookup any of the 15 queues I have in the data table so when Its true it flows to Set-Post object. Flow



    ------------------------------
    Reuben Goodwin
    Sr. Telephony Engineer
    ------------------------------



  • 4.  RE: Route multiple queues if found in data table

    Posted 04-23-2025 13:43
    No replies, thread closed.

    I've tried :  ToString(Flow.RoutingQueue) == "Queue1" or ToString(Flow.RoutingQueue) == "Queue2" as a decision but it doesnt see the 2nd queue when I have it turned on in the data table. 



    ------------------------------
    Reuben Goodwin
    Sr. Telephony Engineer
    ------------------------------



  • 5.  RE: Route multiple queues if found in data table
    Best Answer

    Posted 04-23-2025 23:28
    No replies, thread closed.

    I think you may be over complicating it.

    When you do a data table lookup, you pass they key which assuming is your queue name, and if the value is found it returns that row, you don't need to check each row separately. If that queue isn't found, it will go down the not found path - If you had a list of queues in the routing you wanted to iterate over you could do a loop doing a data table look up for each value in the list, but that doesn't seem to be the case here. 

    For example:

    Here I have a simple data table with queue names and a boolean if the survey should be active

    In my Flow

    Lets say I've determined Task.RoutingQueue == Queue1

    Well it the data table lookup will happen, it will find the Row with Queue1 and set Task.isSurveyActive to false and go down the no path in my decision, I don't need to check anything else.

    If Task.RoutingQueue == Queue2 then it will go down my Yes path and offer a survey,

    If Task.RoutingQueue == Queue3 then it will go down the Not Found path.

    I don't need to check every value, just the one I'm interested in.

    If you do need to check multiples, let me know and I can show you an example with a loop

     



    ------------------------------
    Anton Vroon
    ------------------------------



  • 6.  RE: Route multiple queues if found in data table

    Posted 04-24-2025 07:59
    No replies, thread closed.

    Hello Anton , Yes I will need to check Multiples I am interested in the example of using loops.



    ------------------------------
    Reuben Goodwin
    Sr. Telephony Engineer
    ------------------------------



  • 7.  RE: Route multiple queues if found in data table

    Posted 04-25-2025 04:11
    No replies, thread closed.

    I guess I don't quite understand the use case for why it would require a look up of several queues.

    But if that is really needed then I think it would be better to extract the Data Table into arrays with one API call and use FindFirst in Architect to find the values, instead of looping a Data Table action over and over again.



    ------------------------------
    Jan Heinonen
    Contact Center Specialist
    GlobalConnect AB
    ------------------------------



  • 8.  RE: Route multiple queues if found in data table

    Posted 04-27-2025 16:47
    No replies, thread closed.

    As Jan mentioned, you could do this through API instead, which would be more efficient, and certainly if you have a lot of queues, that would be a much better option.

    However if you want to do this without APIs It would looks something like this:

    First I have a list of Queues, maybe this came from participant data, but start with a list. Use the split function if you are starting with a string.

    Create a loop with a loop count equal to your list

    Then in your data table input within the loop, either one of the following should work

    Then the rest is similar but I guess you want to then store which ones are active, in a new array

    Which is in this step

    Doing this by API will still require a similar loop, but you are just looking up the table once, then looping through the array instead of the data table lookups will save some time and just be a little more efficient since you are only looking up the table once. 



    ------------------------------
    Anton Vroon
    ------------------------------