Do SQL queries in Process Flow work on Global Lists?

[jason_merschat1]

[ FlexSim 17.2.1 ]

Is there a different method for querying a Global List vs an Internal List in Process Flow? Specifically, when Pulling From a Global List using a Query - If so, is this documented anywhere?

[sam_stubbsYXX86]

I believe the queries should work the same, they both use the same syntax etc. Are you having troubles with it?

[anthony_johnsonT83CM · Accepted solution]

If you're talking about using a SQL query in a Pull From List activity, you can pull from a global list through process flow. Just create a list in the process flow and then connect it to the global list (beside its List property, click the eye dropper, then click on the list in the toolbox). This will associate it with the global list, so all operations on the process flow list will apply to the global list.

If you're talking about querying a list in using Table.query(), it will recognize the global list from code in the process flow.

[jason_merschat1]

Hello @anthony.johnson and thank you for responding. My trouble was using a SQL query to compare (list matching using WHERE) Global List and Local List labels. The Global List is connected using the PF method you describe above. I ended up just changing the Local List to a Global and it worked fine. I spent a day trying to force it to work and just ended up going with what worked. I was trying to use the puller token that was flowing in PF to reference a Global Table and I just couldn't get it to work properly in the "Pull from List" object.

[jason_merschat1]

HI Sam, Thanks for the reply. I added some comments to Anthony's response below.