Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-4931

Display user Attributes with a timestamp rather than epoch time in the UI

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      Problem Definition

      When viewing user Attributes in the UI they are stored in epoch integers. While these can be converted manually with a calculator, it becomes inconvenient to convert the values if they need to be viewed regularly or frequently.

      • lastActive
      • lastAuthenticated
      • passwordLastChanged

      Suggested Solution

      Display the values in real GMT or local dates next to the fields

      Workaround

      Following our List the Last Login Date for all Users in Crowd article, you can adjust the queries to output of each of these attributes for all users in Crowd:

      • lastActive
        select cwd_user.user_name, to_timestamp(CAST(cwd_user_attribute.attribute_value as double precision)/1000) from cwd_user_attribute, cwd_user where cwd_user_attribute.user_id = cwd_user.id AND cwd_user_attribute.attribute_name = 'lastActive';
        
      • lastAuthenticated
        select cwd_user.user_name, to_timestamp(CAST(cwd_user_attribute.attribute_value as double precision)/1000) from cwd_user_attribute, cwd_user where cwd_user_attribute.user_id = cwd_user.id AND cwd_user_attribute.attribute_name = 'lastAuthenticated';
        
      • passwordLastChanged
        select cwd_user.user_name, to_timestamp(CAST(cwd_user_attribute.attribute_value as double precision)/1000) from cwd_user_attribute, cwd_user where cwd_user_attribute.user_id = cwd_user.id AND cwd_user_attribute.attribute_name = 'passwordLastChanged';
        

            [CWD-4931] Display user Attributes with a timestamp rather than epoch time in the UI

            Addressed with Crowd 6.2.0.

            Marek Weihs added a comment - Addressed with Crowd 6.2.0.

            Hi Patrick,

            per this page: https://www.atlassian.com/software/crowd/pricing it should be and we do have Data Center license for our Crowd (that's why UPM is yelling at me with this incompatibility).

            Atlassian, could you please check if Data Center of Crowd is available on Marketplace? Thanks.

            Richard

            Richard Bukovansky added a comment - Hi Patrick, per this page: https://www.atlassian.com/software/crowd/pricing  it should be and we do have Data Center license for our Crowd (that's why UPM is yelling at me with this incompatibility). Atlassian, could you please check if Data Center of Crowd is available on Marketplace? Thanks. Richard

            Patrick Hobusch added a comment - - edited

            Hi Richard,

            I did, but it looks like Crowd itself is not considered as Data Center compatible in the Atlassian Marketplace if I get that message right... At least I cannot upload the new plugin version.

            The latest build can be found here: https://repo1.maven.org/maven2/de/aservo/timestamp-to-date-crowd-plugin/0.0.4/

            Many regards
            Patrick

            Edit: Image upload from the Marketplace upload also not working...

            Patrick Hobusch added a comment - - edited Hi Richard, I did, but it looks like Crowd itself is not considered as Data Center compatible in the Atlassian Marketplace if I get that message right... At least I cannot upload the new plugin version. The latest build can be found here:  https://repo1.maven.org/maven2/de/aservo/timestamp-to-date-crowd-plugin/0.0.4/ Many regards Patrick Edit: Image upload from the Marketplace upload also not working...

            Hi Richard,

            again, good point, I will do that in the upcoming days.

            Many regards
            Patrick

            Patrick Hobusch added a comment - Hi Richard, again, good point, I will do that in the upcoming days. Many regards Patrick

            Hi Patrick,

            review posted...

            But one more thing... Can you please make it Data Center enabled? Would be very much appreciated.

            Thank you!

            Regards,
            Richard Bukovansky
            CommmerzBank AG

            Richard Bukovansky added a comment - Hi Patrick, review posted... But one more thing... Can you please make it Data Center enabled? Would be very much appreciated. Thank you! Regards, Richard Bukovansky CommmerzBank AG

            Patrick Hobusch added a comment - - edited

            Hi Richard,

            thanks for your feedback. Good point that it should also be possible to copy that value and glad that you managed to do that also with the tooltip (I didn't try it yet). The Atlassian UI elements are sometimes a bit tricky to use, so I prefer not to change it if possible.

            Since yesterday you can also install the plugin directly from the Crowd Marketplace that is available in the latest Crowd versions. If you like our tiny plugin, I would really appreciate a short review in the Marketplace. https://marketplace.atlassian.com/apps/1222750/timestamp-to-date-for-crowd

            Thanks a lot and many regards
            Patrick Hobusch
            ASERVO Software GmbH

            Patrick Hobusch added a comment - - edited Hi Richard, thanks for your feedback. Good point that it should also be possible to copy that value and glad that you managed to do that also with the tooltip (I didn't try it yet). The Atlassian UI elements are sometimes a bit tricky to use, so I prefer not to change it if possible. Since yesterday you can also install the plugin directly from the Crowd Marketplace that is available in the latest Crowd versions. If you like our tiny plugin, I would really appreciate a short review in the Marketplace.  https://marketplace.atlassian.com/apps/1222750/timestamp-to-date-for-crowd Thanks a lot and many regards Patrick Hobusch ASERVO Software GmbH

            Richard Bukovansky added a comment - - edited

            Update: Nevermind! sorry! It seems I need to learn how to use Chrome apparently.

            Hi Patrick,

            the plugin seems to be working great. May I have one request? Would be possible instead of tooltip to show some small window (similar to "tooltip" window Jira shows when you hover over user's name) so the information inside can be copied out?

            Thank you.

            Regards,
            Richard Bukovansky
            CommmerzBank AG

            Richard Bukovansky added a comment - - edited Update : Nevermind! sorry! It seems I need to learn how to use Chrome apparently. — Hi Patrick, the plugin seems to be working great. May I have one request? Would be possible instead of tooltip to show some small window (similar to "tooltip" window Jira shows when you hover over user's name) so the information inside can be copied out? Thank you. Regards, Richard Bukovansky CommmerzBank AG

            Check out https://github.com/aservo/timestamp-to-date-crowd-plugin

            The Maven badge will lead you to a JAR that can be used to install the plugin. Marketplace acceptance is pending.

            Patrick Hobusch added a comment - Check out https://github.com/aservo/timestamp-to-date-crowd-plugin The Maven badge will lead you to a JAR that can be used to install the plugin. Marketplace acceptance is pending.

            It's so weird that more people haven't voted for this. It's such a convenience. Maybe everyone else in the administrator world just thinks in Epoch numbers?

            Deleted Account (Inactive) added a comment - It's so weird that more people haven't voted for this. It's such a convenience. Maybe everyone else in the administrator world just thinks in Epoch numbers?

              Unassigned Unassigned
              rlouie Robert Louie
              Votes:
              6 Vote for this issue
              Watchers:
              9 Start watching this issue

                Created:
                Updated:
                Resolved: