How to bring approval record fields and RITM variable on list view of a report.

[ArshjotS]

I want to create a report where I want to have the RITM record fields, RITM variables values and the approval record fields on the list view of the the report. 

I know we can create a database view to join the approval table and RITM table. But I am encountering the problem that I am not able to pull in the variables on the list view. The variable object is not available to be selected when using the database view.

[Tanushree Maiti]

Hi @ArshjotS 

It seems whatever database view you have created that is malformed ,thats why you were not getting correct result.

1)Refer : Showing RITM variable, in the list view of a report that is referencing sysapproval_approver table 

Table	Order	Variable prefix	Where clause
sc_item_option_mtom	100	mtom
sc_item_option	200	op	op_sys_id=mtom_sc_item_option
sc_req_item	300	ritm	ritm_sys_id=mtom_request_item
sysapproval_approver	400	app	app_document_id=ritm_sys_id