Hello there,
I am trying to pass a parameter to the Shift Date column in the table. I have rendered the column as date and I am trying to pass a value for "date equals" condition. When I tried passing "2024-02-28" it doesn't work when the passed value even matches the format. When I manually try to filter that date in the table, below is the returned string in the value field -
{
"$": [
"ts",
0,
1712938668587
],
"$ts": 1709058600000
}
Can somebody please help how to pass this parameter ? I tried parsing it to milliseconds using toMilli function but it doesn't filter either.
Welcome to the forum.
-
You've posted this in someone else's five year old thread on a different topic. You should have started a new thread. (A moderator has now fixed this.)
-
When posting code (such as your JSON) you need to format it. See Wiki - how to post code on this forum.
-
Terminology:
I am trying to pass a parameter to the Shift Date column in the table.
You're not passing a parameter. You're trying to pass a value to a column's filter property.
Have you set each column's column.x.field property to the case-sensitive dataset column name? If you don't many of the column settings won't work.
1 Like
I'm able to replicate this and have opened an internal ticket to get it fixed. We'll try to update this thread when the fix is supplied. Said fix is unlikely to be undertaken anytime soon.
1 Like
Of note from my attempts to replicate: It looks like the filter is actually applied, but only at the day/month/year level. If you were to supply a valid value of any other day in time you would see that the 2024-02-28 days would be removed.
In my replication scenario I had two entries on the same day but at different times. I applied an exact match to an entry in one of my rows and saw no change. When I changed the day in my second row to some other day, it was immediately removed from the Table.
@Deepak_Bhattacharya Are you supplying this filter as a string? I wouldn't expect that to work because we aren't able to parse string representations of dates for comparison. You might need to contact Support for further assistance, as my attempts to replicate were actually invalid because I was supplying a datetime object while specifying a condition of "date equals" instead of "date time equals".
Edit: updated this post because the site won't let me post more than two consecutive replies.
