Clarity

 View Only
  • 1.  Which table stores Reports details

    Posted Jun 16, 2021 02:03 PM
    I'm looking for table that stores reports( Reports and Jobs) related information, I got the table that stores Jobs info (CMN_SCH_JOB_DEFINITIONS).


  • 2.  RE: Which table stores Reports details

    Posted Jun 17, 2021 04:45 AM
    It is the same table.

    select def.* from CMN_SCH_JOB_DEFINITIONS def
    join cmn_lookups_v clv on clv.id=def.job_type and clv.lookup_type='SCH_JOB_TYPE' and clv.language_code='en'
    where clv.lookup_code='REPORT'