PDA

View Full Version : Databse filters.



Michael Mullan
24-May-2010, 10:57 AM
IN VRW how does on replicate this DF constraint?



(pos(SCHED.STAFF_DISP, "OK|MF|MH") > 0))


I tried setting the filter in the selection, but the EQ selections seem to be "AND" not "OR".



SCHED.STAFF_DISP = "OK" AND
SCHED.STAFF_DISP = "MF" AND
SCHED.STAFF_DISP = "MH"


rather than



SCHED.STAFF_DISP = "OK" OR
SCHED.STAFF_DISP = "MF" OR
SCHED.STAFF_DISP = "MH"

Vincent Oorsprong
24-May-2010, 02:31 PM
Michael,

You have to use the filter function for this kind of filtering. The filter expert indeed uses AND settings and tries to optimize the search, a thing that the filter function cannot do.

Michael Mullan
24-May-2010, 03:39 PM
Can you add a feature request to HDE for "or" join on conditions on the same field, to cover this case.

I realize that to do it fully you'd have to allow the user to enter the "OR" command, and the parenthesis to show which values were being "OR"ed, but if i make two conflicting EQ matches, then can we "or" them?

Michael.