Project

General

Profile

Actions

Feature #1580

open

Task 21031: Notas: Opción de quien podra ver las mismas

Added by Raúl Barroso about 2 months ago. Updated 14 days ago.

Status:
Internal Test: Pass
Priority:
Normal
Assignee:
Category:
-
Start date:
04/10/2026
Due date:
% Done:

0%

Estimated time:
80:00 h

Description

El asunto de las notas fue un tema que se discutió con mucho interes.
Se solicita que, en las notas públicas, se pueda indicar quiénes pueden verlas. Podría añadirse un disclaimer que advierta que la nota será visible para la oficina correspondiente.

También se propuso incluir un menú desplegable con opciones como:

  • Pública
  • Oficina
  • Sala

DevOps

Actions #1

Updated by Estefany Santiago Trinidad about 1 month ago

  • Estimated time set to 80:00 h
Actions #2

Updated by Yaira Rivera about 1 month ago

  • Status changed from Not Started to In Progress
  • Assignee set to Yaira Rivera
Actions #3

Updated by Yaira Rivera about 1 month ago

INSERT INTO catalogTypes (catalogTypeCode, catalogTypeDescription)
VALUES (76, 'noteVisibilityType')

INSERT INTO catalogValues (catalogValueCode, catalogValueDescription, catalogTypeCode, catalogTypeDescription, isLocked)
VALUES 
	(883, 'Pública', 76, 'noteVisibilityType', 1),
	(884, 'Oficina', 76, 'noteVisibilityType', 1),
	(885, 'Sala', 76, 'noteVisibilityType', 1)
	
ALTER TABLE recourseNoteDetails 
ADD 
	visibilityTypeCode int,
	visibilityTypeDescription varchar(250) 
	
ALTER TABLE	recourseNoteDetails 
ALTER COLUMN 
	visibilityTypeCode int NOT NULL
	visibilityTypeDescription varchar(250) NOT NULL
	
ALTER TABLE recourseNoteDetails 
ADD CONSTRAINT FKrecourse_note_details_visibilityType FOREIGN KEY (visibilityTypeCode) REFERENCES SUMAC_SC.dbo.catalogValues(catalogValueCode)
Actions #4

Updated by Yaira Rivera about 1 month ago

ALTER TABLE filingNoteDetails 
ADD 
	visibilityTypeCode int,
	visibilityTypeDescription varchar(250) 

UPDATE filingNoteDetails
SET visibilityTypeCode = 883, visibilityTypeDescription = 'Pública'

	
ALTER TABLE	filingNoteDetails 
ALTER COLUMN 
	visibilityTypeCode int NOT NULL
	
ALTER TABLE	filingNoteDetails 
ALTER COLUMN
	visibilityTypeDescription varchar(250) NOT NULL
	
ALTER TABLE filingNoteDetails 
ADD CONSTRAINT FKfiling_note_details_visibilityType FOREIGN KEY (visibilityTypeCode) REFERENCES SUMAC_SC.dbo.catalogValues(catalogValueCode)
Actions #5

Updated by Yaira Rivera 29 days ago

INSERT INTO catalogValues (catalogValueCode, catalogValueDescription, catalogTypeCode, catalogTypeDescription, isLocked)
VALUES (886, 'Privada', 76, 'noteVisibilityType', 1)

UPDATE recourseNoteDetails 
SET visibilityTypeCode = 886, visibilityTypeDescription = 'Privada'
WHERE isPrivate = 1

UPDATE filingNoteDetails 
SET visibilityTypeCode = 886, visibilityTypeDescription = 'Privada'
WHERE isPrivate = 1
Actions #6

Updated by Edwin X Borrero 19 days ago

  • Status changed from In Progress to Approved
Actions #7

Updated by Estefany Santiago Trinidad 18 days ago

  • Target version changed from TS | Propuesta | Jun-10-2026 to TS | Propuesta | Jun- 03-2026
Actions #8

Updated by Estefany Santiago Trinidad 14 days ago

  • Status changed from Approved to Internal Test: Pass
Actions

Also available in: Atom PDF