How to connect to Actuate server DB

<p>The database name for the iHub's metadata is "ihub". It is not located in the default postgres database.</p>
<p>Inside the ihub database, the schema is named "ac_cluster" by default.</p>
<p> </p>
<p>The table structure for the iHub 3+ releases has also changed from the previous iServer releases.</p>
<p>AC_USER is now v_user (for volume user) and AC_FILES_AND_FOLDERS is now v_file_or_folder.</p>
<p> </p>
<p>As always, be very careful when accessing the iHub's metadata and make sure to backup the metadata.</p>

<p>Hi,</p>
<p> </p>
<p>As far as I can tell, the information about which day(s) of the week a weekly report is run is in the <span style="font-family:'courier new', courier, monospace;">period_days</span> column. Sunday's value is 2^31,Monday's is 2^32, so on and so forth. Multiple days are added together.</p>
<p> </p>
<p>Hope this helps,</p>
<p> </p>
<p>P.</p>

<p>i get this as per your mail of <span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;font-size:12px;background-color:rgb(247,247,247);">2</span>^31,<span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;font-size:12px;background-color:rgb(247,247,247);">Monday's is 2</span>^32,<span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;font-size:12px;background-color:rgb(247,247,247);"> so on and so forth. Multiple days are added together.</span></p>
<p><span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;font-size:12px;background-color:rgb(247,247,247);">I have added togther and you are right it adds up to </span>197568495616.</p>
<p>But how do i reverese engineer to get it as 2*33 <span> </span>   + 2*34 <span> </span> + 2*35 <span> </span>+ 2*37 and then eventually show in my Report as Scheduled for </p>
<p> </p>
<div>Tuesday,Wednesday, Thursday and Saturday</div>
<div> </div>
<div>2*33 <span> </span>   + 2*34 <span> </span> + 2*35 <span> </span>+ 2*37</div>
<div> </div>
<div>8589934592 + 17179869184 + 34359738368 <span> </span>+ 137438953472 = 197568495616</div>
<div> </div>
<div> </div>
<div>Also i do not get the Last day of week from the number : 1073741824</div>
<div> </div>
<div>Please help.</div>
<div>Thanks</div>
<div>Raj</div>

<blockquote class="ipsBlockquote" data-author="pricher" data-cid="145043" data-time="1472054597">
<div>
<p>Hi,</p>
<p> </p>
<p>The following code snippet in JavaScript will read the value from the database and create an array that shows the days of the week selected, the value "1" being selected:</p>
<pre class="_prettyXprint _lang-">
var days = the value coming from the period_days column;
var weekdays = [0,0,0,0,0,0,0]
for (exp = 37; exp >= 31; exp--) {
if (days - Math.pow(2,exp) >= 0) {
weekdays[exp-31] = 1
days = days - Math.pow(2, exp)
}
}
</pre>
<p>As for the last day of the week, I do not know.</p>
<p> </p>
<p>P.</p>
</div>
</blockquote>
<p>Thanks Pricher</p>
<p>But i have an SQL which uses Period_days as a column so  i use the Query in Before Open method of Dataset.And how do i use it with this javascript ?</p>
<p>Thanks</p>

<blockquote class="ipsBlockquote" data-author="pricher" data-cid="145048" data-time="1472058875">
<div>
<p>You can create a computed column in your Data Set that will read Period_Days and determine the week schedule. Here's the expression for that computed column, assuming a column named Period_days:</p>
<pre class="_prettyXprint _lang-">
var days = row["Period_days"];
var weekdays = [0,0,0,0,0,0,0];
var weekdaysStr = ["Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"];
var schedule = "";

for (exp = 37; exp >= 31; exp--) {
if (days - Math.pow(2,exp) >= 0) {
weekdays[exp-31] = 1;
days = days - Math.pow(2, exp);
}
}
for (i = 0; i < 7; i++) {
if (weekdays[i] == 1) {
schedule = schedule + (schedule != "" ? "," : "") + weekdaysStr[i];
}
}
schedule;
</pre>
<p>I have also attached a sample report using a static data set.</p>
<p> </p>
<p>P.</p>
</div>
</blockquote>
<p>Thanks P.</p>

<p>WeekSchedule is just a string created a the data set level. You can use it however and wherever you want.</p>

