Our permissible values, particularly ‘Tissue_Site_PID’ are not showing anything past Pyloric lymph node even when trying to type in a value.
We have 1606 permissible values labeled as ‘Tissue_Site_PID’. ‘Pyloric lymph node’ is number 1057 in a sorted sql select.
Additionally, the rest api returns ‘The requested resource is not available.’ when using the following to get a list of values:
or
Hi @John_Reber,
The tissue site drop down only shows the leaf nodes. It might be possible that the value Pyloric lymph node is not a leaf node.
Regarding the REST API for the tissue site:
http://:/openspecimen/rest/ng/permissible-values?attribute=Tissue_Site_PID&includeOnlyLeafValue=true
You can check this with the above REST API or with the below SQL:
The SQL to get the leaf node values :
select
identifier, value
from
catissue_permissible_value
where
public_id = 'Tissue_Site_PID' and identifier not in
(
select
parent_identifier
from
catissue_permissible_value
where
public_id = 'Tissue_Site_PID' and parent_identifier is not null
)
~Nitesh
That is not the issue.
Your sql query pulled up the list I was expecting. The problem is nothing is showing up in the drop down list that is alphabetically past ‘Pyloric lymph node’, though they appear in the sql select you provided. They do not even show if you type in the value.
John
When I run the REST call it only returns up to and including ‘Pyloric lymph node’, nothing past that. The REST API is only returning 1000 rows.
Hi @John_Reber,
This is a bug in the current implementation that it only displays first 1000 values for Anatomical Site. The values beyond this count are not displayed in the dropdown for selection.
We will fix this issue in the next release. Given below is the ticket for tracking:
https://openspecimen.atlassian.net/browse/OPSMN-2649.
Thanks for the feedback.
~Nitesh