/Upload Work Skill ConditionsPUT

Upload Work Skill Conditions

Replace all work skill conditions. Rows are grouped by Internal ID — one row per value, making multi-value conditions easy to manage.

1 — Excel file

Rows grouped by __all__.

Submit to OFS

Upload an Excel file.

Fields

internalIdrequiredinteger

Repeat the same number on all rows belonging to the same skill condition entry. Referenced by dependency rows.

skillLabelstring

Fill only on the first row of each group. The work skill this condition applies to.

requiredLevelinteger

Fill only on the first row. Minimum skill level (0–100).

preferableLevelinteger

Fill only on the first row. Preferred skill level (1–100).

condFieldstring

Activity property to test (e.g. aworktype, status). Leave blank on dependency-only rows.

condFunctionenum

How to compare the field. Rows with same Field+Function within a group are merged into one valueList.

innotIncontainsdContainisNullisNotNull><>=<=startsWithdStartWith
condValuestring

One value per row. For 'in'/'notIn' add a new row with the same Field+Function for each extra value. Leave blank for isNull/isNotNull.

depTypeenum

Fill on dependency rows. 'selected' = the referenced condition must apply; 'notSelected' = must not apply.

selectednotSelected
depInternalIdinteger

Internal ID of the condition this row depends on. One dependency per row.

Notes

  • ·⚠ PUT replaces ALL existing work skill conditions in OFS. Include every condition you want to keep.
  • ·Group rows by internalId. Fill skillLabel/requiredLevel/preferableLevel only on the first row of each group.
  • ·One row per value: to use 'in [3, 4, 5]' add 3 rows all with same internalId, condField=aworktype, condFunction=in, condValue=3/4/5.
  • ·isNull / isNotNull: leave condValue blank.
  • ·Dependencies: add a row with the same internalId, fill depType and depInternalId, leave condField blank.