Jump to content

Issue with Reporting Filters with reserved characters


Martyn Houghton

Recommended Posts

Following recent updates to either the Platform or Admin Tool, existing reports where the Data Filters include textual fields with reserved characters in them are failing to return matching rows and display text the criteria is being corrupted. In our case, this is being caused by organisation names containing Ampersand '&' in organisation names.

The reserved character is being 'escaped' as @amp; in the selection criteria, but each time you add another organisation to the criteria list containing an ampersand, it is duplicated again.

Even without the duplicate escaped characters the reports are still not returning records for this organisation, which are present and meet the other criteria.

 

hornbillaper.thumb.png.fe6220cd2d99b8dab2e8b598c2f53e36.png

We are also having issues when entering organisation names into user prompted criteria where the name contains an appostrify.

Cheers

Martyn

 

Link to comment
Share on other sites

  • 4 weeks later...
  • Victor changed the title to Issue with Reporting Filters with reserved characters

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...