I really need to read the fields values from a List.
I tried to query it but I haven't found a way to do it.
Is there a way to do it?
Object list = globallist("MyList");
treenode theList = listentries(list);
query("SELECT value, levels, sku FROM $1",theList);
treenode table = model().find("Tools/prova");
dumpquery(table);
I've found the best way to read the value from the list is to use the listpull() command with 0 as the requested value, and 0 as the required value (this way it doesn't actually pull them from the list.
int myValue = 15;
string myquery = "WHERE value = " + numtostring(myValue);
Array myArray = listpull(globallist("MyList"), myquery, 0, 0);
Hopefully this helps!
That is a good question, (and probably your initial question).
Yes, I really don't know how to do it, the query gives me the fields names and the count but not the fields values.
7 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
