The Undefined Value has no Property Error Msg

Classic Servoy
1

With the following code in my onShow Method:

controller.addFoundSetFilterParam(status, ‘=’, ‘Q’);
controller.loadAllRecords();

I get this error (Yes there is a char field called status).
I am not sure what this error means.

Thanks

Bruce

p.s. Can I use relations in an addFoundSetFilterParam i.e.
controller.addFoundSetFilterParam(order_lines_to_order_header.shipto_customer, ‘=’, 260);

2

and what happens if you change this to

controller.addFoundSetFilterParam('status', '=', 'Q');

?

3

sorry, when i copied it in, i had tried it with and without quotes to see what would happen and pasted the wrong one. All 3 params are in single quotes aqnd I still get the error msg

bruce

4

Hi Bruce,

You have to assign the result of the filter to a variable as follows:

var success = controller.addFoundSetFilterParam(‘status’, ‘=’, ‘Q’ );
controller.loadAllRecords();

Cheers
Harry

5

I assigned it to a result and I still get the same error (on some other forms, it works fine without a result being assigned).

bruce

6

the form, is always attached to a table
so if you get the error, there is no such column present.

so you maybe calling it from another form? which is attached to another table?