{
  "pjud": {
    "visible": true,
    "rit": [
      "RIT Letra",
      "RIT ROL",
      "RIT AÑO"
    ],
    "court_and_tribunal": "Corte",
    "competencie": "Competencia",
    "appealCause":{
    	"court": "Corte Recursos",
    	"rol": "ROL",
    	"year": "Año"
    }
    "recipientemails": [
      "soporte@inprovider.cl"
    ]
  },
  "slaConfigWithWorkingtime": true
}

--Civil Ejecutivo

{
  "pjud": {
    "visible": true,
    "rit": [
      "RIT Letra",
      "RIT ROL",
      "RIT AÑO"
    ],
    "court_and_tribunal": "Corte",
    "competencie": "Competencia",
    "appealCause":{
    	"court": "Corte Recursos",
    	"rol": "ROL",
    	"year": "Año"
    },
    "recipientemails": [
      "soporte@inprovider.cl"
    ]
  },
  "slaConfigWithWorkingtime": true
}



INSERT INTO trackvision.stages
(id, "name", requirementtypeid, orderindex, created_at, updated_at)
VALUES(137, 'En Notificación', 102, 2, '2022-01-11 08:12:12.446', '2022-01-11 08:12:12.446');


UPDATE trackvision.stages
SET orderindex=3
WHERE id=88;
UPDATE trackvision.stages
SET orderindex=4
WHERE id=89;
UPDATE trackvision.stages
SET "orderindex=5
WHERE id=90;
UPDATE trackvision.stages
SET orderindex=6
WHERE id=91;
UPDATE trackvision.stages
SET orderindex=7
WHERE id=92;





INSERT INTO trackvision.statuses
(id, "name", "assignment", isslastart, isslaend, orderindex, color, domainid, internalid, created_at, updated_at, stageid, insla)
VALUES(522, 'En Notificación', false, false, false, 1.2, 'info', 22062025, 216, '2022-01-11 08:12:12.446', '2022-01-11 08:12:12.446', 137, true);


INSERT INTO trackvision.filters
(id, domainid, "name", workflowid, requirementtypeid, statusid, creator, originalcreator, "owner", area, subscribed, ownerchild, creatorchild)
VALUES(1038, 22062025, 'Juicio Civil Ejecutivo | En Notificación | Creador', 300025, 102, 522, true, false, false, false, false, false, false);
INSERT INTO trackvision.filters
(id, domainid, "name", workflowid, requirementtypeid, statusid, creator, originalcreator, "owner", area, subscribed, ownerchild, creatorchild)
VALUES(1039, 22062025, 'Juicio Civil Ejecutivo | En Notificación | Dueño', 300025, 102, 522, false, false, true, false, false, false, false);
INSERT INTO trackvision.filters
(id, domainid, "name", workflowid, requirementtypeid, statusid, creator, originalcreator, "owner", area, subscribed, ownerchild, creatorchild)
VALUES(1040, 22062025, 'Juicio Civil Ejecutivo | En Notificación | Todos', 300025, 102, 522, false, false, false, false, false, false, false);
INSERT INTO trackvision.filters
(id, domainid, "name", workflowid, requirementtypeid, statusid, creator, originalcreator, "owner", area, subscribed, ownerchild, creatorchild)
VALUES(1041, 22062025, 'Juicio Civil Ejecutivo | En Notificación | Colaborador', 300025, 102, 522, false, false, false, false, true, false, false);

INSERT INTO trackvision.actions
(id, "name", description, statusid, selfassignment, dontreassign, changecreator, requirenote, startsla, endsla, message, orderindex, "template", relatedactionsids, "type", model)
VALUES(578, 'En Notificación', 'Pasa a estado En Notificación', 522, false, false, false, false, false, false, NULL, NULL, false, '{}', 'change_status', NULL);

INSERT INTO common.customfieldsgroups
(id, "name", parentid, active, locations_name, "module", statusid)
VALUES(196, 'En Notificación', NULL, true, NULL, NULL, 522);

