We have many BPMs and Customizations containing hard-coded server names, which I need to identify ASAP. I know, I know, this is an awful idea, that is why I am trying to clean it up :slight_smile: I got all the BPMs with the following SQL code: select * from BpDirective where cast(Body as nvarcha…

This post may shed some guidance… [image] Grab Custom Controls on forms ERP 9 I was wondering if anyone knows of an easy way to search for forms that use the generic columns(Character01, CheckBox01, Date01, Number01, ShortChar01). I tried Inspect.exe, spy++and other UI te…

This will do the job for you: select * from ice.XXXDef where content like '%YOUR_SEARCH_TERM_HERE%'

The post @Mark_Wonsil referenced works for older versions. The more current versions store the Client customizations in plain text (xml) in the xxxDef table Content field. If your system has the Content field on xxxDef, that is where you would look.

Thanks, all. Looks like I missed out on the easy way; our Live system is on 10.1.400 and XXXDef.Content doesn’t exist in the database. But I’ll keep this in mind for when we finish upgrading. The post Mark referenced might be a bit much for me, I think I’ll just skim through manually.

Search through all Customizations containing a string value?

Epicor ERP 10

Mark_Wonsil (Mark Wonsil) May 29, 2020, 8:12pm 2

This post may shed some guidance…

Topic		Replies	Views
Grab Custom Controls on forms Epicor ERP 9	6	2880	July 14, 2017
Where is saved the custom code of a form? Epicor ERP 10 e10 , customization	5	1515	June 7, 2023
Search for Specific C# Code in Method Directives Epicor ERP 10 e10 , customization	6	2068	June 23, 2020
System tablenames for storing customizations Epicor ERP 10 e10 , customization	8	4397	December 5, 2017
Tracking Form Customizations Epicor ERP 10 e10 , epicor , customization	2	989	August 15, 2023

Search through all Customizations containing a string value?

Related topics