How to differentiate data directives and method directives in a SQL query

Kinetic ERP
1

I’m working on cleaning up and documenting old BPM’s, BAQ’s, screen customisations as a preliminary task to moving from classic to browser screens.

I’m doing a simple ‘live’ excel spreadsheet (sql query) that lists out the entity I’m looking at, and that allows me add notes etc, and then when I remove or disable anything the spreadsheet updates to show the effects of my clean up.

For BPM’s, I created the below query:


SELECT 
    BPD.Name, 
    BPD.BpMethodCode, 
    BPD.IsEnabled, 
    BPD.VisibilityScope, 
    BPD.DirectiveGroup,
    BPDT.Name AS Type
FROM 
    ice.BpDirective AS BPD
JOIN 
    ice.BpDirectiveType AS BPDT 
    ON BPDT.DirectiveType = BPD.DirectiveType
WHERE 
    BPD.Name NOT LIKE '%BASE%'

(Self taught SQL so apologies if anything makes you wince).

This gives me all I need to know except is it a data direct or method directive? The ice.BpDirectiveType table ‘Name’ field gives you the below list:

PreValidation
PreProcessing
BaseProcessing
PostProcessing
InTrans
OutOfTrans
PreProcessing
BaseProcessing
PostProcessing

Is this directly translatable to the type of BPM? Or is the ‘Source’ column in the ice.BpDirectiveType the clue?

Many thanks.

2

Hello! The table is Ice.bpdirective.

Column: Source

BO = Method
DB = Data

2 Likes
3

If the Source is BO then it is a method directive, DB are data directives and I think DQ are related to BAQ’s

2 Likes
4

@jgehling Thanks very much, that makes it easy for me.

Fairly obvious now I look at it, but was slightly thrown by the DQ - Thanks @tmat for your insight.