Skip To Content

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 you run the step, you can perform the following actions:

  • Edit or view the configured properties and proceed to the next step.
  • Click Cancel to cancel the step.
  • Click Proceed to finish the step.

Configure the step

Complete these steps to configure the Update 1-M Job Properties 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 you want to appear when the step is run in the User Prompt 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.
      注意:

      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.
      注意:

      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
    注意:

    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 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.
    注意:

    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.
    注意:

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

  9. Optionally, hover over a property, click the Reorder Property button 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.
    • Run on a Schedule—Run the step according to a schedule you set.

      Learn more about scheduling options

  12. Optionally, provide help text for the step in the Step Help text box.
  13. Optionally, click the Style tab to change the shape and color of the step.
  14. Optionally, click the About tab and provide a description for the step in the Step Description text box.
    注意:

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

Return codes

When the step finishes running, it sends a return code to indicate the result of the step. The return code is evaluated, and the workflow follows all paths that match the step's return value. The following table lists the step's return codes:

Return codeDescription

Failure

The step failed to complete successfully.

Success

The step completed successfully.

Step output

When the step finishes running, its output 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 lists the step's stored outputs:

OutputDescription

<ExtendedPropertyRecordId>

The ID of the extended property table record that was created, viewed, or edited is returned.

F000001

The step failed to complete successfully.

関連トピック


このトピックの内容
  1. Configure the step
  2. Return codes
  3. Step output