Can anybody help me with this value string for a query as a value added to a column in a table?
When I use just {{query22.data.street}} I can see that the array is correct. But then, it gets repeated in all rows.
When I use [0] or [i] it fixes the duplication, but the array is something else, with incorrect data.
What am I missing?
Not in this case.
That's because the source is the main table with most columns. But the column above is to take to this table a SQL query with join from other tables, hence the mapped array above.
If I use {{query22.data.street[i]}} it maps it but incorrectly. I can't figure out what is the index used in this case, as it doesn't match anything.
But the "652" Mapped array is in the correct order. Just can't map it to the column.
In this case, you will need to use something like the find function, but this is very expensive in terms of performance. I would recommend editing your query instead. If you give information about the other table, I will try to help.
The two tables do not match when using [i] because the rows in the two lists are not pulled in the same order.
You can try this if you have matching columns in two tables.
Thanks so much @edurmush for your help with this! Much appreciated.
When you say matching columns in two tables, do you mean between the query output and the main table I am working on? If so, yes, I have user_id matching.
The two tables used in the join, changed the column name so now I have also two matching.
But still the new mapped value is not working...
As i said before, you have to set Source for this column (in this case user_id)
item stands on current column value, when you dont set source, item is undefined
{{ _.find(formatDataAsArray(query22.data), { user_id: item }).street }}
This piece of code must work for you. You need to delete unnecessary curly brackets.