Add and configure Update 1-M Job Properties

The Update 1-M Job Properties step allows you to create records and view and edit the properties configured in the step for the latest record in a job's one-to-many properties table.

When the step is run, the properties configured in the step appear in the job tile. If help text is configured for the step, it appears at the bottom of the job tile. Default or current values appear in a text box below each property that can be updated.

When the step is run, the following actions can be performed:

• The configured properties can be viewed or edited.
• The step can be cancelled by clicking Cancel.
• The step can be finished by clicking Proceed.

Configure the step

To configure the step, do the following:

1. Create or edit a workflow diagram to access the Step Library panel.
2. Drag Update 1-M Job Properties from the Step Library panel to a connection arrow of a step on the workflow canvas.

   Learn more about adding steps to a workflow diagram

   The Step Details panel appears.

3. Provide a name for the step in the Step Name text box.
4. Optionally, add the message you want to appear when the step is run in the User Prompt text box.

   You can also use the following example to display a dynamic value using ArcGIS Arcade expressions:

   
   'This job is currently assigned to ' + jobOwner($job) + '.'

5. Choose one of the following options for the Mode setting:
   • Create New—Create a record for the properties configured in the step.
   • Edit—Edit the properties configured in the step for the last created record.

     Note:

     If no record exists, a record is created for the properties configured in the step.

   • View—View the properties configured in the step for the last created record.

     Note:

     If no record exists, the step fails.

6. In the Arguments section, type the table name and field name of the property you want to be updated in the Job Property text box using the following syntax:

   tablename.fieldname

   Note:

   The table names of extended properties tables can be found on the job template's Extended Properties tab.

7. Optionally, click the Show Default Value button to define the default value and visibility settings for the property when the step is run.
   1. Choose one of the following options:
      • Value—Provide a static value.
      • Arcade Expression—Provide a dynamic value using an Arcade expression.
   2. Provide a default value for the property in the Value or Arcade Expression text box.
   3. Check the Visible check box to allow the value to be changed when the step is run.

   Caution:

   If a default value is not provided and the Visible check box is not checked for a property, the property's value is deleted when the step is run.

8. Optionally, click Add New Job Property and repeat steps 6 and 7 to add more properties.

   Note:

   To delete a job property, hover over it and click the Delete Property button .

9. Optionally, hover over a property, click the Reorder Property button , and drag it to the desired location to reorder the properties.
10. Click the Options tab.
11. Configure Step Options as necessary.
    • Manual—Run the step manually.
      • Optional—Allow the step to be finished without being run.
    • Automatic—Run the step as soon as it becomes active.

      Note:

      If your workflow diagram is configured to automatically run a sequence of steps that includes the Evaluate Data Quality or the Run GP Service step, steps that attempt to run after the user token that started the sequence of steps expires will not run automatically. You must have a license for the ArcGIS Workflow Manager Server Advanced role to continue running the additional automated steps without manual intervention.

    • Run on a Schedule—Run the step according to a schedule you set.

      Learn more about scheduling options

12. Optionally, check the Enabled check box in the Step Commenting section to allow a user to add a comment when the step is run.
13. Optionally, if you enabled step commenting, check the Required check box in the Step Commenting section to require a comment.
14. Optionally, provide help text for the step in the Step Help text box.

    You can also use the following example to display a dynamic value using ArcGIS Arcade expressions:

    
    'For further assistance, please contact ' + jobCreator($job) + '.'

15. Optionally, click the Style tab to change the shape and color of the step.
16. Optionally, click the About tab and provide a description for the step in the Step Description text box.

    Note:

    The About tab also contains the step's ID that can be used with dynamic job properties to obtain a step's output.

Return value

When the step is completed, its return value is stored to indicate the result of the step. The return value can be immediately evaluated using paths to determine the next steps in the workflow. You can also retrieve the return value for completed steps throughout the workflow using ArcGIS Arcade expressions. The following table lists the step's return values:

Return values	Description
S000001	The step completed successfully.
F000001	The step failed to complete successfully.

Output value

When the step is completed, its output value is stored and can be used to determine the path the workflow follows or be used as inputs for other steps throughout the workflow. The following table shows the step's output value:

Output	Description	ArcGIS Arcade expression syntax
<ExtendedPropertyRecordId>	Returns the ID of the extended property table record that was created, viewed, or edited.	jobOutputValue($job, '<step_id>')