Stream: cql
Topic: Running AUDIT CQL in Sample IG
Christa Wan (May 20 2021 at 13:50):
Hi @JP @David Winters ,
I am trying to run the AUDIT (https://cds.ahrq.gov/cdsconnect/artifact/alcohol-screening-using-usaudit-alcohol-use-disorders-identification-test) CQL in the sample-content-ig to build a bundle that can be uploaded to the CQF-Ruler. However, I am running into issues with the ValueSet-db.json where it cannot find resourceType element. Is there a sample of ValueSet-db.json that I could refer to? The FHIRHelper file that we were able to find in the repository (https://github.com/asbi-cds-tools/asbi-screening-app) was only available in JSON. Is there a method to convert this to a CQL version (or if there was a CQL version available)?
@Alex Goel
Thank you,
Christa
David Winters (May 20 2021 at 14:28):
Hi @Christa Wan. On github we checked in an empty value set json file because there are codes in the value sets which require a UMLS license. You can find out more at the Value Set Authority Center but you'd need to sign up for a UMLS account, generate an API key, and then run a script to populate the value set json file. More detailed instructions on this can be found here.
David Winters (May 20 2021 at 14:29):
You can find the original FHIRHelper CQL here.
David Winters (May 20 2021 at 14:31):
Caveat emptor: I've never tried running the AUDIT CQL with CQF-Ruler. Would love to hear how that goes.
David Winters (May 20 2021 at 14:47):
I use the javascript cql-execution library to execute the CQL in the AUDIT SMART app. You can see how the JSON is used here, which could be different than what CQF Ruler is expecting.
JP (May 20 2021 at 17:44):
Hi Christa!
The cqf-ruler doesn't use the ValueSet-db.json file so you'll need to download the ValueSets and convert them manually. As David mentioned you can get the ValueSets from VSAC, which will export them in excel format. Each ValueSet you export can then be converted to fhir using the cqf-tooling operation that's here:
https://github.com/cqframework/cqf-tooling/blob/master/src/main/java/org/opencds/cqf/tooling/Main.java#L32
That will output the ValueSets in the FHIR JSON format that the cqf-ruler can use. The ValueSets needed are the ones listed in the .cql file. Let me know if you have further questions. :smile:
Last updated: Apr 12 2022 at 19:14 UTC