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: | Searching for objects in [[Application Designer]] can be easier with a few tricks: | ||
| − | 1: Create Descriptions | + | 1: Create Descriptions |
| + | Using keywords in descriptions can allow groups of objects be found relatively quickly. #FindItEasily. | ||
2: You can use SQL "like" wild cards | 2: You can use SQL "like" wild cards | ||
| Line 11: | Line 12: | ||
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. | 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: | If using [[Microsoft SQL Server]] and trying to find A_, you can search using: | ||
| + | |||
<pre> | <pre> | ||
A[_] | A[_] | ||
| Line 16: | Line 18: | ||
Within the web front end you can use: | Within the web front end you can use: | ||
| + | |||
<pre> | <pre> | ||
A\_ | A\_ | ||
Latest revision as of 07:44, 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. #FindItEasily.
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\_
