what is the Demand field 'approval_set'?

[Tracy Davis]

There is a field on the demand table - 'approval_set'. I'm trying to confirm if this is an OOB field? If it is, is it populated for you? and if so, what is approval set?

I'm ultimately trying to find a field that holds the approval date for the demand (not the state, the actual date the demand was approved).

I tried looking in my dev instance but doesn't look like PPM/Demand is available to activate there.

Thank you!

[Jim Coyne]

It is indeed an OOB field, defined on the Task table.  It is a Date/Time field, populated by the "Stamp Approvals" Business Rule, which runs when the Approval field changes.

Here's the script:

if (current.approval == 'approved' || current.approval == 'rejected') {
    current.approval_set = nowDateTime();
} else {
    current.approval_set.setValue('');
}

You should be able to install the Project/Demand apps in your dev instance by activating the "Project Portfolio Suite with Financials" plugin.

[Tracy Davis]

Thank you. So it is a Date/time stamp of the approval then correct?

I don't see project portfolio suite listed as a plugin on my dev instance. I'll contact SN about that.

[Tracy Davis]

Thank you - got the plug in enabled in dev instance. Looks like approval set does not populate for Demands since it moves to an approval state but there isn't an approval task associated with demands, so even OOB the field doesn't get populated for Demands.

[Jim Coyne · Accepted solution]

Played with it a bit and indeed, "Approval set" is not used in the Demand app OOB.  If you want to use it, you could setup a new Business Rule on the Demand table that would timestamp the Demand record when State is set to Approved like so:

The script would be:

current.approval_set = gs.nowGlideDateTime();