How to write SQL query to select specific resource

Question

question

Patrick Cloutier asked Oct 2, '17 Jeff Nordgren commented Oct 3, '17

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

Software Version:

FlexSim 17.2.2

sql

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 · 2017-10-02T19:04:55Z

Patrick Cloutier answered Oct 2, '17 Jeff Nordgren commented Oct 3, '17

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

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

Jeff Nordgren commented · Oct 03, 2017 at 06:21 PM

@Patrick Cloutier

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

0 ·

question