question

pc neo avatar image
0 Likes"
pc neo asked pc neo commented

List with "SELECT" keyword as values assigned throws exception

select_error.fsmI am learning on List and craft a small example as attached but it is throwing exception with the addition of "SELECT litres" clause. Is this a bug? Or I have some done something wrong?

FlexSim 21.1.1
listflexsim 21.1.1select query
select-error.png (117.8 KiB)
select-error.fsm (31.3 KiB)
· 4
5 |100000

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

Joerg Vogel avatar image Joerg Vogel commented ·

There are some conditions using a SELECT clause. The most important is, it MUST be a global list.

0 Likes 0 ·
pc neo avatar image pc neo Joerg Vogel commented ·

Thanks for the quick reply.

I've tried using global list and the same issue is seen. Furthermore, if the List properties has both "SELECT as quantifier" and "Assign SELECT..." checked the attached model works without error.

In regards to the requirements of the use of "SELECT" clause, the user manual has mentioned as below but they are not violated in this example too, even though this example is not using "SELECT" clause as quantifier.

  1. The clause references a dynamic label field.
  2. The clause references a label that is not explicitly defined as a field on the list.
  3. The clause references a non-dynamic field.


Hope to get more inputs/advice.


0 Likes 0 ·
Ben Wilson avatar image Ben Wilson ♦♦ commented ·

Hi @pc neo, was jason.lightfoot's answer helpful? If so, please click the red "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 ·
pc neo avatar image pc neo Ben Wilson ♦♦ commented ·

hi @Ben Wilson the suggestion from @jason.lightfoot does not resolve my issue. After getting inputs from many others particularly from @Jörg Vogel I believe it may be a bug and I will send an email to [email protected].

Thank you :)

0 Likes 0 ·

1 Answer

Jason Lightfoot avatar image
1 Like"
Jason Lightfoot answered pc neo commented

If you add 'litres' and 'Type' as fields to your list you will not get the exception:


1619796839713.png (9.9 KiB)
· 9
5 |100000

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

pc neo avatar image pc neo commented ·

@jason.lightfootI have tried your suggestion (using both internal list and global list) but the exception is still seen. :(

0 Likes 0 ·
Arun Kr avatar image Arun Kr pc neo commented ·

Checking the "Use First Select Value As Quantifier" eliminates the exception. Check the attached model. Also added fields as @jason.lightfoot was suggesting.


Regards,

Arun KRselect-error.fsm




1 Like 1 ·
1620032457301.png (66.3 KiB)
select-error.fsm (104.8 KiB)
select-error.fsm (104.8 KiB)
Joerg Vogel avatar image Joerg Vogel Arun Kr commented ·

Without this option it does work as long as there are enough values to access on the list.

List_pull_SELECT.fsm

0 Likes 0 ·
Show more comments