question

Devdatta D avatar image
0 Likes"
Devdatta D asked Jeanette F commented

Reevaluate SQL query at Acquire resource

I have tokens waiting at Acquire step until a conditional SQL query is true. How often is the query evaluated?

FlexSim 22.1.1
sqlresourceacquire resource
· 1
5 |100000

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

Jeanette F avatar image Jeanette F ♦♦ commented ·

Hi @Devdatta D, was Jason Lightfoot's answer helpful? If so, please click the "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 ·

1 Answer

Jason Lightfoot avatar image
0 Likes"
Jason Lightfoot answered Jeanette F edited

When the token enters the acquire and when the available resources change. For a list it can be further defined by backorder fulfillment events.

· 2
5 |100000

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

Devdatta D avatar image Devdatta D commented ·
I have label whose value decides if a resource can be seized. Will SQL query be evaluated when label value changes? for ex. Resource1 has NumUsed lable. If the value of the label is less than 2 I can acquire the resource. When i evaluated first the value is 3, then after sometime value changes to 1, will SQL query get evaluated?
0 Likes 0 ·
Jeanette F avatar image Jeanette F ♦♦ Devdatta D commented ·

changing the label will not cause the resource to be revaluated. Like Jason mentioned above, the resource will only revaluate when a token enters the acquire activity or one of the resources becomes available.

Jason also mentioned a list has the ability to have more triggering events to revaluate.

1663182918342.png

0 Likes 0 ·
1663182918342.png (16.0 KiB)