Trading Networks 10.7 | Administering and Monitoring B2B Transactions | Trading Networks Administrator's Guide | Configuration Properties | Database Query Properties | tn.query.ignoreWildCardSearchCharacters
 
tn.query.ignoreWildCardSearchCharacters
When set to true the % (percentage) and _ (underscore) characters behave as literals instead of wildcard characters.
The default value is false.
Setting this property to true changes behavior of the following query operators: Equals, Not Equals, Contains, and Begins With. The new behavior is explained in the following table:
Query Operator Example
Search result when ignoreWildCardSearchCharacters = false
Search result when ignoreWildCardSearchCharacters = true
partnerName Equals partner_1
Finds any value that equals partner_1, where _ matches a single occurrence of any character.
Matches only with partner_1
partnerName Equals %partner
Finds any value that equals %partner, where % matches with one or many characters.
Matches only with %partner
partnerName Does Not Equal parnter_1
Finds any value that does not equal partner_1, where _ matches with a single occurrence of any character.
Matches with any partnerName excluding partner_1
partnerName Does Not Equal %partner
Finds any value that does not equals %partner, where % matches with one or many characters.
Matches with any partnerName excluding %partner
partnerName Contains partner_1
Finds any value that contains partner_1, where _ matches with a single occurrence of any character.
partner_1 can be the complete string or a substring.
Matches with any partnerName containing partner_1
partner_1 can be the complete string or a substring.
partnerName Contains %partner
Finds any value that contains %partner, where % matches with one or many characters.
%partner can be the complete string or a substring.
Matches only with any partnerName containing %partner, as a literal.
%partner can be the complete string or a substring.
partnerName Begins With partner_1
Finds any value that begins with partner_1, where _ matches with a single occurrence of any character.
Matches only with any partnerName beginning with partner_1 followed by any number of characters.
partnerName Begins With %partner
Finds any value that begins with %partner, where % matches with one or many characters.
Matches only with any partnerName beginning with %partner followed by any number of characters.
Default behavior. A single occurrence of % (percentage) matches with any number of occurrences of any character in the search result. And a single occurrence of _ (underscore) symbol matches exactly one character in the search result.
This property impacts the search functionality on the following pages and sections on My webMethods:
*Transaction Search
*Tasks Search
*Activity Log Search
*Partner Onboarding Search
*Document Types Search
*Document Attributes Search
*Trading Partner Agreement Search
*Partner Profile (advanced search)