Filtering with multiple variables

Altair Forum User
Altair Forum User
Altair Employee
edited November 2017 in Community Q&A

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.

Tagged:

Answers

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited November 2017

    Vaughn,

     

    Create a filter that states [UserID] .In. ('11111','22222','33333','444444')

    You get the idea.....

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited November 2017

    Sorry I think you stated your field was "Patient ID"

    So try

    [Patient ID] .In. ('11111','22222','33333','444444')

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited November 2017
    Altair Forum User said:

    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.

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited November 2017
    Altair Forum User said:

    This worked like a charm thank you.

    Vaughn,

     

    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

Categories