Hello,

I’m sorry for the inconvenience.
I’ve made a simple sample that maybe similar with your scenario.
In my sample, I use Northwind.mdb and Shippers table. In Shippers table, I added a couple row that have “&” value in CompanyName column (BeforeSearch.png).
I tried to do filtering in CompanyName column with “**&**” and I got “no rows” message as well (AfterSearch-1.png).

To run your filter scenario, perhaps you could filter the value with “*&”. This filter value, works on my end (AfterSearch-2.png)

Hope this helps. Thank you.
Regards,

Hans.

Hi Hans,

             Thanks for the reply. I have couple of questions in the scenario

Are you using version 7 for the sample.

If so to do the search no need to use **&**, the problem am facing is if we enter for ex: compa&ny, after compa the rest gets cleared. use the filter option equal to. try entering only & it gets cleared from the filter box.

 

Thanks

Sampath

Hi,

Yes, I’m using WebGrid 7 in my sample.

I’ve tried set filter option to “Equals To”, then entered “&” value. And I gets “no row” message as well. (FilterEqualsTo.png)
As far as I know, if you set filter option to “Equals To”, that means WebGrid will only find data that equal/same with “&”. 

You have two option to get all row that contain “&” value :
First, if you want to use “*&” value, you should set filter option to “Like”. (FilterLike.png)
Second, if you want to use “&” value, you should set filter option to “Contains”. (FilterContains.png)

Thank you.

Regards,
Hans.

Hi Hans,

             Thanks for the reply. I agree with the otpions, but the problem i face is that the & character disappears. For ex: if we type compa&ny, the characters &ny gets cleared from the filter input box.

 

Thanks

Sampath

Hi,

I’m sorry for this misunderstanding.

I tried to filter with “Compa&ny” as well. However, I can’t reproduce your issue on my end. (FilterAnd.png)
Have you try to use the latest hotfix of the WebGrid and the WebUIFramework?
I use WeGrid.NET 7.0.7200.533 and WebUI.NET Framework 3.0.5000.803.

I also attached my sample. If you don’t mind, could you tell me, is there any setting that I have miss in my sample?
Or could you send me a simple project that replicate this issue?

Thank you.

Regards,
Hans.

Hi Hans,

             Try setting the TreatMarkupAsLiteralText to true.

Hello,

Thank you for your reply.

I can replicate your issue on my end, after I followed your instruction.
I apologize for the inconvenience.

Basically, the function of this property (TreatMarkupAsLiteralText) is to gets or sets whether markups such as HTML or XML should be treated as literal text.
For example, a literal < normally indicates the start of a tag, and & normally indicates the start of a character entity reference or numeric character reference; writing it as &amp; or &#x26; or &#38; allows & to be included in the content of an element or in the value of an attribute.

Therefore, if you want to use ‘&’ character, you should changes into ‘&amp;’.
For example, if you to find ‘Compa&ny’ value, you should type ‘Compa&amp;ny’ in your filter column.

Hope this helps. Thank you.

Regards,
Hans.