How to filter records by date range using "created" metadata field in Confiforms TableView

[Anne Luckey]

I would like a TableView to filter records by a specific date range based on the "created" metadata field. 

Initially, I had users submit a date, and filtered for entries based on this field. Example: I used "date:<[date20240102] AND date:>[date20231212]" to only display entries where the user selected a date between December 12, 2023 - January 2, 2024.

I want to omit having users submit a specific date (and delete the "date" field), and perform the same function based on the metadata field "created". 

Can someone help me with what I should use in the "filter to apply on entries dataset" to accomplish this? 

[Alex Medved _ConfiForms_]

Hi @Anne Luckey 

Using filtering expression like this

created:<[date20240102] AND created:>[date20231212]

Alex

[Anne Luckey]

Hi Alex, thanks for your response! I appreciate your help - I was overthinking it. 

Is there a way to view the metadata fields when toggling "view/edit form data", or is it only possible in a View macro?

[Alex Medved _ConfiForms_]

Admin UI does not show those fields in separate columns

Only when you hover over the row

But you can always create a custom view over your collected data and include those fields 

Alex

[Miles Smith]

I'm thinking - is there a way to filter records in a tableview by the current date (so a table only shows records, such as milestones, that exist before or after the current date).

Please let me know if you have any ideas?

[Alex Medved _ConfiForms_]

Of course you can

You can access current date from the context https://wiki.vertuna.com/display/CONFIFORMS/Accessing+field+values+and+properties#Accessingfieldvaluesandproperties-Additionalvaluesavailableinthecontext

and use that in a filtering expression

somedate:>[entry._now]

(somedate is after today/now)

Alex

[Anne Luckey]

EDIT: Figured it out! Nevermind. 

One additional question, I submitted an entry in my form this morning and it did not show in a tableview with this filter: created:>[date20240222 06:00] AND created<[date20240305 05:59]. 

Can you help me identify why it would not show in this tableview? I have used the same tableview filtered by different dates that have shown records before. For reference, I am in CST.