Search a field value in list entries

Question

question

Aditya Prakash asked Jun 17, '16 Jordan Johnson answered Jun 17, '16

Search a field value in list entries

OnMsg trigger I need to search through all values (Entries as well as backorders) in a global list, checking for a field value. How should I do it ? Is there a command for that or should I create a duplicate table and keep updating it at each PUSH/PULL, and query from this table.

Software Version:

FlexSim 16.0.1

list entries listbackorders

· 2

Aditya Prakash commented · Jun 17, 2016 at 01:15 PM

One way I found is query("SELECT * FROM List_name WHERE field = var "). This throws count of occurrences where I meet my criteria. Is there any other way ?

0 ·

Mischa Spelt commented · Jun 17, 2016 at 01:40 PM

I think it is the most efficient way. Does it not give you the correct result? Maybe you can do something with partitions, but I haven't used those yet so I'm not sure how to get the content of a partition.

0 ·

Answer 1 · 2016-06-17T17:32:37Z

Jordan Johnson answered Jun 17, '16

You can search the entries on a list using the listpull command. This command will return an array of items that match the query. If the request number and require number are zero, then the items will not be removed from the list:

listpull("GlobalList1", "WHERE fieldName = someValue", 0)

You don't need SELECT or FROM statements in this query, and you can use field names directly. The result will be an array of values. The type of the array will depend on the type of values that are on the list.

It doesn't make sense to search back orders for field values. Field values are assigned when an item is pushed on the list. Back orders are created when you use the listpull command, with a require number greater than zero, but items matching the pull query do not exist on the list.

question