Skip to content

Instantly share code, notes, and snippets.

Avatar

Daniel Smith daniel0397

View GitHub Profile
View Remove stage
UPDATE `QED_1_CaseVersions` SET `StageId` = "entities" WHERE `StageId` = "filedaccounts";
UPDATE `QED_1_CaseVersions` SET `StageId` = "entities" WHERE `StageId` = "bankverification";
UPDATE `QED_1_CaseVersions` SET `StageId` = "entities" WHERE `StageId` = "securemeet";
UPDATE `QED_1_CaseVersions` SET `StageId` = "entities" WHERE `StageId` = "idu";
DELETE FROM `QED_Workflow_Stage` WHERE `StageId` = "filedaccounts";
DELETE FROM `QED_Workflow_Stage` WHERE `StageId` = "bankverification";
DELETE FROM `QED_Workflow_Stage` WHERE `StageId` = "securemeet";
DELETE FROM `QED_Workflow_Stage` WHERE `StageId` = "idu";
DELETE FROM `QED_1_CaseVersion_Stage` WHERE `StageId` = "filedaccounts";
DELETE FROM `QED_1_CaseVersion_Stage` WHERE `StageId` = "bankverification";
View sql for adding stage
INSERT INTO `justcashflow`.`QED_Workflow_Stage`
VALUES ('idu','PEPs & Sanctions',7,0,'moduleIDU',1);
INSERT INTO `demo1`.`QED_Workflow_Stage`
VALUES ('idu','PEPs & Sanctions',7,0,'moduleIDU',1);
View AppSimpleTaskSpec
Model->getAuditMessage(){
AppSimpleTaskPK
SimpleTaskPK
ProductPK
Complete
TaskText
DateComplete
SimpleTaskStatusPK
}
View ProductSpec
Model->getAuditMessage(){
EBSLoanPK
CasePK
ProductSubTypePK
LoanReference
PaymentReference
NextStageDue
AdvisorPK
StagePK
MortgageSourcePK
You can’t perform that action at this time.