API - Filter using lastLoginDate not working

Question

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.

Rodrigo Cortez_jg22qq · Answer

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

Rodrigo Cortez_jg22qq · Answer

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.

* iZone 1852 - API - Please allow to filter using lastLoginDate

Rodrigo Cortez_jg22qq · Answer

As a workaround, you can export all of your active users, then manually filter the results.