Display version businesspace

jannes

Is it possible to display the version of the businessspace ?
I expected it should be possible with something like :
DISPLAY MESSAGE Version() .. ?

= Jannes

Jaymer

here's 1 way

SELECT [DNAME]
      ,[VERSIONSTR]
      ,[EVENTTYPE]
      ,[EVENTTIME]
      ,[DESCR]
  FROM [AIM].[dbo].[DVHISTORIES] WHERE DNAME='OEM' and EVENTTYPE=4 order by EVENTTIME

This is a table in your Aware installation database - its that 1st DB you created when you installed aware.
You could write a Stored Procedure to go retrieve this (maybe every night, or based on a trigger on this table) and store it in one of your tables (like SystemSettings), then display that in a banner. Of course that # doesn't mean anything to your users, but if you needed to know this for some reason, this IS the exact # that displays in the Config Tool for that BSV.

The EventType field is for "Published". So you'd want to sort them and get the most recent 1 for the result of the SP.

hpl123

PS: Take a look at this 🙂:
BSV_VERSION>

aware_support

Yes, you can use BSV_VERSION()

It's not documented, unfortunately, but we will fix that