[QUESTION] FilterText support mix chars & numbers
Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=15718
Printed Date: 29 April 2024 at 11:52am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: [QUESTION] FilterText support mix chars & numbers
Posted By: Aaron
Subject: [QUESTION] FilterText support mix chars & numbers
Date 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.... |
Replies:
Posted By: mdoubson
Date 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] ------------- Mark Doubson, Ph.D. |
Posted By: Aaron
Date 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.... |
Posted By: mdoubson
Date Posted: 27 November 2009 at 1:13pm
|
No - you suppose to see "Section 1" and "Section 10" but not "Section 3" ------------- Mark Doubson, Ph.D. |
Posted By: SuperMario
Date 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.... |
Posted By: mdoubson
Date 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 ------------- Mark Doubson, Ph.D. |
Posted By: mdoubson
Date 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) ------------- Mark Doubson, Ph.D. |
Posted By: mdoubson
Date Posted: 27 November 2009 at 1:58pm
|
Please try now (only Strict case used)
demo:
https://forum.codejock.com/uploads/DemoVersion/ReportSampleStatic.rar - https://forum.codejock.com/uploads/DemoVersion/ReportSampleStatic.rar
and for Activex users:
https://forum.codejock.com/uploads/BetaOCX/ReportControlBeta13-2-2.rar - https://forum.codejock.com/uploads/BetaOCX/ReportControlBeta13-2-2.rar ------------- Mark Doubson, Ph.D. |
Posted By: mdoubson
Date Posted: 27 November 2009 at 5:00pm
|
Updated Activex supported setting - ReportControl.FilterSeparatorStrict = True (default = False - old weak ("OR") case), True - strict ("AND") case ------------- Mark Doubson, Ph.D. |
Posted By: Aaron
Date 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.... |
Posted By: Fabian
Date 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 |
Posted By: mdoubson
Date 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"; ------------- Mark Doubson, Ph.D. |