Date filter not working for lastLoginDate key however it is working for other date keys like createDate or lastModified
rest/align/api/2/users?filter=lastLoginDate gt 2020-05-11T06:48:00Z
I want to disable the Last 90 days Inactive users so I need the filter in lastLoginDate key. Kindly help me in advance.
Hi there -- we wanted to let you know that a new enhancement request has been created today for having this property searchable/filterable.
Should you're interested, feel free to join Ideation portal (open for current Jira Align customers & prospects) and upvote for it.
Hi @Mohamed Musheer ,
The lastLoginDate property is a read-only object that is not meant to be filterable via API calls. We have a defect report on this case, as this property should be marked as NonSearchableProperty: https://jira.atlassian.com/browse/JIRAALIGN-3085
Please subscribe to this bug should you wanna get notified when it is resolved.
In case you want this property to be searchable & filterable, I'd recommend you to log a new Idea in the public Ideation portal. Here's how.
Hope it helps!
Hi @Rodrigo Cortez ,
If you can see the other date fields like createDate and lastModified are also a read-only object but can be filtered via API.
If lastLoginDate is not ment for filterable please provide me a solution for my problem
"I want to disable inactive users for last 90 days how do I get the inactive users via API ?"
In addition to the manual workaround previously shared, if you're an Enterprise Insights customer, you can use the below query to return the userID and other relevant information for all active users that haven't logged into Jira Align in the past 90 days.
SELECT u.[Username] as 'userID', u.[First Name] as 'First Name', u.[Last Name] as 'Last Name', u.[email] as 'Email', uf.[login timestamp] as 'Last Login Time' FROM current_dw.[user login fact] uf INNER JOIN ( SELECT [FK User ID], max([login timestamp]) as MaxDate FROM current_dw.[user login fact] GROUP BY [FK User ID] ) time_stamp ON uf.[FK User ID] = time_stamp.[FK User ID] and uf.[login timestamp] = time_stamp.MaxDate INNER JOIN current_dw.[user] u ON uf.[fk user id] = u.[user id] AND uf.[login timestamp] <= DATEADD(day, -90, GETDATE()) AND u.[User Active Flag] = 'YES' ORDER BY uf.[login timestamp] DESC