Find where a field is used?

Yahoo Archive
1
If you are using Progress, you can use Progress' meta-schema file structure
to determine all the locations of field - Progress query.

Def var l-printer as logical
label "Printer output?" no-undo.
Def var c-field as char format "x(20)" label
"Field Name" no-undo.
Def var I as integer format ">>>9" label
"Count" no-undo.

Update c-field colon 40
l-printer colon 40
with frame f-in width 80 side-labels title "Find Field".

If l-printer = true then output to printer paged.

FOR EACH _file WHERE SUBSTRING(_file._file-name,1,2) <> "IM",
EACH _field OF _file WHERE
_field.field-name = c-field.
/* OR _field.field-name MATCHES "*comment*". */

/* _field._field-name MATCHES "*terr*". */
DISPLAY
i
_file._file-name FORMAT "x(20)"
_field._field-name FORMAT "x(20)"
_field._format FORMAT "x(10)"
WITH TITLE "Find fields with " + c-field.

END.

Carl Peterson
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
advantage
Sent: Tuesday, September 22, 2009 6:08 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Find where a field is used ?


I think what Kristi was asking; was HOW did you figure that out. I simply
peruse the Data Dictionary.pdf or use zDataFields?

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
bw2868bond
Sent: Tuesday, September 22, 2009 5:25 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Find where a field is used ?

AnalysisCode: Used in these tables
AnalysisCd
ECOMtl
ECOOpr
GlbPart
IMAnalysisCd
IMECOMtl
IMECOOpr
IMGlbPart
IMJobAsmbl
IMJobHead
IMJobMtl
IMJobOper
IMOpMaster
IMPart
IMPartMtl
IMPartOpr
IMQuoteAsm
IMQuoteDtl
IMQuoteMtl
IMQuoteOpr
JobAsmbl
JobHead
JobMtl
JobOper
Obsolete803-AnalysisCode
OpMaster
Part
PartMtl
PartOpr
QuoteAsm
QuoteDtl
QuoteMtl
QuoteOpr

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"k_stump" <kristi.stump@...> wrote:
>
> Hi,
> I'm looking for ways to find where all a field is used - screens, reports,
etc. For example, where the AnalysisCode of the Part table is referenced.
>
> Thanks !
> Kristi
>

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
2
Hi,
I'm looking for ways to find where all a field is used - screens, reports, etc. For example, where the AnalysisCode of the Part table is referenced.

Thanks !
Kristi
3
AnalysisCode: Used in these tables
AnalysisCd
ECOMtl
ECOOpr
GlbPart
IMAnalysisCd
IMECOMtl
IMECOOpr
IMGlbPart
IMJobAsmbl
IMJobHead
IMJobMtl
IMJobOper
IMOpMaster
IMPart
IMPartMtl
IMPartOpr
IMQuoteAsm
IMQuoteDtl
IMQuoteMtl
IMQuoteOpr
JobAsmbl
JobHead
JobMtl
JobOper
Obsolete803-AnalysisCode
OpMaster
Part
PartMtl
PartOpr
QuoteAsm
QuoteDtl
QuoteMtl
QuoteOpr

--- In vantage@yahoogroups.com, "k_stump" <kristi.stump@...> wrote:
>
> Hi,
> I'm looking for ways to find where all a field is used - screens, reports, etc. For example, where the AnalysisCode of the Part table is referenced.
>
> Thanks !
> Kristi
>
4
I think what Kristi was asking; was HOW did you figure that out. I simply
peruse the Data Dictionary.pdf or use zDataFields?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bw2868bond
Sent: Tuesday, September 22, 2009 5:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Find where a field is used ?




AnalysisCode: Used in these tables
AnalysisCd
ECOMtl
ECOOpr
GlbPart
IMAnalysisCd
IMECOMtl
IMECOOpr
IMGlbPart
IMJobAsmbl
IMJobHead
IMJobMtl
IMJobOper
IMOpMaster
IMPart
IMPartMtl
IMPartOpr
IMQuoteAsm
IMQuoteDtl
IMQuoteMtl
IMQuoteOpr
JobAsmbl
JobHead
JobMtl
JobOper
Obsolete803-AnalysisCode
OpMaster
Part
PartMtl
PartOpr
QuoteAsm
QuoteDtl
QuoteMtl
QuoteOpr

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"k_stump" <kristi.stump@...> wrote:
>
> Hi,
> I'm looking for ways to find where all a field is used - screens, reports,
etc. For example, where the AnalysisCode of the Part table is referenced.
>
> Thanks !
> Kristi
>







[Non-text portions of this message have been removed]
5
I guess I 'cheated' then :o)
I opened the html schema of our db, clicked on part table and clicked on the field xref for the field.

Html schema was generated by the 'htmdict' progress app

--- In vantage@yahoogroups.com, "advantage" <advantage@...> wrote:
>
> I think what Kristi was asking; was HOW did you figure that out. I simply
> peruse the Data Dictionary.pdf or use zDataFields?
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> bw2868bond
> Sent: Tuesday, September 22, 2009 5:25 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Find where a field is used ?
>
>
>
>
> AnalysisCode: Used in these tables
> AnalysisCd
> ECOMtl
> ECOOpr
> GlbPart
> IMAnalysisCd
> IMECOMtl
> IMECOOpr
> IMGlbPart
> IMJobAsmbl
> IMJobHead
> IMJobMtl
> IMJobOper
> IMOpMaster
> IMPart
> IMPartMtl
> IMPartOpr
> IMQuoteAsm
> IMQuoteDtl
> IMQuoteMtl
> IMQuoteOpr
> JobAsmbl
> JobHead
> JobMtl
> JobOper
> Obsolete803-AnalysisCode
> OpMaster
> Part
> PartMtl
> PartOpr
> QuoteAsm
> QuoteDtl
> QuoteMtl
> QuoteOpr
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> "k_stump" <kristi.stump@> wrote:
> >
> > Hi,
> > I'm looking for ways to find where all a field is used - screens, reports,
> etc. For example, where the AnalysisCode of the Part table is referenced.
> >
> > Thanks !
> > Kristi
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>