Hi,
I am trying to figure out 2 problems in relation to Business Objects and free-hand SQL and would really appreciate any feedback anyone has
Firstly I am trying to include in a report for Broadcast Agent, the name of the person who submitted the report to Broadcast Agent. Under DS_PENDING_JOB there is a table called USER_SUBMIT_ID (numeric) and apparently I need to reference a value under the table OBJ_M_ACTOR in order to have the users name displayed. I know how to join tables but am unsure of how to go about this problem?
I was thinking I would need to convert the numeric to a char seeing as tho I want a name displayed.
e.g.
select convert(char(20),user_submit_id)
from ds_pending_job
where ds_pending_job.docserver_id = obj_m_actor.m_actor_n_id
Also, in order to get the 'scheduled date' in a Broadcast Agent report I am aware that I need to combine BEGIN_DATE, BEGIN_TIME and FREQUENCY but I am unsure of the free-hand SQL I should be using. Thx in advance....
I am trying to figure out 2 problems in relation to Business Objects and free-hand SQL and would really appreciate any feedback anyone has
Firstly I am trying to include in a report for Broadcast Agent, the name of the person who submitted the report to Broadcast Agent. Under DS_PENDING_JOB there is a table called USER_SUBMIT_ID (numeric) and apparently I need to reference a value under the table OBJ_M_ACTOR in order to have the users name displayed. I know how to join tables but am unsure of how to go about this problem?
I was thinking I would need to convert the numeric to a char seeing as tho I want a name displayed.
e.g.
select convert(char(20),user_submit_id)
from ds_pending_job
where ds_pending_job.docserver_id = obj_m_actor.m_actor_n_id
Also, in order to get the 'scheduled date' in a Broadcast Agent report I am aware that I need to combine BEGIN_DATE, BEGIN_TIME and FREQUENCY but I am unsure of the free-hand SQL I should be using. Thx in advance....