Something Underscore

From TekiWiki
Revision as of 07:44, 21 November 2016 by WikiSysop (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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\_

Back to...

PeopleSoft - PeopleTools - Application Designer