How to amend back end link from PPT template (Export to PowerPoint for SPM plugin)

[PaulaaO]

Hi Community,

On the back of my recent post on how to create a new PowerPoint template which could be used to export a project status report (Has anybody tried to create a custom PowerPoint te... - Page 3 - ServiceNow Community), I have a follow up question which is a bit more specific - really hope I could get some input/advice on this.

I will be attaching the default PPT template file which comes with the plugin, in case it helps.

On the Risks (top 5) slide, OOTB the system displays top 5 risk records based on Risk value field (which orders the records from 1-High to 3 – Low).

We don't use this field in my organisation, because we have a custom one called Current Risk Score which can take values between 1 and 25.

The significant risk records are those with the highest score (25, 20, etc.). therefore top 5 risks in our case should be those records with highest values from Current Risk Score field.

I am interested to find out whether there is a way to tweak the link behind Short Description field column (it's the component which drives what record gets displayed from my analysis), in order to instruct the system to order the records from highest to smallest based on the Current Risk Score and not the other way round which is currently doing.

I have updated the link behind Short Description column so the system checks the Current Risk Score values and not the Risk Value ones (as below), but unsure if possible to tweak it further, to order the records from highest to lowest. 

Can it be done or is this as far as it can go in terms of customisation? Any alternative solutions you could suggest?
-----
https://servicenow.com/distinctionFlag=related/childTable=risk_baseline/relatedTo=base/orderByColumn...

----

Many thanks!!

Paula

[Nootan Bhat]

Thanks for the info.

[M_48]

Hi PaulaaO,

I hope you're doing well!

I came across your message about editing the link syntax for the PowerPoint templates, specifically the one like this:

https://servicenow.com/distinctionFlag=related/childTable=risk_baseline/relatedTo=base/orderByColumn... u_current_risk_score/orderByDesc=true/filterQuery=risk_stateIN-5,1,2/maximumRows=5

Would you happen to have more information on how this syntax works and what's expected in each part? I haven’t been able to find clear documentation, and I’m not sure how it's processed.

Also, I wanted to ask if you've ever scripted the value of a field used in a PPT template. I’m trying to populate the creation date of the generated PowerPoint. We used to use Office templates before, and there it was easy to define a field and set its value via script. But with the OOTB solution, I don’t see where or how we can inject scripted values.

From what I've seen in the community and the platform, you’ve asked some of the most insightful questions on the topic, so I figured you might have figured it out or could point me in the right direction.

Thanks in advance for any help you can provide!