Using OR Operator on Item No. Filed in Item Ledger Entry

sunnyk

Hi Guys,
When i tried to do filter records in ILE on Item No.(Table/field Filters) using OR Operator i got the below error.

The Filter 'ITEMNo-AAAAA|ItemNo-BBBBB' on Item No. field in the Item Ledger Entry Table Should specify an interval.

Why cann't i use the OR operator?

I am using 3.7 with 5.0 exe.

crisnicolas

I just tried this on the Item Ledger Entries form, using an OR filter on the Item No. field, and I had no problems.

Could you explain where are you using this filter? (is it a user filter?, is it a filter you have on your code?, is it a filter on a TableView?, is it a filter on the CalcFormula of a FlowField?, etc.)

Belias

there's probably some personalization (or probably standard code, i don't remember) on the list that does a GETRANGEMIN or GETRANGEMAX function... :-k
you can activate the debugger to catch it...use the onlinehelp to gain more info on getrangemin and getrangemax functions, if you don't know them

sunnyk

HI Belias, You are right. its a getrangemin and getrangemax fuction(customized ) that is causing this error.
Thanks