HOW TO ADD COLUMNS IN CATEG.ENT.BOOK ENQUIRY

  • safzalhussain
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
10 years 6 months ago #15963 by safzalhussain
HOW TO ADD COLUMNS IN CATEG.ENT.BOOK ENQUIRY was created by safzalhussain
can we add some more additional column in CATEG.ENT.BOOK enquiry. i need to add consol.key and narrative field from CATEG.ENTRY application to this enquiry.
as this is an enquiry from core which call internally NOF.CATEG.ENT so i m not been able yet to locate this nofile enquiry to modify.

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago - 10 years 6 months ago #15964 by jpb
The ENQUIRY CATEG.ENT.BOOK uses the NOFILE.CATEG.ENT.

In STANDARD.SELECTION of NOFILE.CATEG.ENT the routine E.CATEG.ENT.BY.CONCAT is used to build the list of relevant IDs in the format Y.CAT.NO:"*":CATEG.ENT.ID:"*":YOPEN.BAL:"*":APPLN

With this IDs back in the ENQUIRY the routine E.CATEG.ENQ2 is used to populate the R.RECORD that is used to present the data.
Both routines can be found in T24.BP.

If you want to add additional data that can't be accessed using LINK you can either add a routine to get the values or change E.CATEG.ENQ2 to append another field to R.RECORD (or better create a copy under a new name and use it in your own enquiry).

"consol.key and narrative field from CATEG.ENTRY" should be easy to add using LINK, e.g.

FIELD.NAME - NARR
OPERATION - @ID
CONVERSION - F *,2,1
CONVERSION - L CATEG.ENTRY,NARRATIVE

FIELD.NAME - CONSOL.KEY
OPERATION - @ID
CONVERSION - F *,2,1
CONVERSION - L CATEG.ENTRY,CONSOL.KEY
Last edit: 10 years 6 months ago by jpb. Reason: example for LINK

Please Log in or Create an account to join the conversation.

  • safzalhussain
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
10 years 6 months ago #15969 by safzalhussain
Replied by safzalhussain on topic HOW TO ADD COLUMNS IN CATEG.ENT.BOOK ENQUIRY
thanks for replying to my question.

I didn't find any forlder named T24.BP in my environment.
Kindly suggest how can I locate E.CATEG.ENQ2 routine to use it alternaively.

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago #15973 by jpb
Depends on your release, may be its GLOBUS.BP or T24_BP.

But have you tried using LINK ???

Please Log in or Create an account to join the conversation.

  • safzalhussain
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
10 years 6 months ago #15974 by safzalhussain
Replied by safzalhussain on topic HOW TO ADD COLUMNS IN CATEG.ENT.BOOK ENQUIRY
thanks for the response.
yes i did find it in GLOBUS.BP.

But couldnt understand that you confirmed about LINK
(((((But have you tried using LINK ???))))), where should i try?

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago #15976 by jpb
As shown in first reply. Just add your fields in that way (with the respective COLUMN)

Please Log in or Create an account to join the conversation.

Time to create page: 0.076 seconds