topic Re: Move Find Slot Query into Code Editor in FlexSim Forum

Move Find Slot Query into Code Editor

stan_e_davis — Wed, 18 Jan 2023 23:46:05 GMT

[ FlexSim 23.0.2 ]

I have a long Find Slot query that is difficult to view in the little query window. I'd rather view it all at once in a code window. How do I place it in the Find Slot activity's Code Editor instead?

I've placed this shortened version in the Code Editor for testing but it does not work correctly and I get 'syntax error, unexpected integer, expecting end of code' error.

Storage.system.findSlot("WHERE $1.PartNo IN (slot.PartNo1,slot.PartNo2) AND slot.hasSpace($1.item) ORDER BY RAND()", 0, token);

Thanks.

Re: Move Find Slot Query into Code Editor

jason_lightfoot_adsk — Thu, 19 Jan 2023 00:51:31 GMT

You just need to return the query string:

return "WHERE $1.PartNo IN (slot.PartNo1,slot.PartNo2) AND slot.hasSpace($1.item) ORDER BY RAND()";

Re: Move Find Slot Query into Code Editor

stan_e_davis — Thu, 19 Jan 2023 13:57:20 GMT

worked perfectly. Thanks Jason.