James Monroe
Active Member
We are on E1 apps 9.0, tools 9.1.4.7.
We have a request to have a report that will have data selection for RPRMK in F0411 to be LIKE 'BKGD'. In JDE we do not have the option to do a LIKE, so we have to select a range such as from 'BKGD' thru 'BKGDZZZZZZZZZZZZZZZZZ'.
But what if we encounter a special character. We are seeing in our test data that this field could have a value of 'BKGD/ABCD'. This BKGD/ is being selected by our data selection, which is what we want. But i've not been able to found exactly how special characters are treated in data selection.
I've looked but could not find a collating or sorting sequence list in JDE that would tell my exactly how special characters are treated when they are found in a field being used for a data selection range.
Also, would be interested in any other ways are treating a request to do a LIKE in JDE.
Thanks for your input
We have a request to have a report that will have data selection for RPRMK in F0411 to be LIKE 'BKGD'. In JDE we do not have the option to do a LIKE, so we have to select a range such as from 'BKGD' thru 'BKGDZZZZZZZZZZZZZZZZZ'.
But what if we encounter a special character. We are seeing in our test data that this field could have a value of 'BKGD/ABCD'. This BKGD/ is being selected by our data selection, which is what we want. But i've not been able to found exactly how special characters are treated in data selection.
I've looked but could not find a collating or sorting sequence list in JDE that would tell my exactly how special characters are treated when they are found in a field being used for a data selection range.
Also, would be interested in any other ways are treating a request to do a LIKE in JDE.
Thanks for your input