How to filter by Date

Question

I have a dropdown that have 3 values (Status Values): All, Active, Inactive and a Table with results.

The dropdown will filter the table results by the status, this status depends on a field that is from Date value.

• Active: End_date is null. Returns the results that do not have a end_date

• Inactive: end_sate is not null. Returns the results that have a end_date

• All: will not query by nothing. Returns all results

Answer 1

First things first you need to create a parameter in your query script datasource:

Once you have the parameter, you can bind it to dropdown's value and add the following code to the onValueChange event

app.datasources.MyTableDatasource.load();

Your query script code will look similar to this:

var status = query.parameters.Status;

switch(status) {
  case 'Active':
    query.filters.end_date._equals = null;
  break;

  case 'Inactive':
    query.filters.end_date._notEquals = null;
}

// we keep original query to preserve its paging and sorting settings
// and we do not set any additional filters in case selected status
// is not Active or Inactive
return query.run();