HOW TO ADD COLUMNS IN CATEG.ENT.BOOK ENQUIRY
- safzalhussain
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 44
- Thank you received: 0
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.
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.
- jpb
- Offline
- Moderator
- retired
Less
More
- Posts: 2859
- Thank you received: 649
10 years 6 months ago - 10 years 6 months ago #15964
by jpb
Replied by jpb on topic HOW TO ADD COLUMNS IN CATEG.ENT.BOOK ENQUIRY
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
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
Less
More
- Posts: 44
- Thank you received: 0
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.
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.
- jpb
- Offline
- Moderator
- retired
Less
More
- Posts: 2859
- Thank you received: 649
10 years 6 months ago #15973
by jpb
Replied by jpb on topic HOW TO ADD COLUMNS IN CATEG.ENT.BOOK ENQUIRY
Depends on your release, may be its GLOBUS.BP or T24_BP.
But have you tried using LINK ???
But have you tried using LINK ???
Please Log in or Create an account to join the conversation.
- safzalhussain
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 44
- Thank you received: 0
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?
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.
- jpb
- Offline
- Moderator
- retired
Less
More
- Posts: 2859
- Thank you received: 649
10 years 6 months ago #15976
by jpb
Replied by jpb on topic HOW TO ADD COLUMNS IN CATEG.ENT.BOOK ENQUIRY
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