• FEATURES
  • PRICING
  • MARKETPLACE
  • CASE STUDIES
  • BLOG
    •

    Titli search returns specimen in all sites

    Technical Questions
    #1

    OpenSpecimen v1.0

    When I perform a titli search on a surgical_pathology_number, it returns the specimen_collection_group as if it is in all sites when in reality it is only a member of one site. When doing an Advanced Query it shows up normally in the correct site.

    Screen Shot 2014-09-09 at 9.30.16 AM.png1733×554 130 KB

    Screen Shot 2014-09-09 at 9.51.41 AM.png1276×985 273 KB

    #2

    There were changes in Specimen Collection Group related tables which is not reflected in simple and keyword search metadata. We will fix this in v1.1. As of now you can run below SQL and restart server, it should resolve the issue.

    insert into catissue_related_tables_map values (3,35,‘IDENTIFIER’,‘SITE_ID’)

    Thanks,
    Poornima

    #3

    Thanks Poornima,

    The insert worked.