Difference between revisions of "Something Underscore"
From TekiWiki
| Line 1: | Line 1: | ||
| − | + | Searching for objects in [[Application Designer]] can be easier with a few tricks: | |
1: Create Descriptions - using keywords in descriptions can allow groups of objects be found relatively quickly. | 1: Create Descriptions - using keywords in descriptions can allow groups of objects be found relatively quickly. | ||
| − | 2: | + | 2: You can use SQL "like" wild cards |
| − | If using [[Microsoft SQL Server]] and trying to find A_, you can search using | + | Application Designer automatically puts "%" after your search (to find Begins With"), but you can add a percentage at the beginning to imitate "contains". |
| + | |||
| + | 3: Finding objects that start "something underscore" | ||
| + | |||
| + | The use of "like" has a disadvantage - underscore is a SQL "like" wild card. This can be awkward as many naming conventions are something underscore. | ||
| + | If using [[Microsoft SQL Server]] and trying to find A_, you can search using: | ||
<pre> | <pre> | ||
A[_] | A[_] | ||
Revision as of 07:42, 21 November 2016
Searching for objects in Application Designer can be easier with a few tricks:
1: Create Descriptions - using keywords in descriptions can allow groups of objects be found relatively quickly.
2: You can use SQL "like" wild cards
Application Designer automatically puts "%" after your search (to find Begins With"), but you can add a percentage at the beginning to imitate "contains".
3: Finding objects that start "something underscore"
The use of "like" has a disadvantage - underscore is a SQL "like" wild card. This can be awkward as many naming conventions are something underscore. If using Microsoft SQL Server and trying to find A_, you can search using:
A[_]
Within the web front end you can use:
A\_