<p>You've lost me.... Why attempting to modify the query? Based on your initial requirement, you are querying the iHub database to get back the period_days column which is a long integer representing which days of the week are part of the schedule. The code I have sent you takes that value and extract the days, first in an array, then as a string. That code is implemented as an expression in a new computed column of the data set. You will get nowhere by modifying the query.</p>
<p> </p>
<p>P.</p>

<p>i have to concatenate other columns to the WeekSchedules </p>
<p> </p>
<p>i.e. concatenate it to </p>
<p>TO_CHAR(ACSD.START_TIME,' HH:Mi AM') || ' starting ' || TO_CHAR(ACSD.START_DATE,'MM/DD/YYYY')<span> </span>end ) AS SCHEDULES_RECURRING_JOBS,</p>
<p> </p>
<p>So that is why i have to calculate Weekdays inside the Query not outside it.</p>

<blockquote class="ipsBlockquote" data-author="yoovrajkhullar" data-cid="145082" data-time="1472136237">
<div>
<p>P </p>
<p>Thanks a lot.</p>
<p>I resolved it. i had to use the ListAgg on Period_days also to get the 20 rows.</p>
<p> </p>
<p>Thanks a lot once again.</p>
<p>Yoovraj</p>
</div>
</blockquote>
<p>Hi P</p>
<p>Alas used Listagg for Period_days but it gives it like this</p>
<p>Period_days like this</p>
<p>4294967296   ;   23622320128 and WeekShedules column does not give anything.</p>
<p>because the code in javascript is like this </p>
<p>var days = row["PERIOD_DAYS"];</p>
<p> </p>
<p>??</p>
<p> </p>
<p>Please help.</p>
<p>Thanks</p>
<p>Raj</p>
<p> </p>
<p> </p>
<p>This is my Query</p>
<p>( i actually want the WeekSchedules added into SCHEDULE_RECURRING_JOBS Column in the Query)</p>
<p> </p>
<p>i.e WeekSchedule of Tuesday, Wednesday etc in place of <span style="color:rgb(255,0,0);">to_char(ACSD.PERIOD_DAYS)</span><span style="color:rgb(255,0,0);"> </span>in the below Query.</p>
<p> </p>
<div>select  </div>
<div>PERIOD_DAYS,</div>
<div>        --LISTAGG(PERIOD_DAYS, '   ;   ') WITHIN GROUP (ORDER BY PERIOD_DAYS  ) OVER (PARTITION by volume_id,schedule_iid )  as PERIOD_DAYS,</div>
<div>       </div>
<div>VOLUME_ID,</div>
<div>        TIME_ZONE_ID,</div>
<div>VOLUME_NAME,</div>
<div>        JOB_NAME,</div>
<div>        IS_ACTIVE,</div>
<div>        OWNER,</div>
<div>        SCHEDULE_IID,  </div>
<div>        SCHEDULE_CREATE_DATE,         </div>
<div>        TO_CHAR(RTRIM(XMLAGG(XMLELEMENT(e,recipients,';').EXTRACT('//text()') ORDER BY volume_id,schedule_iid,recipients   ).GetClobVal(),';')) as NOTIFICATION_USERS, </div>
<div>        --LISTAGG(SCHEDULES_RECURRING_JOBS, '   ;   ') WITHIN GROUP (ORDER BY SCHEDULES_RECURRING_JOBS  ) OVER (PARTITION by volume_id,schedule_iid )  </div>
<div>        SCHEDULES_RECURRING_JOBS,</div>
<div>       </div>
<div>   </div>
<div>       </div>
<div>   NEXT_RUN_ON,</div>
<div>JOB_TYPE,</div>
<div>REPORT_NAME,</div>
<div>EXECUTABLE_VERSION,</div>
<div>FAILED_JOB_RETRY_POLICY,<span> </span></div>
<div>OUTPUT_FILE_NAME,<span> </span></div>
<div>OUTPUT_FILE_REPLACEMENT_POLICY,<span> </span></div>
<div>IF_JOB_SUCCEDS,</div>
<div>IF_JOB_FAILS</div>
<div> </div>
<div>from</div>
<div>(</div>
<div>SELECT  </div>
<div>DISTINCT <span> </span></div>
<div>LISTAGG(PERIOD_DAYS, '   ;   ') WITHIN GROUP (ORDER BY PERIOD_DAYS  ) OVER (PARTITION by volume_id,schedule_iid )  as PERIOD_DAYS,</div>
<div>   --<span> </span>PERIOD_DAYS,</div>
<div>  <span> </span>VOLUME_ID,</div>
<div>        TIME_ZONE_ID,</div>
<div>VOLUME_NAME,</div>
<div>        JOB_NAME,</div>
<div>        IS_ACTIVE,</div>
<div>        OWNER,</div>
<div>        SCHEDULE_IID,  </div>
<div>        SCHEDULE_CREATE_DATE, </div>
<div>        recipients,</div>
<div>        --TO_CHAR(RTRIM(XMLAGG(XMLELEMENT(e,recipients,';').EXTRACT('//text()') ORDER BY volume_id,schedule_iid,recipients   ).GetClobVal(),';')) as NOTIFICATION_USERS, </div>
<div>        LISTAGG(SCHEDULES_RECURRING_JOBS, '   ;   ') WITHIN GROUP (ORDER BY SCHEDULES_RECURRING_JOBS  ) OVER (PARTITION by volume_id,schedule_iid ) SCHEDULES_RECURRING_JOBS,</div>
<div>   NEXT_RUN_ON,</div>
<div>JOB_TYPE,</div>
<div>REPORT_NAME,</div>
<div>EXECUTABLE_VERSION,</div>
<div>FAILED_JOB_RETRY_POLICY,<span> </span></div>
<div>OUTPUT_FILE_NAME,<span> </span></div>
<div>OUTPUT_FILE_REPLACEMENT_POLICY,<span> </span></div>
<div>IF_JOB_SUCCEDS,</div>
<div>IF_JOB_FAILS</div>
<div>FROM</div>
<div>(</div>
<div>SELECT  DISTINCT <span> </span></div>
<div>ACSD.PERIOD_DAYS,ACSD.START_DATE,ACSD.START_TIME,ACSD.PERIOD_UNITS,</div>
<div>        ACSD.SCHEDULE_DETAIL_IID,</div>
<div>ACJD.VOLUME_ID,</div>
<div>ACS.TIME_ZONE_ID,</div>
<div>ACV.VOLUME_NAME,</div>
<div>        ACJD.JOB_NAME,</div>
<div>        CASE WHEN SCHEDULE_STATE='A' THEN 'Y' ELSE 'N' END AS IS_ACTIVE,</div>
<div>ACU.USER_LOGIN_NAME AS OWNER,</div>
<div>ACSD.SCHEDULE_IID,<span> </span></div>
<div>TO_CHAR(ACJD.CREATION_TIME_STAMP,'MM/DD/YYYY') AS SCHEDULE_CREATE_DATE,<span> </span></div>
<div>        (CASE WHEN ACSD.PERIOD_UNITS ='M' THEN (case when ACSD.PERIOD_DAY_INSTANCE_TYPE = '8' and ACSD.PERIOD_DAY_INSTANCE = '0' Then 'The Last Day ' else ACSD.PERIOD_DAY_INSTANCE || ' st '|| ' ' ||  ACSD.PERIOD_DAY_INSTANCE_TYPE end ) ||' of every  ' || ( ACSD.PERIOD_INTERVAL ) || ' Month ' || </div>
<div>(case </div>
<div>when ACSD.PERIOD_DAY_INSTANCE_TYPE = '8' and ACSD.PERIOD_DAY_INSTANCE = '-1' then to_char(ACSD.PERIOD_DAYS)<span> </span></div>
<div>end  )|| ' at '</div>
<div>             </div>
<div>             WHEN <span style="color:#ff0000;">ACSD.PERIOD_UNITS ='W'</span> THEN 'Every ' ||  ( ACSD.PERIOD_INTERVAL  ) || ' Week ' || (case when ACSD.PERIOD_DAY_INSTANCE_TYPE = '8' and ACSD.PERIOD_DAY_INSTANCE = '0' Then 'The Last Day of' else 'on ' end ) || </div>
<div>             <span> </span> (case </div>
<div>    <span> </span>when ACSD.PERIOD_DAY_INSTANCE_TYPE = '8' and ACSD.PERIOD_DAY_INSTANCE = '-1' then <span style="color:#ff0000;">to_char(ACSD.PERIOD_DAYS)<span> </span></span>     </div>
<div>end  ) || ' at '</div>
<div>             WHEN ACSD.PERIOD_UNITS ='D' THEN 'Every ' ||  ( ACSD.PERIOD_INTERVAL  ) || ' Day  ' ||(case when ACSD.PERIOD_DAY_INSTANCE_TYPE = '8' and ACSD.PERIOD_DAY_INSTANCE = '0' Then 'The Last Day of' else ' ' end ) ||</div>
<div>            <span> </span> (case </div>
<div>            <span> </span>    when ACSD.PERIOD_DAY_INSTANCE_TYPE = '8' and ACSD.PERIOD_DAY_INSTANCE = '-1' then (case when to_char(ACSD.PERIOD_DAYS)= 0 then '' else <span> </span>to_char(ACSD.PERIOD_DAYS) end )<span> </span></div>
<div>end  ) || ' at '</div>
<div>             WHEN ACSD.PERIOD_UNITS = 'N' THEN NULL</div>
<div>             WHEN SCHEDULE_STATE <> 'A'  THEN NULL</div>
<div>           END )  || (case when ACSD.PERIOD_UNITS = 'N' THEN NULL</div>
<div>                                            else</div>
<div>           TO_CHAR(ACSD.START_TIME,' HH:Mi AM') || ' starting ' || TO_CHAR(ACSD.START_DATE,'MM/DD/YYYY')<span> </span>end ) AS SCHEDULES_RECURRING_JOBS,</div>
<div>           </div>
<div> </div>
<div>        case when (acs.schedule_state <>  'E'  ) then to_char(ACS.NEXT_OCCURRENCE,'MM/DD/YYYY HH:Mi AM ') || ACS.TIME_ZONE_ID </div>
<div>             else null</div>
<div>        end  AS NEXT_RUN_ON,</div>
<div>           <span> </span>   <span> </span></div>
<div>ACJD.JOB_TYPE,</div>
<div>ACJD.REQUESTED_OUTPUT_FILE_PATH as REPORT_NAME,</div>
<div>CASE WHEN ACJD.USE_LATEST_INPUT_VERSION='T' THEN 'Latest Version' </div>
<div>ELSE 'Version 1' END AS EXECUTABLE_VERSION,<span> </span></div>
<div>CASE </div>
<div>WHEN (ACJD.RETRY_POLICY='V' and ACJD.MAX_RETRY_COUNT = 0 ) THEN 'Use Default Volume' </div>
<div>    WHEN (ACJD.RETRY_POLICY='R' and ACJD.MAX_RETRY_COUNT > 0 ) THEN 'Retry '|| ACJD.MAX_RETRY_COUNT || ' times.' || ' Wait ' || to_char(to_date(ACJD.RETRY_INTERVAL_SECS,'sssss'),'hh24:mi') || ' hours and minutes ' </div>
<div>ELSE 'Do Not Retry' </div>
<div>END  AS FAILED_JOB_RETRY_POLICY,<span> </span></div>
<div>ACJD.REQUESTED_OUTPUT_FILE_PATH AS OUTPUT_FILE_NAME,<span> </span></div>
<div>CASE </div>
<div>WHEN ACJD.OUTPUT_FILE_NEW_VERSION='F' THEN 'Replace the latest version' </div>
<div>WHEN (ACJD.OUTPUT_FILE_NEW_VERSION='T' AND ACJD.OUTPUT_FILE_MAX_VERSIONS = 0) THEN 'Create a new version' </div>
<div>WHEN (ACJD.OUTPUT_FILE_NEW_VERSION='T' AND ACJD.OUTPUT_FILE_MAX_VERSIONS >= 1) THEN 'Create a new version;Keep only the latest '|| ACJD.OUTPUT_FILE_MAX_VERSIONS ||' versions ' </div>
<div>         END AS OUTPUT_FILE_REPLACEMENT_POLICY,</div>
<div>       </div>
<div>    <span> </span>--ACJNS.recipient_iid,</div>
<div>     <span> </span>--ACU.USER_IID,</div>
<div>       <span> </span>ACUS.user_login_name AS recipients,</div>
<div>      <span> </span>CASE WHEN ACJD.ON_SUCCESS_SEND_EMAIL = 'T'   THEN 'Send e-mail notification'</div>
<div>       <span> </span>ELSE 'Send e-mail notification;Attach document' END AS IF_JOB_SUCCEDS,       </div>
<div>       <span> </span>CASE WHEN ACJD.ON_SUCCESS_SEND_EMAIL = 'F'  THEN 'Send e-mail notification' END AS IF_JOB_FAILS</div>
<div>       </div>
<div> FROM <span> </span>AC_SCHEDULE ACS</div>
<div> </div>
<div>JOIN <span> </span>AC_VOLUME ACV</div>
<div>ON <span> </span>ACV.VOLUME_ID = ACS.VOLUME_ID</div>
<div> JOIN <span> </span>AC_USER ACU</div>
<div>ON <span> </span>ACS.OWNER_IID= ACU.USER_IID</div>
<div>AND     ACS.VOLUME_ID= ACU.VOLUME_ID</div>
<div> </div>
<div> JOIN    AC_JOB_DEFINITION ACJD</div>
<div>ON      ACJD.VOLUME_ID=ACS.VOLUME_ID</div>
<div>AND     ACJD.JOB_DEFINITION_IID=ACS.TASK_IID</div>
<div> </div>
<div>JOIN    AC_JOB_DEF_NOTICE_SUBSCRIPTION ACJNS</div>
<div>ON     <span> </span>ACS.VOLUME_ID=ACJNS.VOLUME_ID</div>
<div>AND     ACS.TASK_IID = ACJNS.JOB_DEFINITION_IID  </div>
<div>AND  <span> </span>ACJD.JOB_DEFINITION_IID = ACJNS.JOB_DEFINITION_IID  </div>
<div> </div>
<div>JOIN <span> </span>AC_USER ACUS </div>
<div>ON      ACJNS.VOLUME_ID = ACUS.VOLUME_ID</div>
<div>AND     ACUS.USER_IID = ACJNS.recipient_iid</div>
<div> </div>
<div>  </div>
<div> </div>
<div>/* use , working */</div>
<div>/*JOIN  <span> </span>AC_GROUP_MEMBER  a </div>
<div>ON  <span> </span>ACJNS.recipient_iid =  </div>
<div>CASE</div>
<div>               WHEN ACJNS.recipient_type = 'G'           </div>
<div>               </div>
<div>               <span> </span>THEN a.group_iid </div>
<div>              WHEN ACJNS.recipient_type = 'U' </div>
<div>                    THEN acus.user_iid                                     </div>
<div>                else  ACJNS.recipient_iid          </div>
<div>               END </div>
<div>               </div>
<div>AND     ACUS.USER_IID =  </div>
<div>CASE</div>
<div>               WHEN ACJNS.recipient_type = 'G' </div>
<div>                   THEN a.user_iid</div>
<div>               WHEN ACJNS.recipient_type = 'U' </div>
<div>                    THEN ACJNS.recipient_iid                    </div>
<div>                else ACUS.USER_IID</div>
<div>                END */</div>
<div> </div>
<div> </div>
<div>JOIN <span> </span>AC_SCHEDULE_DETAIL ACSD</div>
<div>ON   <span> </span>ACS.SCHEDULE_IID= ACSD.SCHEDULE_IID</div>
<div>AND<span> </span>    ACS.VOLUME_ID=acsd.VOLUME_ID</div>
<div> </div>
<div>WHERE   1=1     <span> </span></div>
<div> </div>
<div>AND     ACS.SCHEDULE_TASK_TYPE = 'J'</div>
<div>AND     ACJNS.recipient_type in ('U','G')</div>
<div>AND     ACUS.IS_ACTIVE = 'T'</div>
<div>) </div>
<div>)</div>
<div>GROUP BY --recipients,</div>
<div>PERIOD_DAYS,</div>
<div>VOLUME_ID,</div>
<div>        TIME_ZONE_ID,</div>
<div>VOLUME_NAME,</div>
<div>        JOB_NAME,</div>
<div>        IS_ACTIVE,</div>
<div>        OWNER,</div>
<div>SCHEDULE_IID,</div>
<div>SCHEDULE_CREATE_DATE,</div>
<div>SCHEDULES_RECURRING_JOBS,</div>
<div>NEXT_RUN_ON,</div>
<div>JOB_TYPE,</div>
<div>REPORT_NAME,</div>
<div>EXECUTABLE_VERSION,</div>
<div>FAILED_JOB_RETRY_POLICY,</div>
<div>OUTPUT_FILE_NAME,<span> </span></div>
<div>OUTPUT_FILE_REPLACEMENT_POLICY,<span> </span></div>
<div>IF_JOB_SUCCEDS,</div>
<div>IF_JOB_FAILS</div>
<div> </div>
<div>ORDER BY UPPER(VOLUME_NAME),JOB_NAME,OWNER</div>

