Community
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Use boolean expressions in searches

Use boolean expressions in searches

I like to use boolean expressions in searches.

For example:

 

(file name = "bracket") OR ( (file name = "lifting eye) AND (state = 'released") )

 

This would give me all brackets and all lifting eyes which are released

 

14 Comments
dvsmiller9
Advocate

I agree we need 'OR' as an option.  Currently just being able to 'AND' criteria is limiting.

dvsmiller9
Advocate

This would also be helpful in Category Rules assignment.  We have a semi-intelligent part numbering system where the first few digits define the category.  Some have categories have overlapping prefixes (fixtures with different prefixes due to legacy assignment or running out of sequential numbers within a prefix group - hey, I only inherited the system) where a boolean assignment rule would allow me to assign multiple prefix groups to one category.

ihayesjr
Community Manager
Status changed to: Accepted
Thanks for the suggestion, can you look at the wiki help topic to see this already addresses what you are looking for? http://wikihelp.autodesk.com/Vault/enu/Help/Help/0001-Using_Va1/0003-Essentia3/0017-Searchin17
Maarten65
Advocate

Like mentioned above I am missing the OR  operator. And when havenig a AND and an OR operator there must be something like a group function as wel to bond them together.

Payne530
Enthusiast

Currently the saved search criteria acts as an AND operator.  There is no OR operator in the saved search criteria.  It would be nice if there was a way of implementing a search criteria similar to that of the filter settings.  There is a lot more functionality in the Filter editor than in the saved search criteria.  I can create much more complex searching criteria with this.

 

Capture.PNG

 

This search would then return:

 

  • BRT Parts of EXTRUSION NO - ACS100334
  • FST Assemblies
  • HZH Parts of EXTRUSION NO - ACS100306

Currently you would have to have 3 separate saved searches. one for each AND line.

Tags (2)
Maarten65
Advocate

I am asking for this since I use Vault. It would be a great step forward when boolean operations can be created in a search definition.

 

Maarten Weers

Technical Specialist CAD

Parker Hannifin

olearya
Alumni
Status changed to: Future Consideration

Hi there,

 

Thanks for submitting your idea - would this existing request resolve your issue?

 

http://forums.autodesk.com/t5/vault-ideastation/use-boolean-expressions-in-searches/idi-p/3551524

stevenpayne89
Participant

@olearya the existing request would simply add the foundation for complex searches.  But I would prefer a more user friendly approach.  Trying to create long complex searches in a single line box can become tedious.  I like the way the filter dialog is laid out and shows you a structure.

 

(It only took me a year to get back to this)...

olearya
Alumni

Better late than never Steve 🙂

philip.s
Alumni
Status changed to: Under Review
 
Telson.Hadden
Advocate

There is no easy way to search for files where Field1 or Field2 or Field3 = "some string"  SQL can do this, and the vault is built on SQL.

 

https://forums.autodesk.com/t5/vault-forum/what-is-query-builder/m-p/7833029/highlight/true#M72385

 

contains a workaround, but it is awkward and cannot be saved.  We need better search capabilities.

 

 

Tags (3)
Telson.Hadden
Advocate
ihayesjr
Community Manager
Status changed to: Future Consideration
 
vittorio.arato
Contributor

There are 4+1 searching methods, but no one is complete. Could be fine to have only one or two method but completed with boolean expressions and flexible options. If you use 5* on quick search (token searching tool) you do not get ISO Standard results (everything start with 5).

Can't find what you're looking for? Ask the community or share your knowledge.

Submit Idea  

Autodesk Design & Make Report