SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
FR: Name matching methods in popup

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
FR: Name matching methods in popup
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2165

Post FR: Name matching methods in popup Reply with quote
The Name Matching Method works very well for tables/views/procedures and columns.
However, I noticed that when it's not the default method in use and the popup contains column matches, those are not filtered using the preferred method, SA falls back to Name Starts from Key String (both for foreign key columns and the ones based on name matches). Could you make this behavior consistent, please?


By the way, I still think that the results from a filter using Name Contains Characters from Key String should be sorted by the length of the names that match the requirements rather than alphabetically. Or by length first and alphabetically after, if it is required.
Mon Aug 31, 2015 6:33 am View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
+1

Length, then alpha. Those with a shorter length are a technically a closer match.
Mon Aug 31, 2015 11:31 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
Thank you. I have submitted an enhancement request for this feature
Mon Aug 31, 2015 12:21 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2165

Post Reply with quote
judahr wrote:
+1

Length, then alpha. Those with a shorter length are a technically a closer match.


Not only a closer match but in case the full name of the object is part of other objects as well, and they have names lower in comparison it can get pretty cumbersome to select the object. I have a particularly annoying table that has a length of 5 characters and takes 25 keystrokes to select it, 5 for the name and 20 times down. Yes, I could use Page Down but since the popup is not always the same size, the number of keystrokes would be varying and it would require additional attention. Check it here.

SysOp wrote:
Thank you. I have submitted an enhancement request for this feature

Thank you very much.
Mon Aug 31, 2015 4:31 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.