Solved How to specify the field in a select statement that retrieves multiple fields?

[erpardeiro]

Hi guys!

I'm running a select query on a database that retrieves 3 fields (idContato, NumeroContato, and StatusContato).

Within the CallFlow, I need to retrieve the information for each field, but I'm unsure how to do that. Here's the table:


Now, let's take a look at the objects in the CallFlow:


Lastly, let's examine the object (Dialer) where I need to specify that I want to read the "NumeroContato" field.


In this example (Make call from), how can I point to the "NumeroContato" field?

 

[edossantos]

You need to change the statement type to Query, and then use the function GET_TABLE_CELL_VALUE to get each value, for example:
GET_TABLE_CELL_VALUE(RetornaNumber.QueryResult,0,0): will return the value from row 0 column 0.
GET_TABLE_CELL_VALUE(RetornaNumber.QueryResult,0,1): will return the value from row 0 column 1.
GET_TABLE_CELL_VALUE(RetornaNumber.QueryResult,0,2): will return the value from row 0 column 2.

More information on this function here:
https://www.3cx.com/docs/manual/cfd-prompts-expressions/#h.v17ic2wxant9

 

[erpardeiro]

Thank you very much!

 

[OlegR_3CX]

@erpardeiro
We are glad to hear the issue is resolved.