hi there,
i currently have a situation whereby i have +-20 words which should be searched for in the Body and Subject of a Email/Facebook
to avoid making changes to Flow when new words needs to be added, i am using a Data table to populate the words.
this works fine when i populate each word into a row with separate Fields for each word, with this option, i still need to make changes to Flow when new words are added.

what i am aiming to achieve, is to have 1 x Row with 1 x Field where i can enter all words into one Field to avoid Flow changes, attached.

The issues are have with this option is:

1. I need to do a count of the amount of words in the Field:  State.LoopCount=Count(MakeList(State.WordCollection)
2. I need to search for words in the message from Email/Facebook = Contains(Message.Message.Body,GetAt(MakeList(State.DataTableLookup),State.LoopCount),true)
3. I need to search for 1st word in the list, then 2nd, .........
4. when the search reaches the last word the Loop must end

Can someone please advise if this is possible and what would be the best way to achieve this?
#Routing(ACD/IVR)

------------------------------
Reginald Sheraton
Bytes Systems Integration a Division of Altron
------------------------------

Hi Reginald,

I think you're getting to the point you should use a custom action and handle this logic outside of Genesys Cloud.

You could use a lambda function if you don't have another way to handle this.

Thanks,

------------------------------
Daniel McLeod
Qsect LLC
------------------------------

Original Message:
Sent: 05-19-2020 09:51
From: Reginald Sheraton
Subject: Data Table Lookup

hi there,
i currently have a situation whereby i have +-20 words which should be searched for in the Body and Subject of a Email/Facebook
to avoid making changes to Flow when new words needs to be added, i am using a Data table to populate the words.
this works fine when i populate each word into a row with separate Fields for each word, with this option, i still need to make changes to Flow when new words are added.

what i am aiming to achieve, is to have 1 x Row with 1 x Field where i can enter all words into one Field to avoid Flow changes, attached.

The issues are have with this option is:

1. I need to do a count of the amount of words in the Field:  State.LoopCount=Count(MakeList(State.WordCollection)
2. I need to search for words in the message from Email/Facebook = Contains(Message.Message.Body,GetAt(MakeList(State.DataTableLookup),State.LoopCount),true)
3. I need to search for 1st word in the list, then 2nd, .........
4. when the search reaches the last word the Loop must end

Can someone please advise if this is possible and what would be the best way to achieve this?
#Routing(ACD/IVR)

------------------------------
Reginald Sheraton
Bytes Systems Integration a Division of Altron
------------------------------

Hi Reginald,

Have you seen the latest response here:
https://community.genesys.com/digestviewer29/viewthread?GroupId=19&MessageKey=92139d18-507a-4079-8d61-6a3047ec0616&CommunityKey=bab95e9c-6bbe-4a13-8ade-8ec0faf733d4&tab=digestviewer&ReturnUrl=%2fcommunities%2fcommunity-home1%2fdigestviewer%3fCommunityKey%3dbab95e9c-6bbe-4a13-8ade-8ec0faf733d4

------------------------------
Paulo Mesquita
Spark NZ Trading
------------------------------

Original Message:
Sent: 05-19-2020 12:13
From: Daniel McLeod
Subject: Data Table Lookup

Hi Reginald,

I think you're getting to the point you should use a custom action and handle this logic outside of Genesys Cloud.

You could use a lambda function if you don't have another way to handle this.

Thanks,

------------------------------
Daniel McLeod
Qsect LLC

Original Message:
Sent: 05-19-2020 09:51
From: Reginald Sheraton
Subject: Data Table Lookup

hi there,
i currently have a situation whereby i have +-20 words which should be searched for in the Body and Subject of a Email/Facebook
to avoid making changes to Flow when new words needs to be added, i am using a Data table to populate the words.
this works fine when i populate each word into a row with separate Fields for each word, with this option, i still need to make changes to Flow when new words are added.

what i am aiming to achieve, is to have 1 x Row with 1 x Field where i can enter all words into one Field to avoid Flow changes, attached.

The issues are have with this option is:

1. I need to do a count of the amount of words in the Field:  State.LoopCount=Count(MakeList(State.WordCollection)
2. I need to search for words in the message from Email/Facebook = Contains(Message.Message.Body,GetAt(MakeList(State.DataTableLookup),State.LoopCount),true)
3. I need to search for 1st word in the list, then 2nd, .........
4. when the search reaches the last word the Loop must end

Can someone please advise if this is possible and what would be the best way to achieve this?
#Routing(ACD/IVR)

------------------------------
Reginald Sheraton
Bytes Systems Integration a Division of Altron
------------------------------

Here is another great example:

https://community.genesys.com/digestviewer29/viewthread?MessageKey=5a24fc49-d02d-4b3c-85af-99a50b336775&CommunityKey=bab95e9c-6bbe-4a13-8ade-8ec0faf733d4&tab=digestviewer#bm5a24fc49-d02d-4b3c-85af-99a50b336775

------------------------------
Paulo Mesquita
Spark NZ Trading
------------------------------

Original Message:
Sent: 05-31-2020 03:08
From: Paulo Mesquita
Subject: Data Table Lookup

Hi Reginald,

Have you seen the latest response here:
https://community.genesys.com/digestviewer29/viewthread?GroupId=19&MessageKey=92139d18-507a-4079-8d61-6a3047ec0616&CommunityKey=bab95e9c-6bbe-4a13-8ade-8ec0faf733d4&tab=digestviewer&ReturnUrl=%2fcommunities%2fcommunity-home1%2fdigestviewer%3fCommunityKey%3dbab95e9c-6bbe-4a13-8ade-8ec0faf733d4

------------------------------
Paulo Mesquita
Spark NZ Trading

Original Message:
Sent: 05-19-2020 12:13
From: Daniel McLeod
Subject: Data Table Lookup

Hi Reginald,

I think you're getting to the point you should use a custom action and handle this logic outside of Genesys Cloud.

You could use a lambda function if you don't have another way to handle this.

Thanks,

------------------------------
Daniel McLeod
Qsect LLC

Original Message:
Sent: 05-19-2020 09:51
From: Reginald Sheraton
Subject: Data Table Lookup

hi there,
i currently have a situation whereby i have +-20 words which should be searched for in the Body and Subject of a Email/Facebook
to avoid making changes to Flow when new words needs to be added, i am using a Data table to populate the words.
this works fine when i populate each word into a row with separate Fields for each word, with this option, i still need to make changes to Flow when new words are added.

what i am aiming to achieve, is to have 1 x Row with 1 x Field where i can enter all words into one Field to avoid Flow changes, attached.

The issues are have with this option is:

1. I need to do a count of the amount of words in the Field:  State.LoopCount=Count(MakeList(State.WordCollection)
2. I need to search for words in the message from Email/Facebook = Contains(Message.Message.Body,GetAt(MakeList(State.DataTableLookup),State.LoopCount),true)
3. I need to search for 1st word in the list, then 2nd, .........
4. when the search reaches the last word the Loop must end

Can someone please advise if this is possible and what would be the best way to achieve this?
#Routing(ACD/IVR)

------------------------------
Reginald Sheraton
Bytes Systems Integration a Division of Altron
------------------------------