How to create a query for locations

[nicolas_m6]

[ FlexSim 19.2.4 ]

Hi,

I would like to create a query for a locations group of rooms.

The rooms have a label "Specialite". This label changes each day.

The patient comes with a label "SpecialiteP".

Query that I whant to do:
The patient pulls a room from the group "Salles"
where the "SpecialiteP" = "Specialite"

How can I do that ?

Can you show me in the model attached ? (explanations inside).

Thanks in advance.

@Braydn T

20200124-sallesetfluxpatient-query.fsm

[Matthew_Gillespie · Accepted solution]

You just need to add the Specialite clause into the WHERE statement with an AND:

WHERE [Salles] AND value.Specialite = puller.SpecialiteP AND (Priority = 0 OR (Priority < 100 AND Preemptable > 0)) ORDER BY Priority, [Salles]

customwhere.fsm

This is much easier now in 2020, you would just add the clause in the Filter By field:

customwhere2020.fsm

[nicolas_m6]

thank you very much for your answer. Perfect. It correspond to what I was looking for.