11/25/2024 11:39:38 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 SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.
|
|
|
|
Deleting plugins by removing from the Plugin Table
Posted: 06 Jan 09 10:18 AM
|
Hi, I have groups that appear in the Sales Client and the plugin table in the database but not in the Architect. Do you know how I can remove these views without deleting from the database tables?
If I am going to have to delete records from the database, please could you advise on the safest way to go about this without compromising the rest of the system.
Cheers,
Matt |
|
|
|
Re: Deleting plugins by removing from the Plugin Table
Posted: 06 Jan 09 12:23 PM
|
Matt:
In the architect, check for your groups under "Groups" and "Groups ACO".
What is the safest way to delete them? I would say via the Client, but that requires you login as the user that owns them.
From the Database, you need to do the following:
- Full Database backup (safety first).
- Create a copy of the Plugin table (This would allow you to more easily restore items that you remove by accident).
- Make sure that you understand which Plugins are the Master ones and which ones are the releases. And by that token, which Release items match up to the Master records.
- If you remove the Main Group, remove the Releases as well (so make sure that even though you don't want to see a group, all users that have access to it are aware of the removal).
- If a given Group is an Adhoc group, remove the related entries from the ADHOCGROUP table.
|
|
|
|
Re: Deleting plugins by removing from the Plugin Table
Posted: 07 Jan 09 9:22 AM
|
Hi Raul,
Thanks for the tips. 
How do I tell the difference between Master and Release versions in the database?
Do I need to know the difference as I am going to be deleting them all anyway?
Also, I am running SLX v6.1.1.1018 so I don't have an ADHOCGROUP table, is this normal?
Thanks,
Matt |
|
|
|
Re: Deleting plugins by removing from the Plugin Table
Posted: 07 Jan 09 9:46 AM
|
The original version (Master) doesn't have a "BasedOn" ID
A Release version has a "BasedOn" ID which links to the original version.
The reason it may make a difference, is if you are looking to delete a group by name, you should determine whose group you are deleting, in case there are multiple groups created by different users with he same name.
It may not matter on your case, but just general advice.
The ADHOCGROUP table pre-dates version 6.1, it has been (and still is) part of SalesLogix for quite a while. Please verify your DB schema, if you don't have it you may have other issues as well with it. |
|
|
|
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!
|
|
|
|
|
|
|
|