Prev
Next
Forums Lawson S3 HR/Payroll/Benefits

List of automatic generated reports on Lawson dashboard

Sort:
You are not authorized to post a reply.
Author
Messages
dijamcoe
New Member
Posts: 3
New Member
10/21/2015 1:13 PM
    Received a request to have a list of automatically generated reports. Would anyone happen to know an easy way to get a list of reports that have been created and added to the dashboard? As of now, I would have to open each report in the Reporting Report Administration and see if the selected report is scheduled. We have hundreds of reports and hope there is an easier way to do this. Thanks!
    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    10/21/2015 2:05 PM

      If you are talking about LBI reports, yes...  I can share a report.

      You'll have to create a view in your database as well....  we're Oracle here, so...

        CREATE OR REPLACE FORCE VIEW "GHSDEV"."GHS_LBI_RS_SCHEDULES" ("REPORT_NAME", "REPORT_DESC", "SCHEDULE_NAME", "REPORT_ID", "CRON_EXP", "OWNER") AS
        select -- selecting fields to create a dynamic listing of scheduled LBI reports
      trim(r.reportname)             report_name,
      trim(r.description)            report_desc,
      trim(t.trigger_name)           schedule_name,
      trim(t.job_name)               report_id,
      trim(c.cron_expression)        cron_exp,
      trim(r.owner)                  owner
        from lawrs.ejs_triggers t
          join lawrs.ers_reports r on
            r.reportid = to_number (t.job_name)
          join lawrs.ejs_cron_triggers c on c.trigger_name = t.trigger_name and c.trigger_group = t.trigger_group
        where t.job_name <= '9999' and r.instanceid = '0';

       You'll likely have to modify slightly for MSSQL.

       -Greg

       

       

      Attachments
      dijamcoe
      New Member
      Posts: 3
      New Member
      10/21/2015 5:43 PM
        Let me see if I can get one of our programmers to take a look at it and get back to this forum. Not familiar with Oracle.
        dijamcoe
        New Member
        Posts: 3
        New Member
        10/21/2015 5:57 PM
          I found the table...Could you help me out with the CRON_EXPRESSION field.

          For example, if it says "0 00 7 ?*MON THU. Could you translate that? And what each column means? I assume one is hours, then minutes, secs
          The.Sam.Groves
          Veteran Member
          Posts: 89
          Veteran Member
          10/21/2015 6:43 PM
            That's a CRONTAB entry. This link should give you a fairly detailed breakdown of the format:

            https://en.wikipedia.org/wiki/Cron
            Greg Moeller
            Veteran Member
            Posts: 1498
            Veteran Member
            10/21/2015 8:07 PM
              Yes, it's a crontab entry.. but it appears to have 6 columns in it, whereas a normal crontab entry only has 5.
              It seems that the 5th column is always a *, so not really sure about that.
              minutes, hours, day of month, month, *, day of week seems to be the pattern.
              For day of month an L for example would indicate the Last day of the month. I've set up some sql expressions in my report to translate * to equal ALL, L to equal LAST, etc. To make it easier to understand.

              Unless your data is different?
              You are not authorized to post a reply.