Hi Jason, Many thanks for help. API you provided does worked but now the only problem we are facing its not work for specific dates like 2017-02-28, 2017-03-30, 2017-04-30 and 2017-05-30.
Rest all dates its has worked liked all previous dates. thanks Nadeem On Thu, May 11, 2017 at 4:55 PM, Jason Pickering < [email protected]> wrote: > Hi Muhammad, > Try this on 2.22 > > api/users?fields=userCredentials[name,lastLogin]&filter= > userCredentials.lastLogin:gt:2015-03-30 > > > Adjust the date to which ever date you want. > > Regards,s > Jason > > > On Thu, May 11, 2017 at 7:53 AM, Muhammad Nadeem <[email protected]> > wrote: > >> I am using 2.22 >> >> thanks >> Nad >> >> On Thu, May 11, 2017 at 10:03 AM, Jason Pickering < >> [email protected]> wrote: >> >>> Hi Muhammad, >>> Which version are you using? >>> >>> Regards, >>> Jason >>> >>> On Thu, May 11, 2017, 6:54 AM Muhammad Nadeem <[email protected]> wrote: >>> >>>> Hi >>>> >>>> I have tried earlier date and in my case its shows like as follows: >>>> >>>> {"pager":{"page":1,"pageCount":2,"total":81,"pageSize":50,"nextPage":"http://greenstar/api/users?page=2"},"users":[{"userCredentials":{"lastLogin":"2017-02-26T14:40:53.728+0000"}},{"userCredentials":{"lastLogin":"2017-02-26T14:38:37.332+0000"}} >>>> >>>> not showing who login to system. >>>> >>>> >>>> please help >>>> >>>> >>>> >>>> On Mon, May 8, 2017 at 5:37 PM, Jason Pickering < >>>> [email protected]> wrote: >>>> >>>>> 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 <[email protected]> >>>>> 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 < >>>>>> [email protected]> 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 <[email protected]> >>>>>>> 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 : [email protected] >>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Jason P. Pickering >>>>>>> email: [email protected] >>>>>>> tel:+46764147049 <076-414%2070%2049> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Jason P. Pickering >>>>> email: [email protected] >>>>> tel:+46764147049 <076-414%2070%2049> >>>>> >>>> >>>> >> > > > -- > Jason P. Pickering > email: [email protected] > tel:+46764147049 >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
