dhis2-users team mailing list archive

[Muhammad Nadeem <nadeem1@xxxxxxxxx>]

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 <
jason.p.pickering@xxxxxxxxx> 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 <nadeem1@xxxxxxxxx>
> wrote:
>
>> I am using 2.22
>>
>> thanks
>> Nad
>>
>> On Thu, May 11, 2017 at 10:03 AM, Jason Pickering <
>> jason.p.pickering@xxxxxxxxx> wrote:
>>
>>> Hi Muhammad,
>>> Which version are you using?
>>>
>>> Regards,
>>> Jason
>>>
>>> On Thu, May 11, 2017, 6:54 AM Muhammad Nadeem <nadeem1@xxxxxxxxx> 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 <
>>>> jason.p.pickering@xxxxxxxxx> 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 <nadeem1@xxxxxxxxx>
>>>>> 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.pickering@xxxxxxxxx> 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 <nadeem1@xxxxxxxxx>
>>>>>>> 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@xxxxxxxxxxxxxxxxxxx
>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Jason P. Pickering
>>>>>>> email: jason.p.pickering@xxxxxxxxx
>>>>>>> tel:+46764147049 <076-414%2070%2049>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Jason P. Pickering
>>>>> email: jason.p.pickering@xxxxxxxxx
>>>>> tel:+46764147049 <076-414%2070%2049>
>>>>>
>>>>
>>>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049
>