INSERT INTO common.customfields
(id, requirementtypeid, "name", orderindex, "type", required, "values", alias, hint, "cache", suggest, warning, allowedit, actionid, regularexpression, validationmessage, showwhenediting, sla, directorytypeformid, hidden, defaultvalue, loadlastvalue, mailalert, dinamicstatuses, customfilter, category, formula, format, disabled, readonly, model, showincreate, action_redirect)
VALUES(2190, 102, 'Observaciones_ennotificacion', 83.0, 7, false, NULL, 'Observaciones', NULL, false, false, NULL, false, NULL, NULL, NULL, true, false, NULL, false, NULL, NULL, false, false, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO common.customfieldsgroupsdetails
(id, customfieldsgroupid, customfieldid, hidden)
VALUES(1187, 196, 2190, NULL);

INSERT INTO trackvision.visibility
(id, visibilitygroupid, "name", orderindex, count, defaultview)
VALUES(300267, 58, 'En Notificación', 2.1, true, false);

INSERT INTO trackvision.visibilityprofiles
(id, visibilityid, profileid, filterid)
VALUES(302055, 300189, 1030, 1038);
INSERT INTO trackvision.visibilityprofiles
(id, visibilityid, profileid, filterid)
VALUES(302054, 300267, 1030, 1038);
INSERT INTO trackvision.visibilityprofiles
(id, visibilityid, profileid, filterid)
VALUES(302053, 300189, 1030, 1041);
INSERT INTO trackvision.visibilityprofiles
(id, visibilityid, profileid, filterid)
VALUES(302052, 300267, 1030, 1041);
INSERT INTO trackvision.visibilityprofiles
(id, visibilityid, profileid, filterid)
VALUES(302051, 300189, 1030, 1039);
INSERT INTO trackvision.visibilityprofiles
(id, visibilityid, profileid, filterid)
VALUES(302050, 300267, 1030, 1039);


INSERT INTO trackvision.visibilityprofiles
(id, visibilityid, profileid, filterid)
VALUES(302057, 300189, 1031, 1040);
INSERT INTO trackvision.visibilityprofiles
(id, visibilityid, profileid, filterid)
VALUES(302056, 300267, 1031, 1040);

INSERT INTO trackvision.visibilityprofiles
(id, visibilityid, profileid, filterid)
VALUES(302059, 300189, 1073, 1040);
INSERT INTO trackvision.visibilityprofiles
(id, visibilityid, profileid, filterid)
VALUES(302058, 300267, 1073, 1040);

INSERT INTO trackvision.actionsprofiles
(id, actionid, profileid, filterid)
VALUES(302625, 578, 1030, 840);
INSERT INTO trackvision.actionsprofiles
(id, actionid, profileid, filterid)
VALUES(302624, 578, 1030, 839);
INSERT INTO trackvision.actionsprofiles
(id, actionid, profileid, filterid)
VALUES(302623, 578, 1030, 838);
INSERT INTO trackvision.actionsprofiles
(id, actionid, profileid, filterid)
VALUES(302622, 578, 1030, 826);
INSERT INTO trackvision.actionsprofiles
(id, actionid, profileid, filterid)
VALUES(302621, 578, 1030, 836);

INSERT INTO trackvision.actionsprofiles
(id, actionid, profileid, filterid)
VALUES(302630, 578, 1031, 849);
INSERT INTO trackvision.actionsprofiles
(id, actionid, profileid, filterid)
VALUES(302629, 578, 1031, 848);
INSERT INTO trackvision.actionsprofiles
(id, actionid, profileid, filterid)
VALUES(302628, 578, 1031, 847);
INSERT INTO trackvision.actionsprofiles
(id, actionid, profileid, filterid)
VALUES(302627, 578, 1031, 844);
INSERT INTO trackvision.actionsprofiles
(id, actionid, profileid, filterid)
VALUES(302626, 578, 1031, 845);

INSERT INTO trackvision.actionsprofiles
(id, actionid, profileid, filterid)
VALUES(302635, 578, 1073, 849);
INSERT INTO trackvision.actionsprofiles
(id, actionid, profileid, filterid)
VALUES(302634, 578, 1073, 848);
INSERT INTO trackvision.actionsprofiles
(id, actionid, profileid, filterid)
VALUES(302633, 578, 1073, 847);
INSERT INTO trackvision.actionsprofiles
(id, actionid, profileid, filterid)
VALUES(302632, 578, 1073, 844);
INSERT INTO trackvision.actionsprofiles
(id, actionid, profileid, filterid)
VALUES(302631, 578, 1073, 845);

//Gestion Preparatoria


INSERT INTO trackvision.stages
(id, "name", requirementtypeid, orderindex, created_at, updated_at)
VALUES(138, 'En Notificación', 108, 2, '2022-01-11 08:12:12.446', '2022-01-11 08:12:12.446');


UPDATE trackvision.stages
SET orderindex=3
WHERE id=132;
UPDATE trackvision.stages
SET "name"='Prueba', requirementtypeid=108, orderindex=4, created_at='2022-01-11 08:12:12.446', updated_at='2022-01-11 08:12:12.446'
WHERE id=133;
UPDATE trackvision.stages
set orderindex=5
WHERE id=134;
UPDATE trackvision.stages
SET orderindex=6
WHERE id=135;
UPDATE trackvision.stages
SET orderindex=7
WHERE id=136;


INSERT INTO trackvision.statuses
(id, "name", "assignment", isslastart, isslaend, orderindex, color, domainid, internalid, created_at, updated_at, stageid, insla)
VALUES(523, 'En Notificación', false, false, false, 1.2, 'info', 22062025, 217, '2022-01-11 08:12:12.446', '2022-01-11 08:12:12.446', 138, true);

INSERT INTO trackvision.filters
(id, domainid, "name", workflowid, requirementtypeid, statusid, creator, originalcreator, "owner", area, subscribed, ownerchild, creatorchild)
VALUES(1042, 22062025, 'Gestión Preparatoria | En Notificación | Creador', 300031, 108, 523, true, false, false, false, false, false, false);
INSERT INTO trackvision.filters
(id, domainid, "name", workflowid, requirementtypeid, statusid, creator, originalcreator, "owner", area, subscribed, ownerchild, creatorchild)
VALUES(1043, 22062025, 'Gestión Preparatoria | En Notificación | Dueño', 300031, 108, 523, false, false, true, false, false, false, false);
INSERT INTO trackvision.filters
(id, domainid, "name", workflowid, requirementtypeid, statusid, creator, originalcreator, "owner", area, subscribed, ownerchild, creatorchild)
VALUES(1044, 22062025, 'Gestión Preparatoria | En Notificación | Todos', 300031, 108, 523, false, false, false, false, false, false, false);
INSERT INTO trackvision.filters
(id, domainid, "name", workflowid, requirementtypeid, statusid, creator, originalcreator, "owner", area, subscribed, ownerchild, creatorchild)
VALUES(1045, 22062025, 'Gestión Preparatoria | En Notificación | Colaborador', 300031, 108, 523, false, false, false, false, true, false, false);

INSERT INTO trackvision.actions
(id, "name", description, statusid, selfassignment, dontreassign, changecreator, requirenote, startsla, endsla, message, orderindex, "template", relatedactionsids, "type", model)
VALUES(579, 'En Notificación', 'Pasa a estado En Notificación', 523, false, false, false, false, false, false, NULL, NULL, false, '{}', 'change_status', NULL);

INSERT INTO common.customfieldsgroups
(id, "name", parentid, active, locations_name, "module", statusid)
VALUES(197, 'En Notificación', NULL, true, NULL, NULL, 523);

INSERT INTO common.customfields
(id, requirementtypeid, "name", orderindex, "type", required, "values", alias, hint, "cache", suggest, warning, allowedit, actionid, regularexpression, validationmessage, showwhenediting, sla, directorytypeformid, hidden, defaultvalue, loadlastvalue, mailalert, dinamicstatuses, customfilter, category, formula, format, disabled, readonly, model, showincreate, action_redirect)
VALUES(2191, 108, 'Observaciones_ennotificacion_1', 84.0, 7, false, NULL, 'Observaciones', NULL, false, false, NULL, false, NULL, NULL, NULL, true, false, NULL, false, NULL, NULL, false, false, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO common.customfieldsgroupsdetails
(id, customfieldsgroupid, customfieldid, hidden)
VALUES(1188, 197, 2191, NULL);