search

VEuPathDB / EdaSubsettingService

A REST service to provide data and subsetting in the Exploratory Data Analysis Workspace
Apache License 2.0
0 stars 0 forks source link

Backend Subsetting: SCORE SM bug in Country filter (escape single quotes) #20

Closed danicahelb closed 3 years ago

danicahelb commented 3 years ago

Bug hit when subsetting SCORE S. mansoni Cluster Randomized Trial by Country

If I select Kenya or Tanzania, the filtering looks fine

  1. When I select Cote d'Ivoire, ALL data is filtered out (there should be 75 households with data remaining)
  2. When I select all countries, ALL data is filtered out (there should be 449 households with data remaining)

image

image

steve-fischer-200 commented 3 years ago

the subsetting service needs to clean string inputs for sql

steve-fischer-200 commented 3 years ago

this is confirmed fixed on dave's dev site

SheenaTomko commented 3 years ago

This is fixed. Tried Danica's example plus filtering on some other categorical variables in other studies.