Interprise Suite Community / Interprise Suite Community Forums / End User Customizations & Role Management

Adding a manually created table to the Data Dictionary?

Greg Sergeant — Tue, 02 Mar 2010 10:09:14 GMT

Is there anyway to add a manually created table to the data dictionary? I need to create a table with many dozens of columns and using the DD tool is just so slow and painful. I can hack out the SQL script in a few minutes to make a table that will take me forever using the DD manager.

It would be nice if I could script the table and have the Data Dictionary table update itself to include my new table. I see some stored procedures named RefreshDataDictionaryTable and UpdateDataDictionaryTable but I don't know what they do.

Thanks for any help

Single-quotes and searching in IS

powlessn — Wed, 27 Jan 2010 09:01:52 GMT

Hi,

I'm having some trouble using search parameters containing single quotes.
Anyone else have the same problem? Any solutions?

I'm guessing it has something to do with an unescaped single quote character being submitted to the stored procedure/dynamic SQL query.

Anyone know which stored procedures are responsible for searching (more specifically, searching the active customer view)?
Perhaps I can manually escape the single quotes there...

Thank-you!

View/SP associated with My Customers Tab

powlessn — Fri, 08 Jan 2010 11:02:08 GMT

When you click on Find Customer in the CRM module, you are presented with a screen showing various fields which
you can use to locate a customer. I'm trying to modify which fields appear under the My Customers Tab.

Does anyone know which view or stored procedure is used to build the My Customers Tab?

Thanks in advance.

-Nathan

Sales Rep resricted to their own customers only

aj — Thu, 24 Sep 2009 01:26:24 GMT

HI,

Is there a way to restrict sales rep to restrict to view their own customers only by giving access to "My Customers" tab only in Find Customers".

How can we control this access and user role does not allow to customize find screens.