Report not displaying variables in database view.

[Balaram7]

Hi all,

I am trying to create a report on RITM and Attachment table by creating a database view.

Iam able to view the attachments and RITM number, but unable to select the variables.

Do i need add another table to database view to get variables information.

or is there any other way to get the following fields in the report.

(Attachment link, Ritm #, variables1, variable2, variable 3.)

please help me if there is any possible ways to get this requirement done.

[Balaram7]

Hi @Ankur Bawiskar , 

Thanks for your response, i updated the order for tables, still getting the same. Am i missing anything here, please guide me.

Best Regards,

P.Balaram.

[Ankur Bawiskar]

@Balaram7 

share your latest database view screeshots

[Aditya_hublikar]

Hello @Balaram7 ,

First change order as suggested by @Ankur Bawiskar  and then change clause like attach_table_sys_id=ritm_sys_id .

Please refer below photo which is for sc_task and ritm database view (just for refference of where clause )

[Tanushree Maiti]

Hi @Balaram7 

Can you try this:

Table                                             Order            Variable prefix                                     Where clause

sys_attachment                         100                   attachment             

sc_req_item                                  200                  item                                               attachment.table_sys_id=item.sys_id