Intersoft Community - WebGrid Enterprise - Web Grid - In the filter option & character is ignored

Web Grid - In the filter option & character is ignored

Hans — Fri, 13 Jul 2012 03:27:20 GMT

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 & or & or & 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 ‘&’.
For example, if you to find ‘Compa&ny’ value, you should type ‘Compa&ny’ in your filter column.

Hope this helps. Thank you.

Regards,
Hans.

Web Grid - In the filter option & character is ignored

Sampath.er — Fri, 13 Jul 2012 00:11:44 GMT

Hi Hans,

Try setting the TreatMarkupAsLiteralText to true.

<ISWebGrid:WebGridColumn Caption="CompanyName" DataMember="CompanyName" Name="CompanyName" TreatMarkupAsLiteralText="true" Width="150px"> </ISWebGrid:WebGridColumn>

When i set it to false it works fine and when its true it ends in the problem i have descriped in the previous posts

Web Grid - In the filter option & character is ignored

Hans — Fri, 29 Jun 2012 02:49:05 GMT

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.

Web Grid - In the filter option & character is ignored

Sampath.er — Thu, 28 Jun 2012 23:35:37 GMT

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

Web Grid - In the filter option & character is ignored

Hans — Thu, 28 Jun 2012 21:52:46 GMT

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.

Web Grid - In the filter option & character is ignored

Sampath.er — Thu, 28 Jun 2012 07:11:41 GMT

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

Web Grid - In the filter option & character is ignored

Hans — Thu, 28 Jun 2012 06:54:04 GMT

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.

Web Grid - In the filter option & character is ignored

Sampath.er — Thu, 28 Jun 2012 02:22:19 GMT

Hi All,

Am using web grid version 7. In the filter option if i have the column as name which has one its value as **&**. When i try to filter out the value with & the & and the rest of the characters disappear resulting in 0 rows found.

Thanks

Sampath