11/27/2024 12:23:10 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 writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Show ad-hoc groups as a grid at Contact Level
Posted: 21 Dec 06 8:51 AM
|
fiogf49gjkf0d Hi Folks
SLX 6.2
Customer requests a way to see which add hoc groups that a contact is a member of (ie a grid on a tab)
I set up a simple datagrid that binds to contactid.
The table for the grid is addhocgroup the grey field set to be entityid.
Created a local join to plugin on groupid -> pluginid
Put plugin.name on the layout
It works great logged in as admin, but not well when logged on as a user (they cannot see group names in the list unless they created them - even though they are shared to everyone).
I have another tab that doesn't do the join and it works great, but of course it can only show ids. I got a script that when you clicked the row, it does a getfield to return the name, but that doesn't work.
Any ideas how to do this. I would be very happy if all groups with the contact in appeared in the tab - even those that the user does not have shared to them.
Cheers
Nick |
|
|
|
Re: Show ad-hoc groups as a grid at Contact Level
Posted: 21 Dec 06 8:57 AM
|
fiogf49gjkf0d Ideally I could - in my script do something like this ...
Sub TDataGrid1Click(Sender)
dim pluginid
application.basicfunctions.PRETEND_TO_BE_ADMIN
pluginid = Getfield("NAME", "PLUGIN", "PluginID = '" & tdatagrid1.GetCurrentField("GroupID") & "'")
txtgroupname.Text = pluginid
application.basicfunctions.STOP_PRETENDING_TO_BE_ADMIN
End Sub
That would get me round the security that is stopping me |
|
|
|
Re: Show ad-hoc groups as a grid at Contact Level
Posted: 21 Dec 06 9:56 AM
|
fiogf49gjkf0d Got it working!!! So of course all I need to do is to have the pluginid on the grid then whenclick event calls a script that opens a connection to Saleslogix giving the username as admin! and a little sql query followed by a message box and lift off.
Ok its kinda crap so if anyone can come up with a better way - please let me know.
But my customer is happy at this point - so its all good
Cheers folks - have a good holidays.
Nick |
|
|
|
Re: Show ad-hoc groups as a grid at Contact Level
Posted: 22 Dec 06 8:04 AM
|
fiogf49gjkf0d I had the same problem. My work-around was to create a SQL view that pulled all info from the plugin table. If you are using 6.2.4 your provider can support create statements so it can be pushed out to remotes. It should probably be noted that this is a BAD idea because it circumvents the provider security but whatever... It works for me and you don't need to hard code the admin password. |
|
|
|
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!
|
|
|
|
|
|
|
|