How to filter by date

[irfanyppc]

Hi,

I have a field in Postgres of Date type. I am able to use this plugin to search for text string using regex, however unable to filter by date range.

Could you please suggest a tip of how this could be achieved.

Thanks

[matthewhegarty]

I believe it will be possible using a combination of django-filters and yadcf. Please refer to this thread for guidance. If you get it working please consider adding it to the example app.

[orientalperil]

@TauPan can you help by providing the JavaScript code needed to filter the date field. I'm trying to call the datatables search() function but it only takes one string as an argument. What did you pass to give it a after and before date?

[TauPan]

The project that was using this code has been discontinued so I don't know if it will still work, with current code, but I was using this function to generate the options for the datetime-ranges:

export function date_range_options(name) {
  return {
    column_selector: `${name}:name`,
    filter_type: 'range_date',
    datepicker_type: 'bootstrap-datetimepicker',
    date_format: 'YYYY-MM-DD HH:mm:ss',
    filter_delay: 1000,
    filter_plugin_options: {
      keepInvalid: true,
      showClear: true,
      showClose: true,
      showTodayButton: true
    }
  };
}

which was called inside the yadcf-parameters for the datatable with just the name of the field.

The python api was using the following widgets and fields:

class YADCFRangeWidget(widgets.RangeWidget):

    def value_from_datadict(self, data, files, name):
        if name not in data:
            return None
        val_string = data[name]
        if val_string is None or val_string == '':
            return None
        vals = data[name].split('-yadcf_delim-')
        new_data = data.copy()
        del new_data[name]
        for val, suffix in zip(vals, self.suffixes):
            new_data[self.suffixed(name, suffix)] = val
        return super().value_from_datadict(new_data, files, name)


class YADCFDateTimeRangeWidget(YADCFRangeWidget):

    suffixes = ['after', 'before']


class YADCFIsoDateTimeField(fields.IsoDateTimeField):

    input_formats = (fields.IsoDateTimeField.input_formats
                     + list(fields.forms.DateTimeField.input_formats))


class YADCFIsoDateTimeRangeField(fields.RangeField):

    widget = YADCFDateTimeRangeWidget

    def __init__(self, *args, **kwargs):
        fields = (
            YADCFIsoDateTimeField(),
            YADCFIsoDateTimeField())
        super().__init__(fields, *args, **kwargs)


class YADCFIsoDateTimeFromToRangeFilter(filters.IsoDateTimeFromToRangeFilter):

    field_class = YADCFIsoDateTimeRangeField

The YADCFIsoDateTimeFromToRangeFilter() was used in a DatatablesFilterSet subclass.

[orientalperil]

Awesome thank you for the code