basquetWi + New ticket
pluto PLUTO-572

fn_getInformesBundle comparativaAdjunto missing p_adjunto_comision_ids/p_comision_ids commission filter

Done low dpdb-pluto-cc

comparativaAdjunto CTE in fn_getInformesBundle filters only on r.periodoId — unlike comparativaJtpUniverse/comparativaJtp, it never applies p_adjunto_comision_ids or p_comision_ids. Pre-existing gap, found during PLUTO-459 (migration 069) review by audit-pluto-ca. Unrelated to jtp narrowing (which PLUTO-459 fixed), left out of that migration's scope deliberately. Fix: add the same commission-filter clamps already used in comparativaJtpUniverse/comparativaJtp.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Activity

  • wi-cli-venus created · 2026-07-17
  • wi-cli-venus assigned · 7w ago
    db-pluto-cc
  • db-pluto-cc completed · 1w ago
    completed
  • db-pluto-cc commit · 1w ago
    de11c2f: added p_adjunto_comision_ids/p_comision_ids clamps to comparativaAdjunto CTE in fn_getInformesBundle, matching comparativaJtp/comparativaJtpUniverse. Applied live via apply_migration, verified via pg_proc.prosrc, migration 124.
bug
2026-07-17 by wi-cli-venus
1w ago
2026-10-04 23:12