Help with Scheduled Report-Entered by ID to show Entered By Name

[CBuckwal]

I have a report to show scheduled report details. I’m trying to convert the text mode from Scheduled Report-Entered by ID to show the user name, rather than ID. The original text mode is below. I’ve tried various combinations and haven’t been successful yet. I looked through the API for Scheduled Report field details, but didn’t see or missed anything that I could use to connect to User to get the ID to name connection. Any help with this is greatly appreciated. Thanks

linkedname=scheduledReport

namekey=view.relatedcolumn

namekeyargkey.0=scheduledReport

namekeyargkey.1=enteredByID

tile.name=component.scheduledreports

valuefield=scheduledReportsEnteredByID

valueformat=HTML

viewalias=scheduledReport:enteredByID

[TerryHy]

Have you tried this…? In the places where enteredByID is indicated, switch the “ID” portion to :name

linkedname=scheduledReport

namekey=view.relatedcolumn

namekeyargkey.0=scheduledReport

namekeyargkey.1=enteredBy:name

tile.name=component.scheduledreports

valuefield=scheduledReportsEnteredBy:name

valueformat=HTML

viewalias=scheduledReport:enteredBy:name

[CBuckwal]

Thanks. I tried that and I only see bullet points that would appear in front of the user ID and blank space instead of user name. 

[TerryHy]

I just tried it out myself and that is weird - I am getting the same thing as you...a bullet point with blank space. 

[skyehansen]

hi, 

I'll give you a few more details on using the API:

* Go to the section of the API for REPORT.

* Look in the COLLECTIONS tab.

* Note that "scheduled reports" is one of the collections -- this should make sense, since you can set up more than one scheduled delivery of a report.

* Therefore, even though you're able to access SOME information just through the standard view, you should know or understand that you can't necessarily dive deeper into the information through "normal channels" -- you'd need to use a collections statement. If you click on the scheduled reports listing, you'll go to that section and be able to see what you can tap into from there, but below is some sample code you might be able to use to get what you need.

displayname=Scheduled Report Info
listdelimiter=<p>
listmethod=nested(scheduledReports).lists
textmode=true
type=iterate
valueexpression={enteredBy}.{name}
valueformat=HTML

* additional bonus bulletpoint: every time I see a "tile.name" in a blob of text, I automatically give up editing it any further. Those tiles are usually shortcuts that workfront has provided in the past, and aren't satisfyingly editable.

[CBuckwal]

Thanks for the suggestions and collections statement information. I didn't have any luck with the sample code you provided or with any of my variations. As you mentioned, due to the the tile.name text, there may not be a solution for this. 

[skyehansen]

That's a bit weird, as it definitely worked on my side. You might consider sharing your code and variations so other users can help you troubleshoot, or contact Support if you are an authorized service contact, as they can also help.