Database View

[Dileep2]

Hi All,

I have created a Database view to create a report (Change requests from Incident) with where clause as below and it's working as expected. 

Incident table - inc_rfc=chg_sys_id && inc_category='HANA'&&inc_active=1

Approval (sysapproval_approver) table - chg_sys_id=apr_sysapproval && chg_active=1 

If I check the list view of the Change requests from Incident table I can see the Duplicate Change Request numbers with duplicate approvers. Please refer the screenshot.

I need to create a sepearate view different from attached screenshot and in the new view Approvers field in the list view is not required and we have to show Change request numbers without duplicate numbers. Please suggest.

Thank you

[AshishKM]

Hi @Dileep2 , 

It's not completely duplicate because, approval record has different "Assigned to" user.

CHG has multiple approvers, and sysapproval table has all those records. 

If you have any parameter to decide which TYPE of approval record you need in view, then apply that condition in view configuration.

-Thanks,

AshishKM

[Dileep2]

Hi Ashish,

Thanks for your reply...

That's correct.. I mean to say it's not duplicate but it has multiple approvers. 

Can we have any option for not showing the multiple approvers for change request in the second new view.

Or only option which we have is view configuration.. 

Please suggest

Thank you 

[AshishKM]

just as question, as there are multiple approver per CHG.

What's the selection criteria to choose one approver record over the other for same CHG. If we can find the answer then we have some solution/work around.