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

sunnyk · 2010-05-04

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 · 2010-05-18

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 · 2010-05-18

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 · 2010-06-22

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

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

Answers

Categories