Type<\/strong><\/p>\n<\/td>\n Description<\/strong><\/p>\n<\/td>\n<\/tr>\n 0<\/p>\n<\/td>\n Default<\/p>\n<\/td>\n -1<\/p>\n<\/td>\n Inner Calendar Type<\/p>\n<\/td>\n 2<\/p>\n<\/td>\n Holiday Schedule<\/p>\n<\/td>\n 1<\/p>\n<\/td>\n Customer Service<\/p>\n<\/td>\n When we create the records for the weekly schedule for Facility\/Equipment and Users, Business Closure, Holiday Schedule and Customer Service Schedule in CRM, out of public view, CRM creates the records for them in the Calendar and Calendar Rule entity. Below, we have explained how the records are created in Calendar and Calendar Rule entities and how we can<\/strong> retrieve them.<\/p>\n Note: <\/strong>As we can\u2019t do the Advance find for the Calendar and Calendar Rule entity, we have displayed the records from the SQL database below. By\u00a0using the OrganizationService, you can programmatically retrieve the Calendar and Calendar Rule\u2019s records.<\/span><\/p>\n 1. Default type for Business Closure<\/span><\/strong>: By default CRM have a record in the Calendar entity for Type O and Name \u201cBusiness Closure Calendar<\/strong>\u201d as shown in the below screenshot:<\/p>\n Now if we create the records of the Business Closure in CRM, it will create the record for \u201cBusiness Closure Calendar<\/strong>\u201d in the \u201cCalendar Rule<\/strong>\u201d entity and\u00a0not in the Calendar. Hence the records of the Business Closure are created only in the Calendar Rule entity as shown in the below screens:<\/p>\n \n Now if you need to retrieve all the Business Closures, then you need to\u00a0follow the below steps:<\/p>\n 2. Default & Inner Calendar type, and how it works for Weekly Schedule of Facility and User<\/span><\/strong>: When we define the weekly schedule for facility or users as shown below:<\/p>\n For this schedule, CRM then creates a record, with Type O (Default) in Calendar entity.<\/p>\n As shown in the above screen (Weekly schedule setting for facility<\/strong>), we have chosen the 5 day in a week rule, and Work Hours are 8:00 AM \u2013 5:00 PM. Hence it will create the another Calendar record with Type -1 (Inner Calendar<\/strong>) as shown below:<\/p>\n And for the combination of Inner<\/strong> Calendar Id \u201cFF4BEDC7-BE1B-E411-80DB-00155D000819<\/strong>\u201d and Calendar id \u201c766D0EA5-675F-4F9B-B972-F60908804B14<\/strong>\u201d, it creates the \u201cWeekly Single Rule<\/strong>\u201d in the Calendar Rule entity as shown in the below screenshot:<\/p>\n And if we check the Calendar Rule for \u201cFF4BEDC7-BE1B-E411-80DB-00155D000819<\/strong>\u201d (Inner Calendar ID of 766D0EA5-675F-4F9B-B972-F60908804B14<\/strong>), then we find\u00a0that it only contains the Offset and Duration and that Offset and Duration helps us to create the start and end time of Schedule as shown in the below screen:<\/p>\n Hence, if we need to create the Start & End Time of the Schedule, then we calculate it\u00a0from Offset and Duration as follows:<\/p>\n Start Time<\/strong> = Offset\/60, hence in our case. It will be 480\/60 = 8:00AM<\/p>\n End Time<\/strong> = (Offset + Duration)\/60 = (480 + 540)\/60 = 1020\/60 = 17 = 5:00 PM<\/p>\n Now if you define any time Off in the schedule of Facility or User, it will create the record in the Calendar Rule, where the Description will be \u201cTime Off Rule<\/strong>\u201d as shown in the below screens:<\/p>\n Now, if you need to programmatically find the schedule of any facility between the given dates, then there are two ways of\u00a0doing it:<\/p>\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ExpandCalendarRequest req = new ExpandCalendarRequest();<\/p>\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 req.CalendarId = new Guid(“766D0EA5-675F-4F9B-B972-F60908804B14”);<\/p>\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 req.Start = DateTime.Now.AddDays(-20);<\/p>\n \u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0req.End = DateTime.Now.AddDays(20);<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ExpandCalendarResponse res = (ExpandCalendarResponse)_service.Execute(req);<\/p>\n In response, it will return an\u00a0array of schedules. If user is\u00a0available during\u00a0that time, then it displays the Time Code as \u201cAvailable<\/strong>\u201d, otherwise it will display the Time Code as \u201cUnavailable<\/strong>\u201d in that particular schedule. 3. Holiday Schedule<\/span><\/strong>: When you create a new Holiday Schedule in the CRM, it creates the new Calendar\u2019s record for the Calendar Entity, with type 2 as shown in the below screens:<\/p>\n Same as Business Closure, if you create the records under Holiday, it will create the records of the Calendar Rule entity where Description will be \u201cHoliday Rule<\/strong>\u201d as shown below:<\/p>\n Now if you need to retrieve all the Holiday Schedules, then you need to follow the steps below:<\/p>\n 4. Customer Service<\/span><\/strong>: When we create the Customer Service Calendar in the CRM, it creates 2 calendar records out of public view.<\/p>\n One record is created with type 1 (Customer Service<\/strong>), and another is created with Type -1 (Inner Calendar<\/strong>). This is same as the Weekly Schedule<\/strong> of Facility or User. In the Customer Service Schedule, we can provide the \u201cHoliday Schedule<\/strong>\u201d as shown below:<\/p>\n Now if you need to programmatically read the Customer Service Schedule between the given dates, then you can use the Expand Calendar Request as we did the for the Facility \/ User Schedules.<\/p>\n Note: Using the Expand Calendar Request, you can\u2019t retrieve the Business Closers, Time Off and Holiday Schedule calendar\u2019s records between the given dates<\/span>.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":" In this blog, we have explained how CRM stores the records for calendar, and how can we programmatically retrieve them from CRM. In CRM 2013 SP 1, two new calendar types are introduced. With that, we now have the following 4 types of calendars in CRM: Type Name Description 0 Default This type uses for\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[21,22,24],"tags":[237,394,1418,1541,1649],"class_list":["post-815","post","type-post","status-publish","format-standard","hentry","category-dynamics-crm-2013","category-dynamics-crm-2015","category-dynamics-crm-2016","tag-calendar","tag-crm-2013-sp1","tag-records","tag-schedule","tag-spring-wave"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/815","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=815"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/815\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=815"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=815"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Name<\/strong><\/td>\n \n \n \n \n This type uses for business closure and work schedule\u2019s records of service scheduling.<\/td>\n<\/tr>\n \n \n \n Inner Calendars are used by other calendars to build a graph of time slots available for customer service or service scheduling to be performed.<\/td>\n<\/tr>\n \n \n \n This is also a new Type of calendar. And it uses for creating the Holiday Schedule records.<\/td>\n<\/tr>\n \n \n \n This is new type of calendar. And it uses for creating the Customer Service Schedule records.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n ![\"img1\"](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2014\/08\/img11.jpg\")
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a>Now, if you need to programmatically read the \u201cTime Off<\/strong>\u201d of any resource (Facility or User), then you need to follow the below steps:<\/p>\n\n
\n
<\/a><\/p>\n<\/a> <\/a><\/p>\n<\/a><\/p>\n\n
<\/a><\/p>\n