OL Learn

Retrieve sql fields in action step


#1

hi,
I have a PDF datamapper, extracted 1 value using location, then running a SQL request to add this field in where clause. it’s all working fine.
in my SQL request I am selecting about 15 fields , how can I list all the these fields and their values in the detail table?
I have tried to apply this (Create a Detail Table from a Linear Data Structure)
https://learn.objectiflune.com/howto/create-detail-table-linear-data-structure/
but no luck!
best regards,
HakiInitial


#2

That’s very little information to run on, but as a very general method I would store the SQL query results as a JSON array in one of the Data model fields, and then use a script in the template to iterate through all elements of that array.