AnsweredAssumed Answered

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

Question asked by Jens Zeumer on Jan 5, 2018
Latest reply on Jan 5, 2018 by Michael Dekoning

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

Outcomes