How about using a custom Rule utility function and use regular expressions in that, could not find what is not considered as best practice in that.

Another one could be use predefined functions to spilt this number and get only last two characters and then easily check if it is in the range of 0 to 09  and also check if first 4 characters are "T09."  This could also be done in a custom Rule utility function

Assuming your encoding scheme means that all the characters to the right of the 'T' character should be treated as a Decimal Number, then you can use the Expression:

@(Pega-RULES:String).toDecimal( @(Pega-RULES:String).substring(.StartAlpha, 1) )

For instance, I have setup a simple Data Model consisting of 'StartAlpha', 'EndAlpha' which contains your example Text values, and 'StartNumeric' and 'EndNumeric' to hold the transformed Decimal values.

Then you can use a Data Transform (for instance) to perform the mapping:

Running this Data Transform with your example inputs gives:

<pagedata>
    <EndNumeric>9.09</EndNumeric>
    <pxObjClass>Gcs-GCSAppli-Work</pxObjClass>
    <StartNumeric>9.00</StartNumeric>
    <StartAlpha>T09.00</StartAlpha>
    <EndAlpha>T09.09</EndAlpha>
    <pzStatus>valid</pzStatus>
</pagedata>

So you should now be able to use 'StartNumeric' and 'EndNumeric' values in your Range Criteria in a Decision Table (although I didn't try that).

Note: you probably want to put in guard into your logic to ensure your input meets the specified criteria; so you might want to make use of some of the other functions available in the String (etc) library - for instance 'isDouble'.

You could build 'When' steps into your Data Transform to do this for instance.

And lastly - I have used 'hardcoded' two Page Properties in the example above (I'm repeating the same code for each 'Set') , but you might instead want to create a re-usable general Parameter-based DT transform here - that you can re-use the same logic for each of your inputs.

Cheers

John

Hi Guys,

I have found one simple solution to the above problem.

1. I basically created an alias SQL function for an checking the codes in range for alphanumeric values and added them to "Embed-UserFunction" Class which on refresh or restarting the Pega session will appear in Calculation Builder in Report Definition.

2. I created one Data table (Data type in Pega 7.1.8) and added my alphanumeric codes as records to that entry. I only specified their start and end ranges in the table.

3. I made use of auto generated Page and Report definition for that particular data type along with my function alias created in Step 1 and retrieved the records by sending the code that is to be checked as a parameter to data page which internally sends it to its source.

4. From the results page of that respective data page i check if I have a record with this match.

This solved my Issue. Hope this post helps others in future.

Thanks

Prasan