How to find the "friendly" name of a table name so that it can be located in a Table Names list
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-30-2012 01:56 PM
Hi folks
I am not sure if I am doing something wrong but I needed to do some configuration work for a bunch of tables.
For this I needed to locate the tables in Tables and Columns application. My problem is that the tables in Tables and Columns are listed according to some kind of a friendly name (or what-it-is-called). So for example we have this table for Scrum stories, called "rm_story". If this has a friendly name, it does not seem to start with either "s..." or "r..."...
Anyway what I was looking for is a more generic way to locate any table in the Tables and Columns list (without having to scan the entire list).
How can this be done?
- Labels:
-
Orchestration (ITOM)
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-30-2012 02:19 PM
Others will have their own shortcuts, but if you type "rm_story.form" in the nav filter, you'll be taken to a new, blank form for that table. At the top you'll see the label for that table.
In my instance, the label for that table is "Story".
If typing "rm_story.form" in the nav filter gives you a "The page you are looking for could not be found" message, then you likely don't have that table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-03-2012 08:02 AM
Thank you CapaJC!
So it looks like the Name is always located immediately to the right of the green "back" arrow on the single record form.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-19-2021 02:19 AM
9 years on - I don't see a green back arrow.
The back arrow is black and shows no information
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-03-2012 09:05 AM
That's right. And another place to find where table names and labels are paired up is in the sys_documentation table. This is the System Definition -> Language File module. Table entries are those with no Element value. "Table" is the table name in the database, "Label" is the label. If you have different languages active, that's where you'll see the various translations of the table label for each language.