How to Caluclate idle time

deepthi.v

Hi all,

I want to calculate the idle time for the session in Nav 3.7 .In the table session there is field called idle time from 4.0 onwards.

But in Nav 3.7 we are not having the field Idle time.Is there any other possibility to caluclate the idle time of the session in NAv 3.7


Please Suggest Me........





Deepu...

kine

SQL or Native?

If SQL, you can create same view as in NAV 4.00 but with different name and connect it into NAV as LinkedObject.
If Native, there is no way...

deepthi.v

Hi Kine,


i can't get u how we can get it in nav 3.7 in sql Database ,can u explain it how we can do in sql...



Deepu..

kine

you can create same view as in NAV 4.00 but with different name and connect it into NAV as LinkedObject.

1) Learn what is "view" on MS SQL, how to create it, try to copy the view "Session" from NAV 4.00 into 3.70 DB under new name
2) Learn how to use LinkedObject property on table (search this forum).

deepthi.v

Thanks kine
I able to solve it.



Deepu...

kine

You are welcome! 8)