question

Suraj J avatar image
0 Likes"
Suraj J asked Suraj J commented

Query in Acquire Resource where Resource points to a Global TEList

Hello

I am trying to use SQL query to acquire a correct operator for a station. All the operators are listed in TEList which is global and an expression evaluates which station the operator is allocated to.

When I am using the following query (and I have tried many ways) it is not acquiring any operator.

Could anyone guide me what I am doing wrong? The manual says 'pull from list' can be used when resource is a list but I was wondering why query within acquire resource is not working.

FlexSim 18.2.3
listacquire resourcesql queries
1.jpg (24.9 KiB)
2.jpg (14.2 KiB)
3.jpg (25.0 KiB)
5 |100000

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

1 Answer

·
Raja Sekaran avatar image
1 Like"
Raja Sekaran answered Suraj J commented
@Suraj J

Please make sure that you are passing the string value in the "CurrentStation" label value.

I have attached the sample model. It works well for me. Try this.

acquireoperator.fsm

Hope this helps.

Thanks


acquireoperator.fsm (43.1 KiB)
· 3
5 |100000

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

Suraj J avatar image Suraj J commented ·
@Raja Sekaran

Thanks for the model. I am sure that the station names are string. Looks like this has to do something with version. Will confirm tomorrow.

0 Likes 0 ·
Raja Sekaran avatar image Raja Sekaran Suraj J commented ·

@Suraj J

Yes it's not working in v18.2 but works in 19 and above. I have attached a sample model for reference (v18.2). Better you can directly use "List" shared asset activity and use "Pull from list" activity like an acquire resource activity.

acquireoperator-v1820.fsm

Thanks

1 Like 1 ·
Suraj J avatar image Suraj J Raja Sekaran commented ·

Pull from list was working for me, was wondering about why Acquire was not. Thank you again.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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