on 10-30-2019 3:29 PM
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"?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
4 | |
3 | |
3 | |
2 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.