Skip to main content

I created a persistent boolean custom field for Purchase Requisition and Purchase Requisitions, then created a read-only boolean custom field for use on Purchase Requisition Lines. The custom field is  named Order_Complete (OC).

The idea was to use OC to identify whether an order was closed or not. If I only type ‘+’ in the order_complete search field, the 6 records appear, as expected, and using ‘-’, on Purchase Requisition Lines ONLY, the read-only field returns orders NOT complete, as expected.

On the other pages, the ‘+’ symbol work as expected but the ‘-’ has always yields a No Data Found error.

I do not think I arrived at the correct query for the read-only field until I took care of the null values, for which I used NVL on Order Complete where null value defaults to FALSE..

Anybody see anything obvious? 

As there are NULL values in the ORDER_COMPLETE column, the query to find NULL or FALSE can be achieved using:

!%

That’s it. There is no more to this solution but I still want to know why a body cannot search using -

 

 

Reply


Terms & ConditionsCookie settings