SERCO - CMIS - Extracting events from SQL Database
I'm currently trying to take out data from the CMIS database as I want to be able to collate a gridview with all events.
I've looked into the following tables:
The above table stores the particular event with 'AppEventId'.
The 'AppEventId' is then stored in CMIS.dbo.APPAPPFIELDS - this table holds one line per value. So for example a single event in APPAPPFIELDS would look like the following:
|2012/2013 ||1000 ||361616 ||16 ||1 ||UNI |
|2012/2013 ||1000 ||361616 ||16 ||2 ||Isolation |
|2012/2013 ||1000 ||361616 ||16 ||3 ||DN |
Has anyone had any luck retrieving the above information CMIS in a easy to read format such as:
|2012/2013 ||1000 ||361616 ||16 ||1 ||UNI ||Isolation ||DN |
Any help greatly appreciated.