How to Caluclate idle time

deepthi.vdeepthi.v Member Posts: 62
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

  • kinekine Member Posts: 12,562
    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...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • deepthi.vdeepthi.v Member Posts: 62
    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..
  • kinekine Member Posts: 12,562
    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).
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • deepthi.vdeepthi.v Member Posts: 62
    Thanks kine
    I able to solve it.



    Deepu...
  • kinekine Member Posts: 12,562
    You are welcome! 8)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.