<p>Sorry, I wish I could help you more, but I am tight on time right now.</p>
<p> </p>
<p>Maybe someone else in this forum can help.</p>
<p> </p>
<p>P.</p>

<p>Hi P,</p>
<p> </p>
<p>Thanks for this.</p>
<p>But for the benefit of others too.</p>
<p>The calculated Column WeekSchedule can be used to make another calculated column SCHEDULES_RECURRING_JOBS which i wanted   where we can replace anything that is in the SQL Query like this.</p>
<p>{  row["SCHEDULES_RECURRING_JOBS"].replace('****',row["WeekSchedule"])}</p>
<p> </p>
<p>The Query contained SCHEDULES_RECURRING_JOBS like this and i wanted to replace it with WeekSchedule.</p>
<p> </p>
<div>(case  when ACSD.PERIOD_DAY_INSTANCE_TYPE = '8' and ACSD.PERIOD_DAY_INSTANCE = '-1' then '****'     </div>
<div>end  ) AS SCHEDULES_RECURRING_JOBS</div>
<div> </div>
<div>What i mean is that i want WeekSchedule Monday, Wednesday etc placed in place of **** in the Query.</div>
<div>Thanks</div>
<div>Yoovraj</div>

<blockquote class="ipsBlockquote" data-author="pricher" data-cid="144804" data-time="1470253678">
<div>
<p>Hi,</p>
<p> </p>
<p>As far as I can tell, the information about which day(s) of the week a weekly report is run is in the <span style="font-family:'courier new', courier, monospace;">period_days</span> column. Sunday's value is 2^31,Monday's is 2^32, so on and so forth. Multiple days are added together.</p>
<p> </p>
<p>Hope this helps,</p>
<p> </p>
<p>P.</p>
</div>
</blockquote>
<p>this was for Period_units = 'W' i.e weekly, if Period_units = 'M' i.e Monthly what will be the Period_days values and what will be the corresponding code to calculate the MonthSchedule aka Weekschedule ??</p>

