Field Filter working unexpected and returns partial data when applied

1

HI, I have created a SQl question and have used field filter in the same.
While the filter works, but it retrives partial data.
PFA screen captures below with the description. Need an assistance on the same to solve this issue.

Date range filter returns nothing
Date range filter returns nothing1555×657 80.8 KB

Date Range field filter returns nothing when selected Yesterdays date.
While without filter it shows yesterdays data.

(Providing images in subsequent comment as it's not letting me upload more than one image)

2

relative date filter returns nothing
relative date filter returns nothing1566×768 83.2 KB

Even Relative Date field filter returns nothing when selected yesterday date.

3

relative filter doesn't retrieve latest 2 days data
relative filter doesn't retrieve latest 2 days data1552×648 114 KB

Relative Date field filter retrieves data without previous (latest) 2 days data when applied Past 7 days in the filter.

4

Without filter it returns
Without filter it returns1553×597 110 KB

Without filter it fetches the records which show records present for last 2 days.

5

You’re not comparing the filter values to anything.
Shouldn’t you be comparing the filter to a column in the database.
Your SQL is just returning:
AND ‘2018-02-07’
instead of
AND table.columnName = ‘2018-02-07’

Unless there’s some weird SQL syntax here.

6

This smells like a timezone bug, or perhaps related to the issue where we’re incorrectly appending a time value to dates that don’t have one (I’m seeing a lot of 12:00 AM in your dates).

1 Like
7

You’re not comparing the filter values to anything.
Shouldn’t you be comparing the filter to a column in the database.
Your SQL is just returning:
AND '2018-02-07’
instead of
AND table.columnName = ‘2018-02-07’

Unless there’s some weird SQL syntax here.

This syntax is correct when using Metabase's field filters. That syntax is actually inserting a whole SQL clause, rather than just a single value. That's what enables things like date range filters, or category value dropdown filters. See here:

8

@maz The field filter (date range) is mapped to ‘creation_date’ whose data type is timestamp in my database (mysql). Is this the issue? Any solution for this?