Duration field is not showing any value in database view for approval table

[tkalpa005]

Hi All,

 We have one requirement to calculate duration of approval or rejection of a change record, We have enable metrics business rule for this and it's calculating duration correctly .But the ID field is not a reference field in metric instance table and which does not allow us to add any related field to report from change request.

For that we have written a Data base view in   metric instance, approval and change table, it's returning correct record but unfortunately duration field is showing empty(Value is there in instance and I have chosen correct field from  metric instance table), Any help for this ?

Thanks

kalpa

[Manish Vinayak1]

Hi Kalpa,

Would you be able to share screenshot of your database view conditions and the value which is present in the duration metric record?

That would help to understand what could be wrong.

Thanks,

Manish

[tkalpa005]

Adding screen shot of View

Adding  View result:

Adding Metric instance result

[tkalpa005]

Any help ?

[Manish Vinayak1]

Hi Kalpa,

Did you check if you are using the correct duration field on the list layout (I mean which is fetched from the metric instance table)?

You will find Duration record on the change request table as well. That might contain blank values.

Thanks,

Manish