We are using the built in table UD01 to populate some custom data, and when I created a searchable text field to search that table, it returns all the column headers and the default names. Is there any way to rename these Column names?
I’m assuming it would be Column Label or Label
But cannot find away to edit them.
Thanks for any help on this!
Try Extended Properties?
I don’t believe there is a way to change the Key fields, but believe you can change the other fields labels in extended properties. If you really want to go crazy, you can use a UD table off of a UD table and create all the fields you want except for the Key fields.
Create a BAQ or Quick Search to return the desired columns
Thanks everyone for the advice. I have changed ShortChar01 Label to Program Name in the Extended Properties, but when I search that table, it doesn’t return that value, still stuck on ShortChar01. Is this not what Label does? Or is it another field that dictates what column label presents when the table is searched?
Personally, I regularly create UDxx_UD tables with the UD fields that I want. I’d much rather have a field named “CustomerRef_c” than ShortChar02 when I’m creating BAQ’s, reports, dashboards, etc. It only takes a few extra minutes to create them, the overhead on the table is minimal, but the clarity that it gives for years to come is worth it.
Yes, the label field is for customizations and reports that you would build, not the out of the box ones. @SimsTrak better explained what I was referencing earlier with a UD table hanging off a UDxx table. That way, you control all of the field names and descriptions.
These column headers should pull over with a searchable text box right?
Thanks for all your advice guys
Hi @SimsTrak
So I would be fine doing this, but for some reason, when I use the searchable textbox the custom fields return empty. I have BAQ’d the table and there is data in those columns, but the search function doesn’t return any values. I have attached some screenshots.
BAQ showing data exists
Search result returning nothing in those columns
The data does show up when I put the data into the prebuilt columns, just my custom ones return empty.
Here is the search I am using currently:
I have tried replacing Key01 with program_ID_c and the search function broke.
The UD Key 1-5 fields are required but you can create your own UDs named how you want them to use.
HI Randy,
I have tried that, but the search data doesn’t return anything in those custom columns even when I have added data to them.
You may need to reference all 5 Key fields. Also I’m going to assume you’ve verified that there is a row in UD01 where Key1 matches Project.ProgramName_c.
I have referenced all 5 fields the UBAQ I’m using currently to update this table. Project.ProgrameName_c is a custom field in the Project table that I am filling with a search on the UD01 table. Does that clarify what I am trying to do? This all works as I want with the predefined fields (Key01, ShortChar01, ShortChar02, Date01, and Date02) but when I search for those, the columns don’t provide info that is useful for the user.
Why are you using a UD01 table instead of just creating the fields on the Project table?
Because these values are used in multiple tables. I figure it would be better to have the data in a table that the other tables reference instead of recreating them in multiple places.
You’re always going to have to use Key01, the rest you can use custom UDs instead of the stock included ones.
How are you related Project table to the UD01 table? What is your plan to relate UD01 to other tables?
I don’t know what the eventual use of this field or the data is, it was discussed by my leadership team and they are adamant on its existence.
I’d agree that Key01 should always exist, but there’s still the issue where the data isn’t populating in the UD columns, even when I have BAQ’d the custom columns and the data does exist, if you have seen the screenshots where the BAQ has data and the search results yield nothing in those columns
Can you post your BAQ? Maybe that’ll help explain what’s going on.
@mackenziem , I think you are going to describe exactly what you are trying to do. Literally step by step.
You are only providing us with where you are having issues and without knowing what the business requirements are and what you have already tried, we may not be able to help.
