ahmednrana

SELECT * FROM CONDITION WHERE CONDITIONNUM IN  (SELECT CONDITIONNUM FROM CTRLCONDITION WHERE CTRLGROUPID IN (SELECT CTRLGROUPID FROM CTRLGROUP WHERE app = 'ECRF')); -- depends upon control Group

ahmednrana

MERGE INTO APPLICATIONAUTH TA
USING (SELECT GROUPNAME, APP, OPTIONNAME, CONDITIONNUM FROM APPLICATIONAUTH2) AS TB
ON (TA.GROUPNAME = TB.GROUPNAME AND TA.APP = TB.APP AND TA.OPTIONNAME = TB.OPTIONNAME AND TA.CONDITIONNUM = TB.CONDITIONNUM)
WHEN NOT MATCHED THEN
INSERT (APPLICATIONAUTHID, GROUPNAME, APP, OPTIONNAME, CONDITIONNUM)
VALUES (NEXTVAL FOR APPLICATIONAUTHSEQ, TB.GROUPNAME, TB.APP, TB.OPTIONNAME, TB.CONDITIONNUM);

ahmednrana

--Create Security group

INSERT INTO MAXGROUP (MAXGROUPID, GROUPNAME, DESCRIPTION, PASSWORDDURATION, PASSWORDWARNING, INDEPENDENT, AUTHALLSITES, AUTHALLGLS, AUTHALLSTOREROOMS, AUTHLABORALL, AUTHLABORCREW, AUTHLABORSELF, AUTHLABORSUPER, LANGCODE, SCTEMPLATEID, AUTHPERSONGROUP, NULLREPFAC, AUTHALLREPFACS, MAXSCHEDREPORT, DFLTAPP, PLUSPAUTHNONCUST, PLUSPAUTHALLCUST, PLUSPAUTHCUSTVND, PLUSPAUTHPERSLST, PLUSPAUTHGRPLST, PLUSPRESTRICTOPT, PMSCCREATEDATARESTRICT, PMSCSSCDATARESTRICT, EMAIL, hasld, sidenav) VALUES(NEXTVAL FOR MAXGROUPSEQ, 'ANA-C1-LHR-01','ANA-C1-LHR-01', 9999, 5, 0, 0, 0, 0, 0, 0, 0, 0, 'EN', NULL, 0, 1, 0, NULL, NULL, 0, 0, 0, 0, 0, NULL, 0, 0, NULL,0,0);

-- Add users to this group
-- The relationship from maxgroup to groupusers is groupname = :groupname

INSERT INTO GROUPUSER
(GROUPUSERID, USERID, GROUPNAME)
VALUES(NEXTVAL FOR GROUPUSERSEQ, 'MAXADMIN', 'TESTABC');

ahmednrana

  div {
       box-shadow: 0 0 0 0.5px red;
    }

ahmednrana

=NOT(ISERROR(MATCH(A2,$B$2:$B$1001,0)))

ahmednrana

docker run -v /host/directory:/container/directory -t IMAGE-NAME /bin/bash