considering the Sorting functionality...
1) create a new metadata field to save the Author Full Name. for example : xAuthorFullName
2) In profile Rules use derived filed and getValueForSpecifiedUser() idoc function. Incase user can select a different Author.
- if you are not using profiles, create a global rule and add xAuthorFullName to fields and set the above configuration.
3) Create a component and override the resource include "slim_search_result_table_header_setup" and set columnsString to include the list of fields on results page
- Example: <$columnsString="dDocName,dDocTitle,xAuthorFullName"$>
4) Configure the xAuthorFullName for sorting. refer to link in leon's post.
for Classic View
override setup_special_column_row_data and modify myViewDescription row. Set Text1 and Text2(optional)
<$if row like "myViewDescription"$>
<$Text1 = "<b><$lcCaption('Author Name')$></b> <$xAuthorFullName$><$if xComments$><br><b><$lcCaption('Comments')$></b> <$xComments$><$endif$>"$>
<$Text2 = "<$your other display fields...$>"$> //can be left blank
<$RowData.myViewDescription = "<$include searchapi_result_text1$><br /><$include searchapi_result_text2$>"$>
thank you for responding!
I tried this, but it seems like this solution would actually store the names in DOCMETA, it is just causing more duplication of data in the system since we already have the data available in users table.
Also, we will have to scrub existing content to have the name in the new field.
Is there another option? I think this should be a feature in the product itself since this is very common UI requirement, to see user names instead of IDs in the searhc results or other screens.