Hello,
I have one of a pair of actions in the survey table that’s driving me nuts… Hoping someone can help out…
Action 1
Data: set the values of columns in this row
Name: AMEND survey_asset_id and UPDATE survey_asset_amended (ROW)
I’m having difficulty with Action 1
It works fine when I only have one column [survey_asset_amended] in the action.
The problem is that when I add the second column ([survey_asset_id]) to the action it runs without error but does not appear to execute the expression and populate the data…?
[survey_asset_id] expression: [survey_asset_id] - [_THISROW].[assets_to_abort]
[survey_asset_id] & [assets_to_abort] are both EnumList type Ref columns to the asset table.
I’ve tested the above expression in a VC where it works as expected.
Also, the form that feeds [assets_to_abort] is in a survey table slice called Review Slice which is set to “all columns”
Action 2
Data: execute an action on a set of rows
Name: AMEND survey_asset_id and UPDATE survey_asset_amended (ROWS)
SELECT(
survey[id],
AND(
[lcs] = [_THISROW].[lcs],
[select_cabinet_to_survey] = [_THISROW].[select_cabinet_to_survey],
[_rownumber] >=
MIN(
SELECT(
survey[_RowNumber],
AND(
[lcs] = [_THISROW].[lcs],
[select_cabinet_to_survey] = [_THISROW].[select_cabinet_to_survey],
[select_asset_type] = [_THISROW].[select_asset_type],
[sub_asset] = [_THISROW].[sub_asset],
[survey_number] = [_THISROW].[survey_number],
NOT([survey_status] = "Aborted")
))),
ISNOTBLANK(
INTERSECT(
[survey_asset_id], [_THISROW].[assets_to_abort]
)),
NOT([survey_status] = "Aborted")
)
)
Thanks in advance…
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |