I connected my UCCX to my DATABASE and i already have a script to write and everything is fine i wanted to add DBread and DBget when i query for DBread it's working fine and i can find the rows i selected
The script to classify the client mobile no. and by his number we distribute the call to the queue like VIP customer queue normal customer and request help.
the table is
Column 1 = Account ID
Column 2 = Client Mobile number
Column 3 = Contact type (1,2 and 3) Which 1 is VIP, 2 is normal customer and 3 for request help
DBread step is find i can get the row, now i want to make DBget and match the column name with the contact type my problem is that i can't find my table in the box of Show all fields (Selected Table/view)
attached the screen shots with the script, DBread and DBget.
Solved! Go to Solution.
Thanks for sharing.
From your screenshot (DBRead) I see that you try to find something in the SQL table named contact_type. However, in the DBGet you try to select another table - spt_fallback_dev.
Can you see the contact_type table in the dropdown list of your DBGet? If not, did you try to use the Refresh Database Schema button in your DBGet step?