28 Replies Latest reply on Jun 9, 2017 1:19 AM by shivathanali

    Does anyone have a Postgres query for exporting all user profile fields?

    jjohnsonf1

      We're looking to create a spreadsheet of all user profile field data - ideally one row per user and each profile field would be its own column. (We are on Jive 7, hosted by Jive - but not cloud - and have access to DB dumps.)


      We've got a query that gives us user profile info, but when we run it, users have 10 or more rows each, with a column for "value" and another for "name" that have different field names and values in them for each row - hence multiple rows for each user.

       

      Anyone have something close? Searched high and low in the community.