Well that means no one has logged in since the 1st of May. Try an earlier date maybe like?
https://play.dhis2.org/dev/api/users.json?fields=userCredentials[code, lastLogin]&filter=userCredentials.lastLogin:gt:2016-05-01 On Mon, May 8, 2017 at 2:24 PM, Muhammad Nadeem <nade...@gmail.com> wrote: > Thanks Jason, > > I did process and follow your instruction and in result this is what i > have got it. > > > > {"pager":{"page":1,"pageCount":1,"total":0,"pageSize":50},"users":[]} > > > > please help me > > thanks Nad > > > > On Mon, May 8, 2017 at 12:48 PM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> Hi Muhammad, >> >> We fixed a bug a while back which allowed access to protected tables. >> This query may have worked for you before (but it was intended not to) but >> it should not work now. The "users" tables contains user password hashes, >> and should be considered to be very sensitive. That query could expose user >> password hashes to all users who can access SQL views, which would not be a >> great idea to have available via an SQL query, thus it has been protected >> to be exposed via an SQL query. >> >> There are other ways of achieving what you want to do. For instance. >> >> https://play.dhis2.org/dev/api/users.json?fields=userCredent >> ials[code,lastLogin]&filter=userCredentials.lastLogin:gt:2017-05-01 >> >> would show you all users (with their user name) who have logged in since >> May 1st 2017. >> >> You can also look for inactive users easily through the user admin app >> >> >> >> >> Hope this helps. >> >> Best regards, >> Jason >> >> >> >> >> On Mon, May 8, 2017 at 9:37 AM, Muhammad Nadeem <nade...@gmail.com> >> wrote: >> >>> Hi All, >>> >>> I am having problems in retrieving user log in and log out status. Any >>> one can help me out in how to get details who's login and log out >>> details. Please help me out. >>> >>> I am using SQL view query "SELECT * from USERS;" it shows me some >>> information but not the updated one. >>> >>> Please help me out. >>> >>> Thanks >>> Nad >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : dhis2-users@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-users >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> Jason P. Pickering >> email: jason.p.picker...@gmail.com >> tel:+46764147049 <076-414%2070%2049> >> > > -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
