projekt kivitendo

  # Delete saved custom variable values for configs that have been

  # marked invalid for this part.

  $query = <<SQL;

    DELETE FROM custom_variables

    WHERE (config_id IN (

        SELECT val.config_id

        FROM custom_variables_validity val

        LEFT JOIN custom_variable_configs val_cfg ON (val.config_id = val_cfg.id)

        WHERE (val_cfg.module = 'IC')

          AND (val.trans_id   = ?)))

      AND (trans_id = ?)

SQL

  do_query($form, $dbh, $query, ($form->{id}) x 2);

-- @tag: delete_invalidated_custom_variables_for_parts

-- @description: Bei Artikeln ungültig gesetzte, benutzerdefinierte Variablen löschen

-- @depends: release_3_2_0

DELETE FROM custom_variables

WHERE (config_id IN (

    SELECT id

    FROM custom_variable_configs

    WHERE module = 'IC'))

  AND EXISTS (

    SELECT val.id

    FROM custom_variables_validity val

    WHERE (val.config_id = custom_variables.config_id)

      AND (val.trans_id  = custom_variables.trans_id));