UBAQ BPM DLL Assembly - Does it exist, and where?

Kinetic ERP
10

I search the database directly especially if I’m dealing with tech debt.

Find code in EFX

SELECT
	EfxFunction.LibraryID,
	EfxFunction.FunctionID,
	EfxFunction.Description,
	CONVERT (nvarchar(MAX), Body, 0) AS MyText
FROM
	Ecf.EfxFunction
WHERE
	CONVERT (nvarchar(MAX), Body, 0) LIKE '%Ice.Diag%'
ORDER BY
	EfxFunction.LibraryID ASC,
	EfxFunction.FunctionID ASC

Find code in Method, Data, UBAQ directives

SELECT
	BpDirective.DirectiveID,
	BpDirective.Source,
	BpDirective.DirectiveType,
	BpDirective.DirectiveGroup,
	BpDirective.Name,
	BpDirective.Company,
	BpDirective.BpMethodCode,
	CONVERT (nvarchar(MAX), Body, 0) AS MyText
FROM
	Ice.BpDirective
WHERE
	CONVERT (nvarchar(MAX), Body, 0) LIKE '%.CreditHold%'
ORDER BY

	BpDirective.Source ASC,
	BpDirective.DirectiveGroup ASC,
	BpDirective.BpMethodCode ASC,
	BpDirective.DirectiveType ASC,
	BpDirective.Name ASC

Find in screen customization

SELECT
  XXXDef.Key1,
  XXXDef.Key2,
  XXXDef.Content
FROM
  Ice.XXXDef
WHERE
  TypeCode = 'Customization' AND
  Content LIKE '%RestClient%'

Auxiliary note here

On latest versions of Epicor to get the source to show up in these folders you will want to enable dump sources
image

4 Likes