topic Re: Read field values from a list in FlexSim Forum

Read field values from a list

marco_baccalaro — Thu, 23 Mar 2017 13:24:03 GMT

[ FlexSim 17.0.3 ]

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);

Re: Read field values from a list

cameron_pluim — Thu, 23 Mar 2017 13:56:05 GMT

@Marco Baccalaro

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!

Re: Read field values from a list

marco_baccalaro — Thu, 23 Mar 2017 14:22:18 GMT

And to read the fields?

Re: Read field values from a list

cameron_pluim — Thu, 23 Mar 2017 18:34:20 GMT

That is a good question, (and probably your initial question).

Re: Read field values from a list

marco_baccalaro — Thu, 23 Mar 2017 20:35:13 GMT

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.