The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
I am trying to find certain ID's in a table. The table has a column named User ID. I want to find multiple differnt ID's I am having trouble making my filter work. This is what I have most recently tried.
Instr("11111","Patient ID") .or. "Patient ID" = "222222" .or. "Patient ID" = "333333"
Any help is appreciated.
Vaughn,
Create a filter that states [UserID] .In. ('11111','22222','33333','444444')
You get the idea.....
Sorry I think you stated your field was "Patient ID"
So try
[Patient ID] .In. ('11111','22222','33333','444444')
Sorry I think you stated your field was "Patient ID"So try[Patient ID] .In. ('11111','22222','33333','444444')
This worked like a charm thank you.
Is this something you need to to with different lists of IDs on a regular basis?
If so would you be expecting to change the model and edit the filter each time?
Subject to which version of Monarch you are using there may be some ways of enhancing such a process for repetitive use - if that is of interest to you.
Grant
