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

XMLWordPrintable

    • 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

            Marek Weihs made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Waiting for Release [ 12075 ] New: Closed [ 6 ]

            Marek Weihs added a comment -

            Addressed with Crowd 6.2.0.

            Marek Weihs added a comment - Addressed with Crowd 6.2.0.
            Pawel Cieszko made changes -
            Fix Version/s New: 6.2.0 [ 109699 ]
            Michal Samujlo made changes -
            Status Original: In Progress [ 3 ] New: Waiting for Release [ 12075 ]
            Pawel Cieszko made changes -
            Status Original: Under Consideration [ 11774 ] New: In Progress [ 3 ]
            Mathias Richter made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 938837 ]

            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

            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...

            Patrick Hobusch added a comment -

            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

            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

            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

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

                Created:
                Updated:
                Resolved: