How can we add ‘OR’ or ‘Other’ filter in Navision Query object ?
Currently only ‘AND’ condition is Possible ?
You can add OR filter in query object:
For exp.
If you want only two unit_Cost value in Item table .You can declair Unit_Cost as Filter in query obj. and in ColumFilter Property of this write this filter.
Unit_Cost=FILTER(6,670|49,210)
Regards
Suraj
Suraj thank for the replay.
It is possible in below exp.
I have one table lie ABC
Field 1 = No.
Field 2 = Desc.
…
Field 6 = Starting Area
Field 7 = Ending Area
Note :
- Starting Area & Ending Area value is almost same
- Some time we entr value in starting area only and some time Ending Area only
My Question is If I am giving area in filter then I have required checking in starting and ending area
Any of the one filed value found then show that record
It Is Possible ?
it should be like
record.setrange(“Field 6”,input);
IF NOT record.findfirst THEN BEGIN
record.setrange(“Field 6”);
record.setrange(“Field 7”,input);
IF record.findfirst THEN BEGIN
//Code what you want to do after getting the record.
END;
END ELSE BEGIN
//Code what you want to do after getting the record.
END;
Code can be optimized later.
Yes I Know, It’s possible using recordset but it’s affecting in performance side
My View
Month D1 D3…D30
Assigned Order 7500 8900 …10,000
UnAssigned Order 2000 …
Total Order 8500 … .
If I am press any of day then show the all detail of the orders.
If I am using Query for showing records then it’s work fast
If I am using Recordset for showing records then it’s work slow