11/26/2024 8:26:09 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.
|
|
|
|
Hidden Contact Fields: How to unhide them? Version 7.0.1
Posted: 05 Aug 09 12:53 PM
|
Hello all,
I have three Contact table fields that appear to be totally hidden from the Client UI, specifically in the query builder. They are Userfields 1, 2, 3. Originally they were hidden by going into the Administrator's DB Manager and un-checking the check box in the "Vis" Column or so I thought. However, after re-checking the "Vis" check box again and refreshing both the Administrator and client, we still cannot see any of the three userfields in the query builder. I've also checked the Manage --> Field Security Profiles in the Admin (or Architect) and none of the Profiles see those 3 userfields either as an field to set the No Access, RO, or RW option on, although userfields 4-10 are available.
So I'm obviously forgetting another step that we performed when we hid the fields originally or there is something else going on. Any help you can provide is greatly appreciated.
Thanks in advance! |
|
|
|
Re: Hidden Contact Fields: How to unhide them? Version 7.0.1
Posted: 06 Aug 09 3:31 AM
|
Hi,
Can you see the fields in the Query Builder logged in as Admin? I believe that the "Vis" option only applies to non-admin users and that Admin should be able to see them.
This property is stored in the SECTABLEDEFS table - the "ISHIDDEN" field. Have a look in that table and see what value is set for your fields. Perhaps reset to "F" or Null and see what happens. You might need to restart your SLX Services though.
Regards,
Stephen
www.slxmaster.com
|
|
|
| |
|
Re: Hidden Contact Fields: How to unhide them? Version 7.0.1
Posted: 06 Aug 09 3:32 PM
|
Hi Stephen,
Thanks for the reply! Unfortunately, I can't login into the client as the Admin due to a unique security policy within my company and so I can't follow through on your suggestion on logging in as Admin. I did look within the SECTABLEDEFS and it matches what the DB Manager shows. Although I will try setting the "ISHIDDEN" to NULL to see if that makes any difference. It currently is set to "F" which should be okay but you never know and setting it to NULL is worth a try. Also, since the changes have been made both the application server and the client machine have been rebooted with no effect whatsoever.
If you happen to think of anything else feel free to let me know. I'll also let the group know the outcome of setting the "ISHIDDEN" field to NULL.
Thank you! |
|
|
|
Re: Hidden Contact Fields: How to unhide them? Version 7.0.1
Posted: 06 Aug 09 3:36 PM
|
Thanks for replying Mike!
Both the Application & Sync servers and the client machines have gone through weekly reboots since I've re-checked the "Vis" column in the DB Manager. Anything else you can think of that I should try would be appreciated.
Thanks! |
|
|
|
Re: Hidden Contact Fields: How to unhide them? Version 7.0.1
Posted: 06 Aug 09 5:04 PM
|
Ah, right ! What I would now do is query the sectabledefs and resynctabledefs and ensure that the IsHidden option is switched on/off correctly and that all the cols match up (compare this with the actual table in SQL). You should then use SLXProfiler to check the state of SQL being sent it. Also, I seem to recall some of these settings (for Vis) are set in the registry - so, export the HKCU\Software\SalesLogix key on the PC. Then delete it and this should re-initialise the QB.
|
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|