Last week, I found out that the APEX search bar is more powerful than I knew. These features were introduced in 5.0:
- If you go to the App Builder home page, the search will be across all applications. In 4.x, you had to clear your session (log out and back in) if you’d been working in an application to do this.
- In 5.0, you can “jump” to a specific page by searching for the application number, followed by a colon, and the page number. So “7220:200” takes you to page 200 in application 7220, regardless of what application you’re working in.
- Similarly, searching for “7220:s” takes you to the Shared Components page for the application. This isn’t one I use often, but it’s there.
Last week, however, I found out about one other. I’m not sure if it was introduced in 5.0, or if it’s an older feature which I’d never heard of, but it’s at least that old:
- If you prefix your search with “regexp:”, the search string will be treated as a regular expression.
The reason this came up is because I wanted to search for a table name, but not any tables whose name included that name. For example, in P-Track the main projects table is “EBA_PROJ_STATUS”, and most of the other tables start with that, such as “EBA_PROJ_STATUS_MS”. If you want to search for just the main table, you’re out of luck–or so I thought. It turns out, though, that you can search for “regexp:\Weba_proj_status\W” and get exactly what you need.
The only issue I have, and I understand why it probably isn’t feasible to fix, is that doing a regular expression search doesn’t highlight the matched string. But that’s a minor issue that I’m willing to put up with.