Need to know if the "Contains" State can be added to the list under the Line Search tab for the field Purchase Order as shown in the screen shot below. If yes, where does this configuration need to be made. Thanks
I believe the available search operators on a given field are determined by the data type of that field. The PurchaseOrder field type is Numeric (i.e. not a string) so that is likely why the "contains" operator is not available.
Thanks Andy for that quick clarification.
However, if this was an Alpha field and we could add this option, where would we add it.
I know that this listing is based off the CompareOperator field
I'm not aware of a way to add a String operator to a Numeric search field.
Thanks
Can you advise why you want to pattern match against PO Numbers?
This was a request that came from one of our Purchasing leaders.
Thanks, I'm just curious why they would want to search by a partial PO number.
This was their justification for requesting this search criteria.
"Contains allows to easily identify if a "invalid PO" is missing a digit when resolving invoice discrepancies"
Well, you could create a Derived Field of type Alpha that returns the PurchaseOrder value. Casting the PurchaseOrder as Alpha would make the derived field searchable with the contains operator when added as a search field to a search form. However, the performance of filtering on that derived field would likely be slow, so I don't know I'd recommend doing that. I'd also be curious how invalid PO numbers are being generated if they are auto-sequenced.
I definitely agree with you on that one. I think this change would impact the performance on filtering. I will let the user know the downside of making this change and then go from there.
Appreciate the valuable input and suggestions. Thanks
