![]() |
[QUESTION] FilterText support mix chars & numbers |
Post Reply ![]() |
Author | |
Aaron ![]() Senior Member ![]() Joined: 29 January 2008 Status: Offline Points: 2192 |
![]() ![]() ![]() ![]() ![]() Posted: 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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
Hi Mark,
I thought so, because all items that contains "Section" are filtered.
Too bad, now I have to do my own filtering
![]() 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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
Please try now (only Strict case used)
demo:
and for Activex users:
|
|
![]() |
|
mdoubson ![]() Senior Member ![]() ![]() Joined: 17 November 2008 Status: Offline Points: 1705 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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 |