CL 6.1.1 SMATDB

[Femina Jaffer]

Can we use sql queries for retrieving data from smat files in the new version of CL within SmatDB?  I thought I had read somewhere that this can be done?  However, I am not seeing this.

Thanks,

Femina

Topic

[Charlie Bursell]

Sure it is just a sqlite database.  

You may have to issue a command to decrypt if encrypted.  Take a look at the smatdb script i posted a while back

[James Cobane]

Just to clarify – you can’t do it via the SMAT DB GUI, but you can do it via code as Charlie did in his script.

Jim Cobane

Henry Ford Health

[Femina Jaffer]

Thank you Gentleman.  I will take a look at Charlie’s script today and give it a try.

Thanks again.

Femina

[Femina Jaffer]

James,

Thanks for the clarification also.  I was hoping to see a GUI for the SQL commands.  Anyway, will take a look at Charlie’s script and hopefully be able to come close to something.

Thanks again gentleman,

Femina

[Charlie Bursell]

There *IS* a GUI for this. it is called the SMATDB GUI

It will not accept the native SQL commands but will build the proper SQL commands for you.

You must be aware, especially with HL7, that most of the work is done via the regular expression.  The message itself is stored as a blob.

If you want a historical DB that can be searched via pure SQL I would recommend you define the DB table you like in a separate DB then populate that table with data from the SMAT DB.

There is no way to define a SMAT DB table that could store messages other than as a blob that would satisfy all possible message formats.  But you have the tools to do it yourself.

That is why you are paid the big bucks   😛

[Author]

Replies