Service Manager / Service Center Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

Approver list need to populate in new drop list of IM Update Incident

SOLVED
Go to Solution
Highlighted
Occasional Contributor

Approver list need to populate in new drop list of IM Update Incident

Hi All,

I have one requirement, created new dropdown list in UM Update Incident and need values to be populate which are present in approvers of that assignment group.

I did below steps, but that is not giving the result what i am looking for...

i have added below lines in probsummary table against link

field(from/source)                    File(To/Target)     Field(To/Target)
assignment.approver              Assignment            Name

Source Field                                 Target Field
Assignment.approver                  approvers

but this one is copying all the approvers list if click on fill button.

 

Can any one please suggest me here how can we make the queries in expressions and what exactly need to be added.

Thanks in advance

1 REPLY
Regular Advisor

Re: Approver list need to populate in new drop list of IM Update Incident

So, rephrased:

On an IM, you have a field, defined as a dropdown, where the dropdown list holds all Approvers from the Assignment Group (for that IM), and the user can select one name from that list.

If this is the case, and we can assume the Assignment Group is already filled in when the user opens the form to select an approver, the following will address this requirement:

  1. In FC, Queries, on display, do a select on assignment where "name=assignment in $file" - This will pull in the Assignment record into $filen (meaning $file1, $file2, etc, depending on the line this query is on).
  2. In FC, Calculations, on display, parse the approvers list in to a variable:
    $ag.approvers=approvers in $filen
  3. In FC, Calculations, on Add and Update, clear out the variable:
    cleanup($ag.approvers)
  4. The "value list" input for the dropdown for "assignment.approver" can now be set to $ag.approvers