question

Patrick Cloutier avatar image
0 Likes"
Patrick Cloutier asked Jeff Nordgren commented

How to write SQL query to select specific resource

I have a group of 3 cranes which are referenced as a group in a process flow Resource.

When I acquire this resource I need to specify which of the 3 cranes I need based on a previously written token label called crane. The crane names match the label token.crane

So my question is how to correctly write the SQL Query ?

Something like :

Where CraneName = token.crane

Where resource.Name = token.crane

Where Name = token.crane

FlexSim 17.2.2
sql
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

Patrick Cloutier avatar image
2 Likes"
Patrick Cloutier answered Jeff Nordgren commented

After a billion tries I found it: WHERE Value = Puller.crane

By the way, this info is nowhere to be found in help or the manual.

· 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.

Jeff Nordgren avatar image Jeff Nordgren commented ·

@Patrick Cloutier

Good job. Maybe something that should be added to the User Manual. @Alyssa Rock

0 Likes 0 ·