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

[tkalpa005]

Yes , I am using correct duration value,If you see below screen shot  , you can see it's showing  total duration, minimum duration, maximum duration 

[Manish Vinayak1]

That is strange, it is giving the average values and the sum. Does it appear in the form layout of the database view, if you add the duration field to the layout?

[tkalpa005]

I think there is not any form layout  for any DB view,

[Manish Vinayak1]

You can hover over to the "i" reference icon in the list and click on open record to open it.

Then you can customize the form layout, it will show you all read only fields from the view record. Try to bring duration to see if it has got any value there.

Here is an example where I have set the form layout for a view made from audit table, incident table and choice table.

[tkalpa005 · Accepted solution]

Thanks,

 I got the issue, I  was using  prefix in CAPS letters, when I changed those to small, it started working, So issue was in table prefix in view query. EG: MD to md, MI to mi, APP to app and CHG to chg.