mit-lcp / querybuilder-issue

Public Issue tracker for the Query Builder repo

Public Querybuilder Issue Tracker

This repository is intended for issue tracking only.

The code underpinning the querybuilder tool is not publicly available at this stage.

querybuilder-issue's Issues

Having trouble with Query Builder, particularly with CHARTEVENTS. Also having trouble building local database.

I'm not terribly experienced with POSTgreSQL or building databases so I'm trying to use the Query Builder to select and export data. I'm running into problems when I try to access CHARTEVENTS. The Builder hangs up and eventually returns a 501 error.
I tried to download the mimic-code-master repository and use it to build a local database. I'm running into issues with POSTgreSQL password. The Makefile appears in OS X as an executable file that can't be opened using ext editors. I added a .txt extension which enabled me to edit the file and change my username from mimic to postgres. I removed the extension and tried to run the make command but got an error.
Overall I'm not doing so well.

Query Builder Nor Working?

Is the Query Builder working, can't seem to get any records returned with even the simplest query of a dictionary table?

no repo for querybuilder-backend, querybuilder-frontend?

Are there supposed to be repositories for the querybuilder?
Both of the pages mentioned in .gitmodules return 404 error messages.

• https://github.com/MIT-LCP/querybuilder-backend
• https://github.com/MIT-LCP/querybuilder-frontend

I cannot have access to my mimic acount

Hi Admin,

For some reason I cannot have access to my mimic account and I get error when I put my username and password.

Would you please help

Thank you

Having trouble executing a query on BigQuery

Hello!

I have been granted access: "Access to the GCP BigQuery was previously awarded to (me) for project: MIMIC-III Clinical Database v1.4".

I can see the mimiciii-clinical dataset in the Resources section on the left on BigQuery.

When I try to run this simple query (i.e., the first query listed in the tutorial):
SELECT *
FROM physionet-data.mimiciii_clinical.patients

I received the message: "Access Denied: Project physionet-data: User does not have bigquery.jobs.create permission in project physionet-data."

Any help or suggestions would be appreciated! Thanks!

Syntax Error using MIMIC database from Physionet

I am trying to follow a workshop exercise from a book which instructs to paste the code below into the query home consol. However, I am getting a syntax error and can't figure out how to resolve it. `

SELECT SETSEED(0.5);
SELECT *, RANDOM() as random_id
FROM (
    SELECT row_id, subject_id, text
    FROM noteevents
    WHERE text LIKE ‘%cirrhosis%’
    ORDER BY row_id, subject_id
    LIMIT 1000
) A;

Below are pictures of the errors I am getting

Export Results

Hi,
I used the QueryBuilder and found my desired data but when I tried exporting them as a CSV file with the "Export Results" button, the results were not the real data and they were just some web scripts in the CSV cells.
You may find a sample of that results in my dropbox.
Can anyone help me to export the results correctly?
Bests,
Peyman

Feature request: Syntax highlighting

Syntax highlighting in the query field would be a lovely addition.
Maybe: http://codemirror.net/

Export as csv

The file is messed up if any of the data has commas. Perhaps a tsv option in addition would be helpful.