Share 
Follow 
AboutDownloadsDocumentsForumsSource CodeIssuesNews
Date:
2019-05-16 21:05
Priority:
4
State:
Closed
Submitted by:
Joy Ku (joyku)
Assigned to:
Henry Kwong (hykwong2012)
Target Release:
4.0.1
Status:
Testing complete
Summary:
[data share] Queries do not work correctly with metadata at different levels

Detailed description
Issues with querying using metadata from two different levels (e.g., age = 19 AND Loaded -> Free -> Trial05 -> Overground walking speed >= 1.07. I would expect one subject’s data to be returned (Subject9), but instead no subjects match. The query seems to work fine at the subject level.

(TOD: Confirmed. It would only return something at the different levels if changed to "OR". I had to add "age" to the metadata at the same level for the "AND" to work.)

Add A Comment: Notepad

Message  ↓
Date: 2020-02-26 21:02
Sender: Joy Ku

Confirmed that query returns right number of subjects now

Date: 2019-07-30 23:30
Sender: Henry Kwong

- Added support for querying using metadata from different levels by properly collecting the attributes/values from ancestors.

Field Old Value Date By
status_idOpen2020-03-06 23:04hykwong2012
close_dateNone2020-03-06 23:04hykwong2012
Target Release4.0.02020-03-06 23:04hykwong2012
StatusReady for testing2020-02-26 21:02joyku
Target ReleaseNone2019-12-07 00:06hykwong2012
StatusAccepted2019-07-30 23:30hykwong2012
assigned_tonone2019-07-11 00:31hykwong2012
StatusNone2019-07-11 00:31hykwong2012
Feedback