Foundset searching with wild card, etc

Classic Servoy
21

ROCLASI:
Hi Bogdan,

For date ranges (and number ranges) you can use the … operator in Servoy.
Servoy translates that to the BETWEEN sql statement.

So your code would be like this:

function addDateRangeCondition1(foundSet) {

// yes this is one single line of code
foundSet.booking_start = “#” + utils.dateFormat(globals.vReservationsSelectedDate, “yyyy-MM-dd”) + “…” + utils.dateFormat(globals.vReservationsSelectedDateEnd, “yyyy-MM-dd”) + “|yyyy-MM-dd”;
}




Hope this helps

Thanks! I’ll try this, but I don’t need only ranges. See condition 3. I also need to check if one date field is greater then a date and another date field lower then another date. How can I do that?

22

It works now. I had to use the “…” for the same field compared with 2 values. It was stupid of me to use 2 values for the same field.

And it works without the ‘#’. I had to remove it.

Thanks!