List of automatic generated reports on Lawson dashboard

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

 

 

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.

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

That's a CRONTAB entry. This link should give you a fairly detailed breakdown of the format:

https://en.wikipedia.org/wiki/Cron

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?