Tagged: Date, Filter Input, range, report
This topic contains 11 replies, has 2 voices, and was last updated by 
- AuthorPosts
- July 2, 2013 at 7:02 am #6584
Hi Again, Can someone point me in the direction of how to implement an option to have a date filter on a report I am currently building?
I.E. 2 Boxes, first Labelled Start Date and the Other End Date —> Button beside which then applies a filter to the Data Grid below that only shows form instances with a Last Submission Date that falls between the values entered in the 2 Boxes.
July 2, 2013 at 8:16 am #6588Use a Filter Input object and set for Day and Range. Please see our help guide: /Documentation/manual/html/?adding_a_filter_input.htm
July 2, 2013 at 2:38 pm #6597Thanks,
I did read through this but it doesn’t really define how to do what I need. I am confused as to how I link the 2 filters together (startDate – finishDate)
I will have a further look today.
Cheers
July 2, 2013 at 2:40 pm #6600If you use a Filter Input object and set it to Date and Range it will give your users two date inputs (start and end).
July 2, 2013 at 2:42 pm #6601Also, forgot to ask.
will this be looking at the {Meta – Last Submission Date} or can I specify to look at what I like (For example when the formInstance is first submitted I place the date into a Hidden FLD, could I direct the filter to look at that)
July 2, 2013 at 2:43 pm #6603Yes you can.
August 7, 2013 at 2:37 pm #6656I found something a little annoying with this.
The dayRange filter doesn’t have an option to change the format of the date! It is set to MM/DD/YYYY but we in Australia need it as DD/MM/YYYY! (Yes, I know it has a calendar selector but when it passes the result into the FLD its displayed as mentioned above)
Its not a huge deal but maybe something that could be improved upon.
August 7, 2013 at 2:40 pm #6659I will submit a development request on your behalf.
August 7, 2013 at 2:58 pm #6660Also,
Something else that could be improved. If you set the FLD source of dayRange filter to a FLD that isn’t of type date but it still has a date value in it (like format “8 Aug 2013”) the lookup within the report hangs…
Can be replicated by using a behaviour to placed util-CurrentDate into a FLD on a form on submission.. then subsequently build a simple report which has a dayRange filter linked to that FLD..
Hope that makes sense???
August 7, 2013 at 3:00 pm #6663What is “FLD”?
August 7, 2013 at 3:10 pm #6664Sorry, FLD = Text Input Field
August 7, 2013 at 3:13 pm #6666A filter input cannot populate a Text Input Field. Therefore the format of a date range in a Filter Input should have no bearing. As you pointed out, it has a calendar selector.
True, you cannot use a Text Input Field as a date source in a report.August 7, 2013 at 3:16 pm #6667Okay thanks for your help
- AuthorPosts
You must be logged in to reply to this topic.