4 Replies Latest reply on Aug 27, 2014 9:13 AM by datasci

Distinguishing Jive User Profile Fields

datasci Aug 27, 2014 8:45 AM

I'm trying to filter users based on their profiles. I see that profiles are stored in jivedw_userprofile and that the names of field_id's are given in jivedw_profilefield. I noticed that there are several with the same name but different field_id numbers, for instance 5020 and 5005 are both State, 5026 and 5027 are both Country, 5014 and 5016 are both "Connect with me on:", etc.

I'm just wondering if there's any distinct difference between these field_id's with the same name? Do some apply to certain types of users or are they just allowing for multiple values, etc?

Re: Distinguishing Jive User Profile Fields

bchamberlain Aug 27, 2014 8:51 AM (in response to datasci)

High level, the 5000 series of field IDs are the custom fields that have been added to your instance. The names will match whatever was setup in your system, so you could have duplicate names in there if someone set them up that way. The fields apply to all users in the system.
Like (1)

Actions
- Re: Distinguishing Jive User Profile Fields
  
  josh.richau Aug 27, 2014 8:54 AM (in response to bchamberlain)
  
  Bill is right.
  
  If I saw this, I would take a look at whether one or the other of the duplicate fields seem to have valid values. It is possible (and likely) that during configuration these extra fields got accidentally created but now only one is in use...
  
  Like (0)
  
  Actions
  - Re: Distinguishing Jive User Profile Fields
    
    datasci Aug 27, 2014 9:13 AM (in response to josh.richau)
    
    Thanks, that makes sense
    
    Like (0)
    
    Actions
- Re: Distinguishing Jive User Profile Fields
  
  datasci Aug 27, 2014 9:13 AM (in response to bchamberlain)
  
  Ah, that makes sense. Thanks for the information. I will follow up with the folks who set it up in my company.
  
  Like (0)
  
  Actions

Go to original post