Issue with queri not working

Queries and Resources
1

Issue with queri

can someone explain why this queri

select *
from
{{formatDataAsArray(detalleReferidos.data)}} IC
WHERE IC.NAME_PARTNER = {{ tablaAlianzas.selectedRow.NAME_PARTNER }} AND IC.ADVANCE_MONTH = {{ tablaAlianzas.selectedRow.ADVANCE_MONTH }}

and this does not work

select *
from
{{formatDataAsArray(detalleReferidosBrokers.data)}} RF
where RF.NAME_PARTNER={{ tablaBrokers.selectedRow.NAME_PARTNER }} AND RF.ADVANCE_MONTH={{ tablaBrokers.selectedRow.ADVANCE_MONTH }}

it reads the array and the - "tablaBrokers.selectedRow.NAME_PARTNER " works but i do not know what is failing

2

Hi @Elisa_Reynal,

What are you trying to query? Queries like this are usually for databases, but it looks like you are reading FROM data from some other object/query named detalleReferidos.data. Your WHERE clause looks fine, assuming those columns exist in the data, but the FROM is unusual. Can you provide more detail?

3

The problem is that the table did not consider special caracters that have some names. I made a solution with -- currentSourceRow.nameOfField.

4

Thank you sharing your solution, @Elisa_Reynal!