Co-worker lookup no phone numbers

[Ralf Peters]

What permission  is required to see the  phone number  in the co worker lookup, looks like  its only visible to a superuser ?

https://live.hornbill.com/<instancename>/coworkers/?page=1

 

the details do show  in the request view under the customer details ??!!

 

Thanks

 

Ralf

 

[Victor]

@Ralf Peters depends how the coworkers set this information (contact details) in their profiles... if this section is not set to public then not everyone will see this...

 

( @Ehsan thanks for the tip  )

[Ralf Peters]

thanks @Victor , is that a recent change , our co-workers (users)  normally do not touch their profile , we just add them automatically through an   ldap script when we create new users in our AD system . All of them seem to be set to "Followers" , i can not changed them  through the Live  poral , the admin portal   Home>System>organisational Data>users , does not have any option to set this.  What table does this setting live in so i can SQL it ?

Thanks  Ralf

 

[Victor]

@Ralf Peters there were a few changes around profile visibility but nothing recent (meaning nothing changes since last year)... The default visibility for profiles is "Followers". This is hard coded. If a user changes the visibility of a certain section then we have a record of this in the database... Therefore:

3 hours ago, Ralf Peters said:

What table does this setting live in so i can SQL it ?

won't matter since you can't change something is if not there (hope this makes sense). There is no easy way to bulk changes this, actually there is no way to change this by any other than the user changing them himself... I had a look and see if I can build a quick tool to call the set profile visibility API for a list of users but that won't work either...because the API takes the user information from the session variable, it is not passed as a parameter... there is a way to build a tool but is not quite simple... I can have a look and see if-how-when can be done... I'll also ask our dev team to see if they can expose the default visibility configuration in the admin UI so an admin can change the default values for these which are used when a user is created...

[Ralf Peters]

Hi  @Victor thanks for looking into this,  so what i can see is that  it writes to the h_sys_user_profile_viz  table ,  couldn't  i just ceate records for each userid, duplicating the field settings ?

The table was empty before i change my setting .

 

Thanks

 

Ralf

[Victor]

@Ralf Peters First of all I would really not advise to play around with SQL updates and inserts. I understand that you have knowledge in this area however, things can break so easily... I've seen tables wiped out, for example, by an incorrect statement or forgetting to add a correct filter and so on...

But you are right, the user profile settings are stored in this table and a record is created once a user changes any of these settings...You could create a record for each user ID however I am unable to advise further. If something breaks or not working right we would be unable to assist you in fixing it. I hope you understand this and the reasons behind this... What I can advise is to at least try with one or two users then, after a thorough testing, do this for any other...

[Ralf Peters]

Hi @Victor thanks for the help , fully understand what you are saying  !