Normally, we purge out all records from the Work Submitted Jobs screen that are at least 45 days old.
However, one of our clients requested to have all versions of R43510 purged after only one day.
While setting up the R9861101 data selection, I found that the Literal –> Range of Values method worked in a interesting way. I was able to enter the following range on the F986110|RNDFUF2 (Foundation – Future Use 2):
R5543500_MRI0000_0000_PDF - R5543500_MRI9999_9999_PDF
That is about the most robust string/integer range I’ve seen.
Then, I thought, “How the heck is this happening? Is it some kind of special JDE E1 processing that is parsing through the characters and integers?”
Well, as some of you already know, SQL has a “BETWEEN” SQL operator.
The SQL equivilant looks something like this:
select * from svm910.F986110<br>where JCFNDFUF2 between 'R5543500_MRI0000_0000_PDF' and 'R5543500_MRI9999_9999_PDF'