ssc-spc-ccoe-cei / azure-guardrails-solution-accelerator

This implementation automates reporting to verify compliance with GC Cloud Guardrails. SSC and TBS review the results. Cette mise en œuvre automatise la production de rapports afin de vérifier la conformité aux mesures de sécurité infonuagique du GC. SPC et SCT examinent les résultats.
Other
11 stars 5 forks source link

[BugFix] - Error in the Workbook for guardrails 1,2,3,4,5,6,7 #237

Closed singhgss closed 1 month ago

singhgss commented 1 month ago

Overview/Summary

This Pull Request fixes errors related to the workbook for guardrails 1, 2, 3, 4, 5, 6, and 7, but not for guardrails 8 and 9. Specifically, it addresses a type mismatch issue in the iff() function where the @then data type (real) did not match the @else data type (string). This PR ensures the correct data type is used for both the @then and @else conditions to avoid the workbook error.

This PR fixes/adds/changes/removes

Fixes #222

  1. Fixes the data type mismatch in the iff() function in the workbook for guardrails 1-7.
  2. Ensures the consistent use of data types across all workbook calculations.

Breaking Changes

None

Testing Evidence

Testing was performed by executing the workbook for all guardrails. Guardrails 1-7 now pass without error, and the correct values are displayed. Screenshots are provided below: image

As part of this Pull Request I have