question

Stan Davis avatar image
2 Likes"
Stan Davis asked Stan Davis commented

How to Filter Property Table Using 'NOT LIKE' Or Similar

I do not see a selection for 'NOT LIKE' when trying to filter out on name in a Property Table. I've tried wildcards but no success. Is there a way to do this??


1674663433623.png


Thanks

FlexSim 23.0.2
filter
1674663433623.png (4.6 KiB)
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Jordan Johnson avatar image
1 Like"
Jordan Johnson answered Stan Davis commented

FlexSim's sql language supports LIKE, but does not currently support NOT LIKE, so that option is not present in the GUI.

If you write your own query and run it with Table.query(), you can use something like the following:

Table result = Table.query(
  "SELECT Object, Name FROM Objects() WHERE NOT (Name LIKE '%Queue%')");
result.cloneTo(Table("GlobalTable1"));

Alternatively, you could probably add a label to the objects you want to see and filter based on that label value.

· 1
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Stan Davis avatar image Stan Davis commented ·

Understood. Thanks.

0 Likes 0 ·