How to do a smart search that doesn’t include a “or” but a “and”
Document Description: NOT LIKE’*NOTE TO BE USED*’, NOT LIKE’*Withdrawn*’
Input the following string in either the regular search or the advanced search builder in the Document Description:
$FIELD$ NOT LIKE'%NOTE TO BE USED%' AND $FIELD$ NOT LIKE'%Withdrawn%'
I got it. In the advance search builder [General Properties] [File name] use the following format for the value field: $FIELD$ NOT LIKE'%AQU%' AND $FIELD$ LIKE'%sole%'
I am struggle to do something similar in the Search Builder function of ProjectWise. I need to look for file names that are for "Sole Source" items but not "Sole Source Aquifer" items. Based on the above it seems that something like this should work, but I'm not having any luck:
$File name$ LIKE '%sole%' AND $File name$ NOT LIKE'%aquifer%'
Any help would be appreciated!