Buy Now
Sign in

Populate Table List with Database > SQL Data array

shahabpk , August 26 2021, 10:09
S
shahabpk 91
August 26 2021, 10:09 #396991
I want to populate Table list coloumns with the result of the action SQL Data ( sql_data_2 ). I am able to populate it with read_data action but since my sql query is a little complicated, I want to use the SQL data action. The debug shows that it returns the data to an array correctly. But i don't know how to use that data in Table List and what short code to be used. I know that normal short code is {var:Model.fieldname} . SQL Data action has no Model. So basically the doubt is how to get data from an SQL data array which is not having a model name/alias.?