question

Tay L avatar image
0 Likes"
Tay L asked Jeanette F commented

In Flexsim 7.3 , what is the code for filtering the global table data?

Hi,

I'm using Flesim 7.3, what is the code for sorting and filtering the global table data? For example, I would like to use GUI search button to find a part name or part number in the Global table.


1633532730870.png


1633502456271.png


Thank you.

FlexSim (other - please specify)
FlexSim (other)
FlexSim (other - please specify)
FlexSim (other - please specify)
FlexSim (other)
FlexSim (other)
custom gui
1633502456271.png (2.8 KiB)
1633532730870.png (5.2 KiB)
· 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.

Jeanette F avatar image Jeanette F ♦♦ commented ·

Hi @Tay L, was Ben Wilson's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

0 Likes 0 ·

1 Answer

·
Ben Wilson avatar image
0 Likes"
Ben Wilson answered Tay L commented

FlexSim version 7.3 (from 2014) does not have the same powerful querying capabilities you'll find in modern versions of FlexSim.

There are built in commands for sorttable() and multisorttable(). Beyond that you will need to write your own logic, likely looping over the table to make whatever comparisons or calculations you need to in order to perform your custom sort or find your result set. If you need a separate table of matching rows, you'll need to createcopy() of your desired rows into a separate results global table.

· 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.

Tay L avatar image Tay L commented ·

Hi @Ben Wilson , Thank you for the advice. I will try it out.

Regards,

Tay

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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