FORUM PLAN UPDATE
Date revision: This forum will remain open to new posts and responses until December 1, 2018. (After that date, you will still be able to view and search the forum.) Also, we're taking a second look at the best place to host future conversation. For now, keep using this forum, and stay tuned for more news.



Oct 6, 2015, 9:37 PM
110 Posts

If you insist on using categorized column/view filtering

  • Category: Other
  • Platform: Windows
  • Release: 8.5.3
  • Role:
  • Tags: View Filtering
  • Replies: 4

If this is a newly built application, then maybe it's not too late to add an extra field (let's call it "leaveMonths"). This "leaveMonths" field will store text value like following (from your first example):

leaveMonths
072015-072015
082015-092015
122015-122015

If this is an existing application, then I'd suggest you just write a simple LS agent to insert the leaveMonths to each existing Timesheet document.

Once the above is done, create a Notes View which the first column is the leaveMonths (make sure it's categorized and sorted).

Then, on your viewpanel, compute the "Filter by category name" with the value for example "viewScope.selectedMonths".

And finally I assume you page should have the following 3 controls:

control function
DateTimePicker 1 to select the first month
DateTimePicker 2 to select the second month
Button
  1. set the value of viewScope.selectedMonths to something like 082015-092015 (based on what you select using both the DateTimePicker)
  2. Refresh the whole page

The above is how I would approach the problem if my understanding is right. I didn't do an actual test. Although I'm not quite sure why on one situation you can select just 1 month (July) and on another situation you can select 2 months (August and September). Will there be another situation where you can select 3 months, 4 months, and so on? If the no. of months you can select varies then maybe my approach is not suitable.


FORUM PLAN UPDATE
Date revision: This forum will remain open to new posts and responses until December 1, 2018. (After that date, you will still be able to view and search the forum.) Also, we're taking a second look at the best place to host future conversation. For now, keep using this forum, and stay tuned for more news.