Acquire Activity Query for Resources help

Question

question

Ashmita G asked Dec 16, '20 Ashmita G commented Dec 21, '20

Acquire Activity Query for Resources help

The above is a replenishment logic. If the queues next to the conveyor reach their respective Reorder Level a replenishment trigger is submitted. The global table "IT" contains all the necessary data for the same.

I am trying to control the AGV which will address a particular replenishment request for particular Queues. For example, Queue1 and 2 will only be addressed by AGV1. When a token enters the "Reorder" activity in the process flow, it contains a label defined on it as PartNo. The PartNo is the row reference with respect to the Global Table.

In the "Acquire" activity I want to utilize the query segment to filter out the AGV to be used to address a particular type of replenishment logic. The AGVs to be used has been mentioned in the global table. I was wondering how to use the SQL query bar for manipulating he same outcome.

Also I was wondering if we can use lists instead. I got stuck on how to write the query in that case as well. If I am to define a group and use it in the list, how should the query be?

Software Version:

FlexSim 20.1.1

query lists flexsim 20.1.1 sql acquire resource

gtref.png (6.5 KiB)

agvquerry.png (12.3 KiB)

addition.fsm (61.8 KiB)

5 |100000

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

Answer 1 · 2020-12-17T22:15:18Z

Parker S answered Dec 17, '20 Ashmita G commented Dec 21, '20

@Ashmita G

I believe this could be done using lists. If you prepopulate a Global List with your AGV's

You can then use a Pull from List to query an AGV using labels

I'm not sure if this is the actual query you would use, but it would be easy to add a label on the AGV's that corresponds with what Part Numbers they pick up.

Then the Acquire would use the pulled token as the query

You would also have to push the AGV back to the list once released.

There might be a way that this could be done using just the acquire query, but this way would make the most sense to me.

I hope this helps! Let me know if you have any other questions.

1608242793456.png (28.6 KiB)

1608242865340.png (22.6 KiB)

1608242986492.png (11.7 KiB)

1608243247462.png (27.1 KiB)

· 1

5 |100000

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

Ashmita G commented · Dec 21, 2020 at 01:49 AM

Hi @Parker S,

Thanks for the solution. I do have a follow up query to that though.

1.

I added two AGVs in the group. AGV1 is supposed to address Part No -1 and AGV2 is supposed to address Part No -3.

However, AGV2, as in the above picture, is addressing Part No 1.

According to the label assigned AGV1 is supposed to replenish the system for Part Type 1.

2.

Like mentioned previously, I want the AGV to be pulled according to the global table.

So according to this I would require the PartNos = 1 and 2 being pulled by AGV1. And PartNo3 to be addressed by AGV2.

Is there a way to query the AGVs based on the global table information?

I have attached the model for reference. Addition (2).fsm

Kindly advice.

0 ·

question