Using Wildcard Features to Refine Bill Search Queries
Generally billing search engines support standard wildcard features for the Ref, Bill Type, and Bill Source fields. Unless you enter one of these wildcards, PeopleSoft Billing assumes that you want an exact match:
Field or Control |
Description |
|---|---|
% |
Match one or more characters. |
* |
Match one or more characters. |
_ |
Match any single character. |
? |
Match any single character. |
! |
If first character, negate the operator (not equal or not like). |
~ |
A blank character. Do not use this character with any other characters or wildcard symbols. |
\ |
Escape character. Do not treat the next character as a wildcard. |
For example, you could search for a blank in the Ref, Bill Type, and Bill Source fields by entering a tilde (~) in each field. If you leave these fields empty, the system selects all values for that field.
Within Bill Search, there are exceptions to the wildcard approach. Exceptions occur in these instances:
When you select Invoice in the Ref field, and the Value is left blank, all invoices for the contract or customer are returned.
When you do not select Invoice in the Ref field, and the Value is left blank, only rows where the referenced field is blank are returned.