How to make a report and add a condition to fetch values smaller than 10000 on the field alphanumeric

[martinpersoroux]

How to make a report and add a condition to fetch values smaller than 10000 on the field alphanumeric.

Is it possible ?

[darius_koohmare]

The condition builder condition for 'less than or is' 9999 should work for you.

See this example I tested below:

[Shiva Thomas]

Bonjour Martin,

I tried Darius approach, but it did not work for me...

I experimented using a custom dynamic filter, but failed to get results.

Previous versions of the Now platform had a 'MATCHES REGEX' condition in the filter. Regular Expressions would have been a perfect solution for you!

Sadly the RegExp condition seems to have been removed some years ago. I think it was quite buggy and caused many issues... There are some old discussions on the subject in the Community (ex: Matches Regex in Condition Builder). Some of those, they also mention the use of RegExp with 'CONTAINS' but I was not able to replicate. I think this is not supported anymore.

Conclusion, I got no answer for you, even after one hour of experimentation.

[Shiva Thomas]

Bonjour Martin,

Since string field can't be filtered/ordered for their numeric value, the solution is to work with an integer field . Here is what I did...

Create a new custom field, like 'u_numeric_description' of type integer. Make it read only.

Create a new business rule, like 'Set Numeric Description' and make it run on insert and update, when Short Description changes.

From the business rules set the 'u_numeric_description' with this JavaScript

javascript: parseInt(current.short_description)

Now you only have to update your reports' filter to use the Numeric Description instead... And the Less Than condition will work!

Victory at least!