Sign in

Microsoft.com

Microsoft

Remove From My Forums

Creating a custom View

Question
0

Sign in to vote

I have an entity called new_inputs that has a date field. The date field (new_cleareddate) is the date the input clears. I can create a view that show's me all items clearing for the following day.

My problem is that cleared items do not clear on a weekend or bank holiday, so the view on a Friday is incorrect, Is it possible to create a view where the 'next day' is not a weekend or not a closed business day stored in the business closure entity?

Dont ask me .. i dont know

Saturday, October 11, 2014 6:02 PM

Answers

0

Sign in to vote
Hi Pete,

One possible solution is to use a plugin to intercept the View (RetrieveMultiple message) and modify the date condition in the query. In code, you do have some control of determining weekends and perhaps public holidays if you feed those dates in via the unsecure config.

Here is a blog that may get you started.

http://hachecrm2011.wordpress.com/2013/07/19/filtering-views-by-intercepting-retrieve-multiple-queries-with-a-plugin/

Good Luck.
Eric UNG [Senior Analyst Programmer :: Sydney, Australia]
- Marked as answer by Pete Newman Tuesday, February 17, 2015 11:59 AM
Saturday, October 11, 2014 10:02 PM

All replies

0

Sign in to vote
Hi Pete,

One possible solution is to use a plugin to intercept the View (RetrieveMultiple message) and modify the date condition in the query. In code, you do have some control of determining weekends and perhaps public holidays if you feed those dates in via the unsecure config.

Here is a blog that may get you started.

http://hachecrm2011.wordpress.com/2013/07/19/filtering-views-by-intercepting-retrieve-multiple-queries-with-a-plugin/

Good Luck.
Eric UNG [Senior Analyst Programmer :: Sydney, Australia]
- Marked as answer by Pete Newman Tuesday, February 17, 2015 11:59 AM
Saturday, October 11, 2014 10:02 PM
0

Sign in to vote

Hi Pete,

you can achieve this using exporting your view data to excel (dynamic excel) and then follow steps mentioned in my blog article mentioned below.

http://mayankp.wordpress.com/2012/06/27/how-to-find-records-created-on-weekends-or-created-on-after-working-hours/
MayankP
My Blog
Follow Me on Twitter

Sunday, October 12, 2014 5:33 PM

Answerer