4 of 4 people found this helpful
The reason your excel export will not work is that the Function GetSRPValue is not supported in a database query. The work around to this is to move the SRP's to a text field on the SR object. If you create a Unicode text field on the SR object then use an update block in the request workflow to populate it using the following code:
$(ForEachChild("ServiceReq#", RecId, "ServiceReqParam#", "ParameterName + ': ' + ParameterValue + '\r\n'", "CreatedDateTime ASC"))
There is an example of this on the HEAT Support site article# 12854 http://support.heatsoftware.com
It is possible to update a SRP from an SR using a quick action its a Run For Child with a Filter.
The filter is the name of the parameter you wish to update for the record you are on.
Then you run an update object action to change the Parameter Value field