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?