Kinetic Form -- GetRows Event Whereclause

Kinetic ERP
1

Howdy,

I need to fire an event that will get a range of rows in UD04. So, what would I put into the whereclause to get records for today’s date and later? If there isn’t a constant value available in the form I can fire a function to return it. But I don’t know how to poke the JSON result into this field.

??

Thanks,

Joe

image
image853×519 56.8 KB

2

You might be better off just creating a BAQ with a filter of UD04.Date01 >= BAQ Constant Today and calling that

3

I think I’ve decided to use an updatable dashboard anyway, but it would be nice to know how to do this.

Thanks,

Joe