Jump to content


Photo

Ampersands in Filters


  • Please log in to reply
2 replies to this topic

#1 gaz

gaz

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 17 September 2012 - 06:06 AM

I'm not sure if this is across the board, but on the Accounts screen, if an '&' is used in the filter, no results are returned.

The global filter seems to work just fine however across the board.

There's various issues with '&' being displayed as '&' too on various screens.

Anyone else finding this?

#2 Ivica

Ivica

    Advanced Member

  • Moderators
  • 478 posts

Posted 17 September 2012 - 10:37 AM

Yes, there is issue with ampersand for some fields and I created story for this.

Can you provide me more details about first issue, what exactly you did, because I tested, and it worked fine for me.

#3 gaz

gaz

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 18 September 2012 - 02:00 AM

Ah, ok. I just created a new account with name 'ZZZ & ZZZ' and when searching using the filter, it does indeed show up. Looking at the database, the record has been created as 'ZZZ & ZZZ'. I'm not sure why HTML entities would be saved in to the db. I guess that's the error here, which also causes the fact that on the accounts screen, the name field also displays the record as 'ZZZ & ZZZ'.

So to explain my original comment, all of my accounts names are in the db as '&'. I guess the filter is looking for HTML entities, which again is fairly bizarre. I guess a consistent approach to special chars is required across the board here.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users