The Vault Find command is a very powerful tool but sometimes it just does not give the results we expected. In this example I need to find all models and drawings where the "Designer" property is either C King or B White. I enter the following search parameters and perform the seach and I am wonderng why no files were found.
You soon realize that the Vault defaulted to a Boolean AND operator between the two statements and or course the files in the Vault will probably not have two Designers. You know the Vault understands a Boolean OR operation but you are wondering how to achieve this in the Find commnad statement.
The answer is to create the find statement to include the Boolean OR operator in the Value field between the designers names. In the search below the files that have either B White OR C King, as the value of the Designer property, are found.
The Boolean operator does not have to be capitalized, I just did it for emphasis. You can also have as many OR operators in the line as you like.
This same idea can be used in the Vault Query Builder.
If you desire, you could type the same search in the Search Dialog box.
Don't forget to save your Vault Find command configurations to quickly used them again and again.
This is GOLD! Thanks for sharing, do you know of any other supported operators in the value & search fields? Are they just the ones listed in the edit filter dialogue?
Posted by: Scott Moyse | 08/31/2013 at 05:53 AM
Scott,
The Vault search fields are both Vault standard fields and also Vault properties that you configure. Say you would like to capture a field from your Inventor drawings called Job Location. Log into the Vault as the adminstrator and add a Vault property call Job Location, map it to the pick up the field from the Inventor drawing as it is checked into the Vault. After this, you will find Job Location is listed in the Search field drop down.
Posted by: John Hackney | 09/01/2013 at 02:58 PM
John you've misunderstood what I was asking. I understand how system & UDP mapping works in Vault. I was asking if there were any other supported operators... You list OR above, but would AND work etc... I refer to the Edit Filter dialogue because when you setup a custom view filter, if you hit the Edit Filter button at the bottom of the Explorer Grid, it presents you with more Filter options than are available anywhere else.
As it happens I'm going to use this trick in my AU class in a few weeks, for View Filters. I just haven't tested the use of other operators yet.
Posted by: ScottMoyse | 11/13/2013 at 07:21 PM
Scott,
Sorry I for my misunderstanding, yes the Vault can perform most all the Boolean search statements including "AND". Just be sure to enter the statement in all CAPS.
Posted by: John Hackney | 11/22/2013 at 04:05 PM