Help with Tables: Apply Filter

Options
Adam_636382
Adam_636382 Posts: 32
in Questions

My process is meant to filter records from a master data table where the Process Start Date is between two dates. The two dates are provided in a web form as "Start Date" and "End Date".
There are thousands of records in the master table, but my filter keeps coming back with zero results. Can you tell what I'm doing wrong?
Thanks!

Answers

  • Tom_175281
    Tom_175281 Posts: 7
    Options

    Hi @Adam_636382. I've been working on something very similar, and I've gotten it to work using handlebar references to fields instead of using the fields[' '] style reference.

    I wonder if you can get the process to work by using this:

    columns['Process start date'] >= {{start-date}} && columns['Process start date'] <= {{end-date}}

    Let us know if that works!

  • Adam_636382
    Adam_636382 Posts: 32
    Options

    Hi Tom,
    This is what I started with originally but I was still not able to get the data to filter as I was expecting. I also saw you posted a separate question around processing time to complete this action. Are there any tips on what can be done to improve processing time?

Categories