Getting duplicate records in the list of a Database view

[Nasreen2]

I have created a database view for joining Requests,RITMs,SCTasks and Approvals. I have used left join for sctask and approver tables while defining in the DB view.

Now the issue is in the list it is showing duplicate records for the sctasks, a single record for each approver as shown below.

How to show only the approved approval record and remove other duplicate records form the DB view list?

[Mark Manders]

To start: filter it on 'approval state = approved', that will get rid of any 'no longer required' approval records. 

[Nasreen2]

Hi Mark,

Thanks for the suggestion! Can this condition be added to the query condition in the View Table so that users can directly use the table in reports without the need to add additional filter conditions. I have tried in some ways to add that condition in where clause but it is not working.

[Nasreen2]

Filtered with Approval state as Approved but still it is showing the duplicates.

[SHANKAR RAMAVAT]

Hi Nasreen,

I'm also facing the same issue with the duplicate records, can you please help me if you have found the solution.

Thank you.