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...
Comments
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...
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
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..
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).
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
I able to solve it.
Deepu...
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.