Shift Schedule

[Former Member]

Hi,

Is there anyway to read shift schedule( in xMII Menu->Data Services->Time Period Schedules) through a query? I need to display this shift schedule as a drop down in in a html page.

Thanks,

Srinivas.

[Former Member · Accepted solution]

Check out the Predefined queries in /Lighthammer/Illuminator/Templates/Predefined.

[Former Member · Accepted solution]

Ryan,

I checked queries under this folder.

ScheduleListQuery is listing all the different schedules we had in the xMII server.

TimePeriodListQuery is listing all the Time periods that I configured in the system.

But I am looking for the query which gives Timeperiods under a particular Schedule.

I checked Predefined/ScheduleDetailQuery but it is not returning any thing.

Thanks,

Srinivas.

[jcgood25 · Accepted solution]

Srinivas,

<a href="http://localhost/Lighthammer/Illuminator?QueryTemplate=Predefined/ScheduleDetailQuery&Group=SampleShiftSchedule">http://localhost/Lighthammer/Illuminator?QueryTemplate=Predefined/ScheduleDetailQuery&Group=SampleShiftSchedule</a>

If you are using an applet then just add this next to the Query Template line:

<PARAM NAME="Group" VALUE="SampleShiftSchedule">

If you need to adjust it with JavaScript then use document.APPLET.getQueryObject().setGroup("NAME");

Regards,

Jeremy

[Former Member · Accepted solution]

Jeremy,

My plan is to use it along with an iBrowser applet. So that user can select from drop-down. I am posting the code below for community.

<APPLET NAME="Untitled" CODEBASE="/Illuminator/Classes" CODE="iBrowser" ARCHIVE="illum8.zip" WIDTH="640" HEIGHT="20" MAYSCRIPT>

<PARAM NAME="QueryTemplate" VALUE="Predefined/ScheduleDetailQuery">

<PARAM NAME="DisplayTemplate" VALUE="UserTemplates/iBrowser">

<PARAM NAME="Group" VALUE="SampleShiftSchedule">

</APPLET>

Thanks for your help.

Srinivas.