Finding Records Question

Classic Servoy
1

I want to create a method that will find all records created for the current date and then sort them in descending order; very easy to do in FileMaker but not at all obvious in Servoy.

Also how do you find records that have a Null value in a specific field?

TIA

2

Maytbe this gets you going…

controller.find();
enddate = ‘^’ //Gets records where the enddate is null
controller.newRecord();
enddate = “>=” + utils.dateFormat(new Date(),‘dd-MM-yyyy’)+ ‘|dd-MM-yyyy’; //Where enddate >= than current date
controller.search();

Paul

3

rochard:
I want to create a method that will find all records created for the current date and then sort them in descending order; very easy to do in FileMaker but not at all obvious in Servoy.

Also how do you find records that have a Null value in a specific field?

TIA

Searching for current date:

var today = new Date()
controller.find()
dateField = ‘#’ + today
controller.search()

Searching for a null value:

controller.find()
field = ‘^’
controller.search()

You can see a listing of all tokens used in searches by accessing the Servoy Help (F1 or choose from “Help” menu) - and going to the “Search” tab and enter “find” (no quotes) in the search box and clicking “Search”.

Hope this helps,

Bob Cusick