I have a grid that needs a filter that I just can't seem to figure out.
I need it to filter to show records that are either (JobSchedule > 0) OR (PercentComplete < 1) which I have working BUT users sometimes add a criteria to narrow the grid down to a specific JobNumber. When they try to filter to a specific job record and the above filter is applied, it adds the 3rd criteria as an OR when I need it to be AND. Basically if the user adds any new criteria to filter down to, such as Job#222, I need it to ONLY show Job#222.
Here is the current filter:
with gvMilling.DataController.Filter do begin
Root.BoolOperatorKind := fboOR;
Root.AddItem(gvMillingJobSchedule,foGreaterEqual, '0', 'Department Start Range');
Root.AddItem(gvMillingMil_Total_PercentComplete, foLess, '1', '100%');
Active := True;