OHDSI Home | Forums | Wiki | Github

Atlas bug report

Developers
#1

I was trying to find concept ‘Injection infliximab, 10 mg’ using concept_code J1745 and failed.
But searching using concept_id 2718445 gives the result ‘Injection infliximab, 10 mg’ with required concept_code

#2

Yes, thats weird, i see it on the ohdsi.org instance too, though searching
for 1745 finds it also.

#3

Yes seems to be a problem searching for concept codes. At the F2F, we saw an issue where someone tried to search for an ATC3 class code, and it wasn’t found, but searching for the entire name worked. So this is definitely some kind of bug.

#4

Here is the SQL query executed on OHDSI cloud:

 select CONCEPT_ID, CONCEPT_NAME, COALESCE(STANDARD_CONCEPT,'N') STANDARD_CONCEPT, COALESCE(INVALID_REASON,'V') INVALID_REASON, CONCEPT_CODE, CONCEPT_CLASS_ID, DOMAIN_ID, VOCABULARY_ID
        from unrestricted.CONCEPT
        where (LOWER(CONCEPT_NAME) LIKE '%j174%' or 
    CONCEPT_CODE LIKE '%j174%' or CAST(CONCEPT_ID as VARCHAR(255)) = 'j174')
            order by CONCEPT_NAME ASC

Probably the search string is being lowercased before this SQL call and so the CONCEPT_CODE LIKE also needs a LOWER() applied in this SQL.

#5

Search is supposed to be case-insensitive

#6

@Eldar Yes, it’s an Atlas bug as indicated in the SQL query that I posted above.

Feel free to create a github issue on the WebAPI repo here:

#7

@lee_evans Thanks!

P.S: Get ready for huge wave of issues =)

#8

Make sure all reports have the necessary sections: Actual behavior, Expected Behavior and steps to reproduce.

t