topic Re: Mysteriously disappearing data in App Development

Mysteriously disappearing data

Lauri — Thu, 10 Aug 2017 21:12:32 GMT

My app in Sense Enterprise 3.2 starts out well, after the data load, and shows 37,143 patients in a KPI. I'll work in the app and edit it, and all is well. I'll come back to it after an absence (and I likely have to log back into Sense), and the patient count will be down to 29,851. No filters are applied. I can work in it and everything appears to work normally, but the patient count stays at 29,851.

To add to the mystery, when I look at the data model viewer after this has happened, it shows the field in question as having a "Total distinct values" count of 37,143! So the underlying dataset appears to be intact. But the app's web page does not reflect it.

I'll add that the app loads data into 21 tables. The patient ID is a key field.

This problem has occurred a number of times now this week, always with the same change to 29,851.

Thanks for any insights.

Re: Mysteriously disappearing data

annapochyla — Fri, 11 Aug 2017 06:43:37 GMT

Hi,

do you use section access in your app?

Anna

Re: Mysteriously disappearing data

Lauri — Mon, 14 Aug 2017 19:03:18 GMT

Hi,

Yes, section access is based on an organizational ID (ORGID).

Thanks,

Lauri

Re: Mysteriously disappearing data

annapochyla — Mon, 14 Aug 2017 20:31:06 GMT

Did you checked, if it is not the section access fault? Maybe it limit's the data?

Re: Mysteriously disappearing data

Lauri — Mon, 14 Aug 2017 21:43:07 GMT

Hi Anna,

I've been working as an admin, with access to all ORGID values. I also tried reloading data without any section access. The problem doesn't seem related to section access.

Thanks,
Lauri