Skip to main content
O
ocorten-212-Amethyst
12-Amethyst
October 14, 2010
Question

Searching with Multiple Criteria using AND statement?

  • October 14, 2010
  • 9 replies
  • 10328 views
Is there a way to change the behaviour for multiple Search Criteria in Windchill?

Currently multiple criteria are treated with an OR statement (even though With All of These Criteria is set)
But I would like to use multiple criteria with an AND statment.

e.g. Search forFile Name equals 1003* or 1005*
ANDFile Name does not equal *xx* or *yy*
The search below in WC gives an error (search result size has exceeded the limit) because it treats both criteria with an OR statement and thus yield too many results with the second criteria:




(... we are on Windchill Intralink 9.1 M050)


Kind regards,

Olaf Corten





Olaf Corten
CAD/PLM Manager
Fico B.V.
Ratio 6, Duiven
Phone: +31 26 3196215
Mobile: +31 644548554
www.besi.com

*** nov. 10th - PTC/USER Benelux Event 2010 -

9 replies

D
dhand1-Visitor
1-Visitor
October 14, 2010
Olaf,

Add the following property to the wt.properties file:
com.ptc.windchill.search.client.overrideAndOrOperator=true
Dominic Hand
PLM Deployment & Support Leader
Climate Solutions
Ingersoll Rand
314 West 90th Street
Minneapolis, MN 55420


Office +1.952.887.2247
Mobile +1.612.384.4366
Fax +1.866.806.9284
avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
October 14, 2010
Great discussion, just to clarify, docs say this:

The Search Criteria table allows you to build detailed search queries by
selecting specific searchable attributes and specifying the attribute
values on which to search.

Note: Multiple values can be specified for attributes by adding the
attribute to the table more than once. If you specify multiple values
for a single attribute, there is an implicit OR relationship between the
two values. For example, if you specify the Name attribute twice, with
values of part* and gear*, your search returns results which match
either of those values.



So, this wt.property setting switches it to an implicit AND
relationship?



Olaf, where did you pick up the convention of delimiting multiple search
criteria with a semicolon? I could not find that documented. This allows
you to do ANDs and Ors now. Great work.


D
dhand1-Visitor
1-Visitor
October 14, 2010
Antonio,

Yes, that is correct. The property below changes the advanced search behavior such that it treats multiple criteria for the same attribute with an AND relationship instead of the default OR relationship. This has been tested and implemented successfully in PDMLink 9.1 M040.

com.ptc.windchill.search.client.overrideAndOrOperator=true

Dominic Hand
PLM Deployment & Support Leader
Climate Solutions
Ingersoll Rand
314 West 90th Street
Minneapolis, MN 55420


Office +1.952.887.2247
Mobile +1.612.384.4366
Fax +1.866.806.9284
O
ocorten-212-AmethystAuthor
12-Amethyst
October 14, 2010
Great man, just what I was looking for. Will try it asap.

The semicolon was discovered by one of our users who just copied the Intralink 3,.4 functionality and tried in 9.1.
BTW, The semicolon does not work in the Keyword field unfortunately. So the search below returns nothing:


Kind regards,

Olaf Corten





Olaf Corten
CAD/PLM Manager
Fico B.V.
Ratio 6, Duiven
Phone: +31 26 3196215
Mobile: +31 644548554
www.besi.com

*** nov. 10th - PTC/USER Benelux Event 2010 -
To: "Villanueva, Antonio" <->, Olaf Corten <->, "-" <->
Date: 14-10-2010 16:40
Subject: [solutions] - RE: Searching with Multiple Criteria using AND statement?



Antonio,

Yes, that is correct. The property below changes the advanced search behavior such that it treats multiple criteria for the same attribute with an AND relationship instead of the default OR relationship. This has been tested and implemented successfully in PDMLink 9.1 M040.

com.ptc.windchill.search.client.overrideAndOrOperator=true

Dominic Hand
PLM Deployment & Support Leader
Climate Solutions
Ingersoll Rand
314 West 90th Street
Minneapolis, MN 55420


Office +1.952.887.2247
Mobile +1.612.384.4366
Fax +1.866.806.9284
S
saw13-Aquamarine
13-Aquamarine
October 14, 2010
I have noticed that this search is much slower than a single criteria name or number search.

Stephen Worthington

M
22-Sapphire I
MikeLockwood22-Sapphire I
22-Sapphire I
October 14, 2010
May be related to wildcards. Seems to be immediate for a long list if the entire Number is included.
S
saw13-Aquamarine
13-Aquamarine
October 14, 2010
I have used a full file name including extension just to try my theory and it still seems slow.

Stephen Worthington

D
ddemay1-Visitor
1-Visitor
October 14, 2010
Name and number input fields searches only mastered objects I believe, where the regular keyword field when a name or number is used searches more objects regardless if fast search is installed or not. I guess PTC could chime in on that angle.



Sent from my Verizon Wireless BlackBerry
K
kknake1-Visitor
1-Visitor
October 26, 2010
Olaf great thread



May I point out that there is a better way to solve some of these issues.

Many companies today force their end users to use metadata in the parts and
assemblies in hopes of

being able to search on many areas so they can find the necessary
information at a later date,

The problem lies within the fact that many things cannot be processed into
canned fields

and as such are prone to human interaction and ways of thinking, not to
mention international companies

such as on these forums where a boot in Texas and a boot in Europe are
completely different items.



We recently showed a large international company their own database of
parts, we asked them for any part

name and showed them the results based upon that part name, we then did a 3D
geometry search on

that part and found 5X the number of parts due to simple syntax differences.
( and many duplicates )



We don't take away the option to search on text/metadata we simply enhance
the search criteria

and chances for success by bringing in the aspect of a search engine that is
100% accurate based on shape of 3D part.



We have had a booth at PTC world for the last 3 years



This is installed at some very prominent companies utilizing many different
PDM systems.



If you are interested take a glance at the website and video



if you want to continue to struggle with identifying parts and
assemblies based upon textual fields . then delete this email



Thanks

Kelly 713-784-3500



www.3dcadseek.com
Terms & ConditionsAccessibility statement