"No data to show"/zero rows in dataset when I navigate to its grid from the Dataset web part, but I can select rows from the same dataset

General Server Forum (Inactive)
"No data to show"/zero rows in dataset when I navigate to its grid from the Dataset web part, but I can select rows from the same dataset jmb  2019-03-05 14:08
Status: Active
 

In my study I have multiple datasets that are reloaded regularly from a study archive. After one such reload last week, the datasets in my study appear to be empty when I navigate to their grids from the Datasets webpart. E.g. I have a dataset called Enrollment. If I create a Datasets web part, and then select the Enrollment dataset, I see an empty grid with no data to show. However I know the data successfully loaded, because if I query 'select * from Enrollment' I see all the expected rows. What might be causing this? As far as I can see, the URL parameter passed to the query when accessing Enrollment from the Datasets webpart is correct (URL is ../labkey/NDDdb/study-dataset.view?datasetId=5001, and 5001 is the correct datasetId for the Enrollment dataset).

 
 
Jon (LabKey DevOps) responded:  2019-03-19 16:58
Status: Closed
Hi Judson,

It sounds like you might be applying a filter to your dataset's grid views that is doing a filter against a value that is not valid.

If you select the Grid View option (or the Grid button on newer instances of LabKey), you should be able to tell if you're applying filters on the view for those datasets that are appearing with zero rows. If there is a filter, you can either click the Revert button to undo the customization on that grid completely, delete the grid view entirely by clicking Delete, or just remove the filter from the Filter tab and save your changes. This should then restore the grid view to where you can see those rows.

For more information on Grid View customization, please check out the following doc:

https://www.labkey.org/Documentation/wiki-page.view?name=customViews

Regards,

Jon
 
jmb responded:  2019-03-20 12:18
Status: Active
Hi Jon,

Thanks for weighing in. From what I can see, it doesn't look like there are any filters applied on these empty grids (I'm getting the same behavior on all the datasets in my study, the example I gave above is just one of many). As an example, I've attached two screen shots showing the filter states on the Phenotype dataset's data grid (which I know actually contains 1750 rows, as verified by 'Select * from Phenotype').

I should also note that in the screen cap where 'Filter' menu is expanded on the left, any and all combinations of cohort checkboxes I select/deselect still shows an empty data grid.
 
Jon (LabKey DevOps) responded:  2019-04-11 12:35
Status: Closed
Hi Judson,

There has to be some kind of filtering being done here.

You said you were able to run a query, so it's clear you're using the Schema Browser then to do a "SELECT * FROM PHENOTYPE".

In the Schema Browser, can you see the Phenotype dataset under the study schema? If so, if you click on it and then click the "View Data" link, does the grid show you any rows there?

If you don't see rows listed, then check the grid view and see whether a filter is being applied within the view that is being presented.

Regards,

Jon