program_title column in PRD report is empty.

[former_member112000]

Hello,

Thanks in advance.
I am not sure if this is the right place to ask the question, still:

The issue I am facing is "program_title" column which is pulling data from "pa_program" table, remains completely empty for every user in the report.

There are no errors in the query (SQL), else the report would not have executed.
Are there any alternatives to "pa_program" table which can provide the same data as "program_title"?

[jorgecampos · Accepted solution]

Anuj,

You can get the program tile from the item table by joining PA_PROGRAM to PA_CPNT. For example:

select
  P.PROGRAM_ID,
  I.CPNT_TITLE as PROGRAM_TITLE
from
  PA_PROGRAM P
    inner join PA_CPNT I
      on
        P.CPNT_TYP_ID = I.CPNT_TYP_ID and
        P.CPNT_ID = I.CPNT_ID and
        P.REV_DTE = I.REV_DTE