DBohner-(db)
Legendary Poster
Report Data Selection \'Injector\' (Project)
OK, I need to offer a bounty....
I have a personal vendetta/project that requires the ability to 'inject' a Report's Data Selection with some file-data driven Data Selection.
I am only looking for the 'function' to do the DS Injecting.
Users will be able to update an Application Grid with the Data Selection for a specific UBE | Version and have that 'Complex' DS 'Injected' into the Report's Data Selection.
Concept works like this:
User updates Application with prescribed Report-Level Data Selection:
Application contains:
Header: UBE / Version
Grid: UBE / Version / Field / DS Type / Value01 / Value02 /... / Value24
**Note -
Field: is pre-defined as one of the fields in the V8300001 BSVW
DS Type: Is pre defined similar to
JDEDB_CMP_LE = 0, /* <= */
JDEDB_CMP_GE = 1, /* >= */
JDEDB_CMP_EQ, /* == */
JDEDB_CMP_LT, /* < */
JDEDB_CMP_GT, /* > */
JDEDB_CMP_NE, /* != */
JDEDB_CMP_IN, /* IN */
JDEDB_CMP_NI, /* NOT IN */
JDEDB_CMP_BW, /* BETWEEN */
JDEDB_CMP_NB, /* NOT BETWEEN */
JDEDB_CMP_LK, /* LIKE */
*** NOTE - Each line of the Grid would be an "AND" syntax for the DS Injector.
User Runs UBE.
In the Initialize Section of the UBE, the DS Injector is called:
1. The Version's Data Selection is captured (probably using the ubeSection_GetDataSelection).
2. The Injector part of the function reads each line from the file, as defined from the grid, and injects.
2.a. Each Grid Line is an 'AND' - of its own.
3. The original Data Selection is then appended to the front of the 'injected' data selection.
4. JDB_SetSelection is kicked and the UBE's Data Selection is overridden. Based on research - I believe the JDB_SetSelection can be used to override a UBE's Data Selection (Please correct me if is a confirmation that this cannot be done)...
When the DS is reviewed in Debugger, the Where clause would look like:
Where (Version DS) and (
(Grid Line 1 DS) and
(Grid Line 2 DS) and
...
)
If anyone is interested in this project - contact me directly.
Yes, I am looking to contract/pay$$ for this solution.
Yes, I do intend to make the template available as a proof of concept - to anyone that needs an example...
Anyone familiar with World - can look at the F8303 as an example table layout.
Contact me at: [email protected] or at 208.991.2595 if interested in becoming famous!
(db)
I know that there are C folks that have already done this
OK, I need to offer a bounty....
I have a personal vendetta/project that requires the ability to 'inject' a Report's Data Selection with some file-data driven Data Selection.
I am only looking for the 'function' to do the DS Injecting.
Users will be able to update an Application Grid with the Data Selection for a specific UBE | Version and have that 'Complex' DS 'Injected' into the Report's Data Selection.
Concept works like this:
User updates Application with prescribed Report-Level Data Selection:
Application contains:
Header: UBE / Version
Grid: UBE / Version / Field / DS Type / Value01 / Value02 /... / Value24
**Note -
Field: is pre-defined as one of the fields in the V8300001 BSVW
DS Type: Is pre defined similar to
JDEDB_CMP_LE = 0, /* <= */
JDEDB_CMP_GE = 1, /* >= */
JDEDB_CMP_EQ, /* == */
JDEDB_CMP_LT, /* < */
JDEDB_CMP_GT, /* > */
JDEDB_CMP_NE, /* != */
JDEDB_CMP_IN, /* IN */
JDEDB_CMP_NI, /* NOT IN */
JDEDB_CMP_BW, /* BETWEEN */
JDEDB_CMP_NB, /* NOT BETWEEN */
JDEDB_CMP_LK, /* LIKE */
*** NOTE - Each line of the Grid would be an "AND" syntax for the DS Injector.
User Runs UBE.
In the Initialize Section of the UBE, the DS Injector is called:
1. The Version's Data Selection is captured (probably using the ubeSection_GetDataSelection).
2. The Injector part of the function reads each line from the file, as defined from the grid, and injects.
2.a. Each Grid Line is an 'AND' - of its own.
3. The original Data Selection is then appended to the front of the 'injected' data selection.
4. JDB_SetSelection is kicked and the UBE's Data Selection is overridden. Based on research - I believe the JDB_SetSelection can be used to override a UBE's Data Selection (Please correct me if is a confirmation that this cannot be done)...
When the DS is reviewed in Debugger, the Where clause would look like:
Where (Version DS) and (
(Grid Line 1 DS) and
(Grid Line 2 DS) and
...
)
If anyone is interested in this project - contact me directly.
Yes, I am looking to contract/pay$$ for this solution.
Yes, I do intend to make the template available as a proof of concept - to anyone that needs an example...
Anyone familiar with World - can look at the F8303 as an example table layout.
Contact me at: [email protected] or at 208.991.2595 if interested in becoming famous!
(db)
I know that there are C folks that have already done this