Export PowerPoint: how to add "& public is true" to back end link filterQuery from PPT template

[Anna Maksymova]

Hi,

so I am trying to build a Template for Status Report of the Customer Project in the PowerPoint for the customer manually.

I want to update the link of the ${repeat_slide} of Risks.

CURRENT: "https://servicenow.com/distinctionFlag=related/childTable=risk_baseline/relatedTo=base/orderByColumn...

SHOULD: expand "filterQuery" with "AND public field is true".

I couldn't find any documentation on this one.

Also tried the simple Query Filter syntax of GlideRecord "risk_stateIN-5,1,2^u_public=true" and "risk_stateIN-5,1,2&u_public=true"where "^" and "&" stays for "AND".

That didn't work.

Does anybody know how to acquire "AND" in the filterQuery in PPT Template?

[Luis Ataide · Accepted solution]

Hi Anna, you need to use the HTML equivalent for ^

The easiest way is using the filter option at the Add-in, as the example below:

https://servicenow.com/distinctionFlag=related/childTable=risk_baseline/relatedTo=base/orderByColumn...

In this case the filter is risk_stateIN-5,1,2^probability=absolute

%2C is the HTML code for ,

%3D is the HTML code for =

%5 is the HTML code for ^

So, in your case it would be something like:

https://servicenow.com/distinctionFlag=related/childTable=risk_baseline/relatedTo=base/orderByColumn...

Best regards,

Luis.