<blockquote class="ipsBlockquote" data-author="yoovrajkhullar" data-cid="145137" data-time="1472576930">
<div>
<p>Hi PRicher,</p>
<p> </p>
<p>Please find time for the code for Monthly too.</p>
<p>where Period_days = 4294967296 ( 2^32)  is the second day, </p>
<p>Period_days = 1073741824 (2^30) is the last day.</p>
<p>Period_days = 1099511627776 (2^40), the 10 th day of the month.</p>
<p> </p>
<p>here is the exponential 2 list</p>
<p><a data-ipb='nomediaparse' href='http://www.tsm-resources.com/alists/pow2.html'>http://www.tsm-resources.com/alists/pow2.html</a></p&gt;
<p> </p>
<p>i will appreciate.</p>
<p>Thanks</p>
<p>Raj</p>
</div>
</blockquote>
<p>Hi Thanks P</p>
<p>But for others too here is the code for calculating monthly Days from the 2 exponential number</p>
<p> </p>
<div>var scheduleIntepreter = row["PERIOD_UNITS"];</div>
<div>var schIntParts = scheduleIntepreter.split(";");</div>
<div> </div>
<div>var input = row["PERIOD_DAYS"];</div>
<div>var parts = input.split(";");</div>
<div> </div>
<div>var weekdays = [0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0];</div>
<div>var weekdaysStr = ["Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15","Day 16","Day 17","Day 18","Day 19","Day 20","Day 21","Day 22","Day 23","Day 24","Day 25","Day 26","Day 27","Day 28","Day 30","The Last Day"];</div>
<div>var schedule = "";</div>
<div> </div>
<div>for(var i=0; i<parts.length; i++) {</div>
<div>    </div>
<div>if(String(schIntParts) == String("M")) {</div>
<div>weekdays = [0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0];</div>
<div> </div>
<div>for (exp = 60; exp >= 31; exp--) {</div>
<div>if (parts - Math.pow(2,exp) >= 0) {</div>
<div>weekdays[exp-31] = 1;</div>
<div>parts = parts - Math.pow(2, exp);</div>
<div>}</div>
<div>}</div>
<div> </div>
<div>for(var z=0; z<=weekdays.length; z++) {</div>
<div>if(weekdays[z] == 1) {</div>
<div>   schedule = schedule + (schedule != "" ? "," : "")  + weekdaysStr[z];</div>
<div>   </div>
<div>}<span> </span></div>
<div>}</div>
<div>    }</div>
<div>}</div>
<div> schedule ;</div>