Got it. Thank you for clarifying. @tolstoshev This is what mine is looking like. I updated the URL, the role name, and where the board name. Do I need to update the board number underneath the board name? I don't even know if board numbers are a thing, but something is telling me to ask! <#assign roles = restadmin("/users/id/" + user.id?c + "/roles").roles.role> <#assign roleSize = roles?size> <#if (roleSize > 1) > <#list roles as role> <#assign roleName = role.name?trim /> <#if roleName == "ServiceMax Employee"> <#if config.getString("phase", "prod") == "stage"> <#assign board='789' /> <#else> <#assign board='Work_Planning_and_Scheduling_Ideas' /> </#if> Idea Name, Submitter email, Voter email, Status, Day, Year, IdeaID, Label, URL <#assign idea_obj = restadmin("2.0","/search?q=" + "Select * FROM messages WHERE board.id = '${board}' AND conversation.style='idea' AND depth=0"?url) /> <#list idea_obj.data.items as fubar> <#assign authoremail = restadmin("2.0","/search?q=" + "Select * FROM users WHERE id='${fubar.author.id}'"?url) /> <#assign voters = restadmin("2.0","/search?q="+fubar.kudos.query?url) /> <#list voters.data.items as uservotes> <#assign emailaddy = restadmin("2.0","/search?q=" + "Select * FROM users WHERE id='${uservotes.user.id}'"?url) /> <#assign labels = restadmin("2.0","/search?q=" + "Select * FROM labels WHERE messages.id = '${fubar.id}'"?url) /> <#assign firstlabel = "missing label"> <#attempt> <#assign firstlabel = labels.data.items[0].text /> <#recover> </#attempt> <br>${fubar.subject},${authoremail.data.items[0].email},${emailaddy.data.items[0].email},${fubar.status.key},${fubar.post_time?date},${fubar.id},${firstlabel},http://community.servicemax.com${fubar.view_href} </#list> </#list> </#if> </#list> </#if>
... View more
