Add and configure Update 1-M Job Properties

The Update 1-M Job Properties step allows you to create records and show 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 canceled by clicking Cancel.
  • The step can be finished by clicking Proceed.

Configure the step

Do the following to configure the step:

  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.

    The Step Details panel appears.

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

    If the user prompt contains plain text and Arcade expressions, format the text as follows:

    'This job is currently assigned to ' + JobOwner($Job) + '.'
    Tip:

    Click This input supports Arcade Expressions This input supports Arcade expressions and choose an ArcGIS Arcade expression to add it to its associated text box.

  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—Show 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 Show Default Value Show Default Value 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 the Visible check box is not checked, a default value must be provided.

    4. Check the Editable check box to allow the value to be edited when the step is run.
      Note:

      If the Visible check box is not checked, the Editable check box is unavailable.

    Note:

    Checking the Visible or Editable check box in the step overrides the Visible or Editable check box specification in the extended properties table.

  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 Delete Property Delete Property.

  9. Optionally, hover over a property, click Reorder Property Reorder Property, 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 more 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 to the step 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 to be added to the step before it can be completed.
  14. Optionally, provide help text for the step in the Step Help text box.

    You can also use ArcGIS Arcade expressions to provide a dynamic value for the step help. If the step help contains plain text and Arcade expressions, you must format the text as follows:

    
    '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.
    Tip:

    The About tab also contains the step's ID that can be used with dynamic job properties to obtain a step's output. Click Copy Step ID Copy Step ID to copy the step ID to your clipboard.

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 valueDescription

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 can be used as inputs for other steps throughout the workflow. The following table lists the step's output value:

OutputDescription

<ExtendedPropertyRecordId>

Returns the ID of the extended property table record that was created, shown, or edited.

Related topics