User Profile & Activity

Tim W Member
Page
of 2

"But if you are in child page, to access your parent page, you can simply use window.parent."

This doesn't seem to work. Do you have a working sample that I can view?

 

Thanks,

Tim

Anyone out there?

This fixed it. Thank you!

I am really needing this issue resolved soon. Is there anyway they can expedite this?

Thanks,

Tim

Any updates on this issue?

This solution will not work for the need that I have. First I need only the total hours between a user specified date range and your solution appears to only calculate a total from beginning to end. Secondly this solution only works if the recurring event has been set to end after a set number of recurrences hence the use of TotalRecurrences field. This would not work for recurring events that have no end or are set to end on a specific date.

The recurring event has many options for setting the scope of the recurring event. Your solution only covers one. For instance if a recurring schedule is altered on one instance the code would need to be aware of that condition.

Do you have other solutions for this recurring events query?

I need to be able to retrieve a total count of hours that a specific resource has been scheduled for within a specific date range.

Let's say that I have a resource that has three events in the webscheduler that have a duration of 2.5 hours each during the week of 12/26/2010 and 1/1/2011 (total of 7.5 hours). That same resource also has a recurring event which has two events during that same week that have a duration of 3 hours each (total of 6 hours).

I would then query the database to get all hours that the specific resource was scheduled for during the date range of 12/26/2010 and 1/1/2011. The query should return 13.5 hours which is the total of all recurring events and events that was scheduled during that period of time for that specific resource.

I would like a count of total hours and a list of dates and hours that make up the total hour count.

Below is some tsql code that I have to query the Events table. The events table is simple to query but to get the same results from the Recurring Events table it is very complex due to all the options for range of the recurrence.

I want to know if you have some sample code to accomplish this for the Recurring Events or if you can help.

 

SELECT r.ID, r.ResourceName, c.CategoryName, e.StartTime, e.EndTime, ((CAST(DATEDIFF(MINUTE, e.StartTime, e.EndTime) AS DECIMAL))/60) AS HoursScheduled

FROM dbo.[Events] e        

     INNER JOIN dbo.Resources r ON e.ResourceID = r.ID

     INNER JOIN dbo.Categories c ON e.CategoryID = c.ID

WHERE r.ID='6' AND (e.StartTime BETWEEN '12/26/2010' AND '1/1/2010') AND (e.EndTime BETWEEN '12/26/2010' AND '1/1/2010')

 

 

This solution did not fix the issue as I am getting the same results.

Thanks the nightly-build of WebScheduler fixed the CategoryID not saving issue.

Now however I have another issue with editing recurring events. If I create a new recurring event and edit one instance of the recurring event then the RecurringEvents table updates the existing recurring event row and adds ParentID to itself and adds exceptioninfo, exceptiondate and start and end time to the existing recurring event instead of creating a new row and adding ParentID and related info to the new row. Then once it does that if you close the scheduler and open it again the recurring event does not show up.

This only happens when you edit the single instance and do not RE-SELECT Category/CarePlan on the edit form. If you don't RE-SELECT the category/CarePlan then the edit form validation detects that the Category/CarePlan was not selected and displays error. Then after you get the validation error and you then select the Category/CarePlan Webcombo and save it saves but has the issue above.

If you select Category/CarePlan before you save then the validation code does not return error and everything saves like it should and a new recurringEvents row is created for the exception like it should.

Here is the edit form validation code below and I have attached a simple sample that uses the nightly-build of the webscheduler.

//Begin Edit form validation function WebScheduler1_OnEditingFormSave(controlId, action, eventView) {var s = ISGetObject(controlId);var editWindow = s.GetEditingFormWindow();var wcCategories = editWindow.ISGetObject("wcCategories");if (wcCategories.Value == "") {alert("You must select a Care Plan");return false;

}

}
//end edit form validation

 

This issue is going to become critical path soon on my project. Is there any way to expedite this?

Thanks,

Tim

All times are GMT -5. The time now is 9:53 PM.
Previous Next