Database view showing difference in record count

[tushar_ghadage]

Hi All, 

I have a database view with below tables 

I have one report on database view and another one on RITM table 

but it shows difference in record count 

for DV it shows 54 and for RITM table it shows 58 

what can be the possible reason ?? 

please help !!

thankss

[Ankur Bawiskar]

@tushar_ghadage 

did you export and compare using excel which extra RITM records are there in database view?

Any RITM has more than 1 approval records?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[tushar_ghadage]

@Ankur Bawiskar Yes after grouping by item there are some catalog items which are not seen in requested item table are been in DV .. as there are same ritm records are been shown multiple times who has multiple approvers 

how to make sure to show the RITM only once even if there are multiple approvers present for that ritm record...

[Ankur Bawiskar]

@tushar_ghadage 

Nice to hear that the comment I shared regarding extra records due to multiple approvers holds true and you confirmed it as well.

it will show those extra records in database view since you are doing join between those 3 tables.

So I believe you can't do much here.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[tushar_ghadage]

Okay but is there any script / or custom functionality which we can use or run to make this happen??

[Ankur Bawiskar]

@tushar_ghadage 

you can't reduce the count in database view.

If my response helped please mark it correct and close the thread so that it benefits future readers.