Navision Timestamp for caching

mrettler Member Posts: 17

2017-04-10 in NAV Tips & Tricks

Hi there,
does Navision provide a Timestamp or something like that to see when the last change was done on a dataset?

0

Best Answer

• 

  rmv_RU Member Posts: 119

  2017-04-11 Answer ✓

  Not using Nav code. But you can use SQL to compare timestamp of investigating record and Change Log.

  declare @t bigint
  select @t=cast(timestamp) as bigint from table
  select top 100 * from [company$Change Log Entry] where cast(timestamp as bigint)>=@t
  order by cast(timestamp as bigint)
  

  Sometimes it can be useful.

  Looking for part-time work.
  Nav, T-SQL.

  5

Answers

• 

  rmv_RU Member Posts: 119

  2017-04-11 Answer ✓

  Not using Nav code. But you can use SQL to compare timestamp of investigating record and Change Log.

  declare @t bigint
  select @t=cast(timestamp) as bigint from table
  select top 100 * from [company$Change Log Entry] where cast(timestamp as bigint)>=@t
  order by cast(timestamp as bigint)
  

  Sometimes it can be useful.

  Looking for part-time work.
  Nav, T-SQL.

  5