1 Reply Latest reply on Jan 5, 2018 8:43 AM by Michael Dekoning

    epdm api (vba): Search for text in multiple variables

    Jens Zeumer

      Hello everybody and a happy new year to you!

       

      I'm currently working on a project for classifying our SolidWorks models. We will have up to 3 different classification strings possible for each file. My challenge with creating a pdm search at this very moment is that I cannot know, in which variable the search string is written.

       

      As an example:

       

      3 Classification strings possible

       

      model: custom property as string: "Classification1", "Classification2" and "Classification3"

      PDM: variables "Classification1" to "...3" refering to the corresponding custom property

       

      The search string "Test" could be in any of the 3 custom properties/ variables.

       

      In the PDM search tool I would realise it this way:

       

      2018-01-05_Search.png

       

      Now I'm searching for the "or"-connector in the API.

       

      The code currently looks like this:

      [...]

      Set eSearch = eVault.CreateSearch

       

      eSearch.AddVariable "Klassifizierung1", "Test"

      eSearch.AddVariable "Klassifizierung2", "Test"

      eSearch.AddVariable "Klassifizierung3", "Test"

       

      Set eResult = eSearch.GetFirstResult

       

      Do While Not eResult Is Nothing

      [...]

       

      But the variables are linked with an "and".

       

      The only way I can think of solving this problem at the moment is to run 2 consecutive searches and merging the results afterwards. I can't believe there is no easier way to accomplish this.

       

      Any help is welcome.

       

      Thanks, Jens