topic Re: Floor Storage Pull from List with FlexScript Not Working in FlexSim Forum

Floor Storage Pull from List with FlexScript Not Working

c_adam_collins — Fri, 07 Jul 2023 15:33:49 GMT

[ FlexSim 23.0.9 ]

Hello, I have a group of floor storages with unique warehouse Column label values. They should pull flowitems from an item list whose WH label match their Column label. I have tried the following references, with and without curly braces, and the FlexScript does not execute.

WHERE WH =

current.Column, current.labels["Column"].value, getlabel(current,"Column")

The query only returns the exact string the query. I assume this is because the pick list code declares the query as a string, but it seems like FlexScript should function here - a dynamic query built with labels is a common application.

Re: Floor Storage Pull from List with FlexScript Not Working

jason_lightfoot_adsk — Fri, 07 Jul 2023 16:42:02 GMT

If you're using a pull from list activity to pull, the query needs puller references, so make your puller 'current' and then use puller.Column in your query.

This assumes that the floor storage is an object process flow member/instance.

Similarly for List.pull() - one of the parameters is for the puller, for which you would enter 'current' again.

Re: Floor Storage Pull from List with FlexScript Not Working

c_adam_collins — Fri, 07 Jul 2023 18:26:11 GMT

There is no process flow used here at all - this on the floor storage object input/pull from list. There is no place to mark a puller.

Re: Floor Storage Pull from List with FlexScript Not Working

jason_lightfoot_adsk — Fri, 07 Jul 2023 20:54:09 GMT

The puller is current by default it seems - so you can use the keyword 'puller'. You can check the parameters in use in the trigger by opening its code in the editor.

Re: Floor Storage Pull from List with FlexScript Not Working

c_adam_collins — Fri, 07 Jul 2023 21:50:54 GMT

The attached image shows the code behind the pulling object's input picklist (no process flow). There is no puller variable in the code and the intellisense does not recognize typing 'puller' in the query. Still if they are the same, current should work.

Again, this is trying to use the basic "Pull from List" picklist on a fixed resource and include "current.myLabel" in the query input box. The intellisense there recognizes current (it turns blue) but is not executed as FlexScript. But note in the code it is all treated as string, including when curly bracers are used per the SQL query help page.

Re: Floor Storage Pull from List with FlexScript Not Working

jason_lightfoot_adsk — Fri, 07 Jul 2023 23:03:00 GMT

You need to replace 'current' with 'puller' in the SQL string that you write so:

WHERE WH=puller.Column

It's as simple as that.

Here's the documentation on List.pull() which clearly shows that in the trigger code, 'current' as being passed into the function as the puller, and demonstrates the use of the keyword 'puller' in the examples.