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

[Bhuvan]

@tushar_ghadage 

It is possible not all RITMs need approval and one RITM could have one or more approvals, hence numbers need not be same for Data Visualization or Report from Database Views and Table sources. Use the same filter conditions as DB Views in RITM table and count should be same.

If you still see differences, check if there are any table rotation or archiving in place by comparing the data from table and database views.

If this helped to answer your query, please mark it helpful & accept the solution. 

Thanks,

Bhuvan

[Bhuvan]

@tushar_ghadage 

Did you get a chance to review this as I believe the information provided should answer your question.

If my response helped to guide you or answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[tushar_ghadage]

@Bhuvan  

Thanks the information yes I have gone through your process and count is different due the multiple approval for the same RITM record. 

You are right ... 

but also, there are item with just single approval those are also not been shown as well ...

[Bhuvan]

@tushar_ghadage 

Did you get a chance to review this as I believe the information provided should answer your question.

As per community guidelines, you can accept more than one answer as accepted solution. If my response helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan