|
[QUESTION] FilterText support mix chars & numbers |
Post Reply 
|
| Author | |
Aaron 
Senior Member 
Joined: 29 January 2008 Status: Offline Points: 2192 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: [QUESTION] FilterText support mix chars & numbersPosted: 25 November 2009 at 12:41pm |
|
Hi,
When assigning wndReportControl.FilterText = "Section 1" , should it return only items that contain exact match? I tried but it shows also items with "Section 3" or "Section 10"
So my question is: Can RC handle filtering with mix of chars & numbers that are seperated with spaces?
Thanks
|
|
|
Product: Xtreme SuitePro (ActiveX) version 15.0.2
Platform: Windows XP (32bit) - SP 2 Language: Visual Basic 6.0 Zero replies is not an option.... |
|
 |
|
|
mdoubson
Senior Member
Joined: 17 November 2008 Status: Offline Points: 1705 |
Post Options
Thanks(0)
Quote Reply
Posted: 25 November 2009 at 8:40pm |
|
No - you will have all rows with items have pattern as part of caption (non case-sensitive) - just play with MFC Report Sample - menu Report Control - Filter window [https://forum.codejock.com/uploads/DemoVersion/ReportSampleStatic.rar]
|
|
|
|
|
Aaron
Senior Member
Joined: 29 January 2008 Status: Offline Points: 2192 |
Post Options
Thanks(0)
Quote Reply
Posted: 27 November 2009 at 1:07pm |
|
Hi Mark,
I thought so, because all items that contains "Section" are filtered.
Too bad, now I have to do my own filtering
 It would be a nice option to have filtering options with .FilterText within the control itself. Thanks for reply
|
|
|
Product: Xtreme SuitePro (ActiveX) version 15.0.2
Platform: Windows XP (32bit) - SP 2 Language: Visual Basic 6.0 Zero replies is not an option.... |
|
|
|
|
mdoubson
Senior Member
Joined: 17 November 2008 Status: Offline Points: 1705 |
Post Options
Thanks(0)
Quote Reply
Posted: 27 November 2009 at 1:13pm |
|
No - you suppose to see "Section 1" and "Section 10" but not "Section 3"
|
|
|
|
|
SuperMario
Admin Group 
Joined: 14 February 2004 Status: Offline Points: 18057 |
Post Options
Thanks(0)
Quote Reply
Posted: 27 November 2009 at 1:27pm |
|
In your example it will find ANY combination of "Section" and "1"
So ALL of these would match: Test Text Section Test Text 1 Test Text Test Text 1 Test Text Section Test Text Test Text Section Test Text A100 Test Text Test Text 100000 Test Text Section Test Text etc.... |
|
|
|
|
mdoubson
Senior Member
Joined: 17 November 2008 Status: Offline Points: 1705 |
Post Options
Thanks(0)
Quote Reply
Posted: 27 November 2009 at 1:33pm |
|
using ReportSampleStatic I only tried strings "2009 1", "2009 - 10" and "2009-11" - report show proper different sets
|
|
|
|
|
mdoubson
Senior Member
Joined: 17 November 2008 Status: Offline Points: 1705 |
Post Options
Thanks(0)
Quote Reply
Posted: 27 November 2009 at 1:42pm |
|
You right - this old algorith is not strict enough - I agree. Need to improve it or add special flag - WeakOrStrict filtering (Weak as now - partial pattern success show, Strict - only full pattern find success show)
|
|
|
|
|
mdoubson
Senior Member
Joined: 17 November 2008 Status: Offline Points: 1705 |
Post Options
Thanks(0)
Quote Reply
Posted: 27 November 2009 at 1:58pm |
|
Please try now (only Strict case used)
demo:
and for Activex users:
|
|
|
|
|
mdoubson
Senior Member
Joined: 17 November 2008 Status: Offline Points: 1705 |
Post Options
Thanks(0)
Quote Reply
Posted: 27 November 2009 at 5:00pm |
|
Updated Activex supported setting - ReportControl.FilterSeparatorStrict = True (default = False - old weak ("OR") case), True - strict ("AND") case
|
|
|
|
|
Aaron
Senior Member
Joined: 29 January 2008 Status: Offline Points: 2192 |
Post Options
Thanks(0)
Quote Reply
Posted: 28 November 2009 at 2:06am |
|
Hi Mark,
I can't register ocx, it says: Thank you for using Beta...
So you improved filtering? I'm glad you did because if you filter (in my sample "Section 1" it will filter also all other items containing "1" like SuperMario mentioned and that's why it showed also "Section 3" because the "1" in other item (Date) contained a "1".
So I'm curious what you added to prevent this.
Thanks for checking this.
|
|
|
Product: Xtreme SuitePro (ActiveX) version 15.0.2
Platform: Windows XP (32bit) - SP 2 Language: Visual Basic 6.0 Zero replies is not an option.... |
|
|
|
|
Fabian
Senior Member
Joined: 22 November 2004 Location: Switzerland Status: Offline Points: 336 |
Post Options
Thanks(0)
Quote Reply
Posted: 28 November 2009 at 2:40am |
|
Hi Aaron
I mentioned this in a support ticket some years ago. What I would need is simply a property like .FilterSeparator=, so I can set it e.g. to , Then if you filter for Section 1 will find only Section 1 or Section,1 will find all occurences of Section and 1
|
|
|
Product: Xtreme SuitePro (ActiveX) version 16.2.3
Platform: Windows 7 (32bit) Language: Visual Basic 6.0 / SP6 |
|
|
|
|
mdoubson
Senior Member
Joined: 17 November 2008 Status: Offline Points: 1705 |
Post Options
Thanks(0)
Quote Reply
Posted: 28 November 2009 at 10:04am |
|
Please try again. I updated beta expiration date. Default (weak mode) filter text separators are " " and "\t"; strict mode - only "\t";
|
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
![RSS Feed - [QUESTION] FilterText support mix chars & numbers](forum_images/rss.png "RSS Feed: [QUESTION] FilterText support mix chars & numbers")
Topic Options