INSERT INTO "bizrule" ("ruleid", "version", "rulegroupid", "rulename", "ruleowner", "orgcontext", "ruledescription", "rulepriority", "effectivedate", "expirydate", "modifiedon", "modifiedby", "enabled", "toggletype", "debug", "ruletype", "link", "ruletemplateid", "ruledefinition", "ismultiple", "openswith", "modeldata", "xmlschema", "psl_id", "doc_id") VALUES
	('080027e2-1180-a1ec-86de-35e338dc942b', '1.0', '080027e2-1180-a1ec-86de-35e330e4942b', 'my_decision_table', 'cn=awdev@appworks,cn=organizational users,o=appworks_tips,cn=cordys,cn=defaultInst,o=mydomain.com', 'o=appworks_tips,cn=cordys,cn=defaultInst,o=mydomain.com', 'my_decision_table', 5, '2021-09-22 09:09:22.026', NULL, '2021-09-22 09:09:22', 'cn=awdev@appworks,cn=organizational users,o=appworks_tips,cn=cordys,cn=defaultInst,o=mydomain.com', 1, 0, 0, 'constraint', NULL, NULL, '<ruledefinition xmlns="http://rules/commontypes" PackageId="080027e2-1180-a1ec-86e1-3194924919e7"><rule xmlns="http://rules/commontypes" rule_id="080027e2-1180-a1ec-86de-35e33454942b" name="Rule 2"><usexpath>true</usexpath><metainfo><namespace xmlns="http://rules/commontypes"><prefix>mqtt</prefix><ns>https://appworks-tips.com/xsd/mqtt</ns></namespace></metainfo><if><condition>(mqtt:mqtt_data/mqtt:type=ws)</condition><then><action><soaprpc xmlns="http://rules/commontypes" name="soaprpc-soap" action_id="080027e2-1180-a1ec-86de-35e33434142b"><namespace>http://schemas/OpenTextEntityIdentityComponents/Role/operations</namespace><method>GetAllRoles</method><parameters><GetAllRoles xmlns="http://schemas/OpenTextEntityIdentityComponents/Role/operations"><contains xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true">PARAMETER</contains><ns0:Cursor xmlns:ns0="http://schemas.opentext.com/bps/entity/core" offset="0" limit="100"/></GetAllRoles></parameters></soaprpc></action></then></if></rule></ruledefinition>', 1, 'decisioncaseeditor', '<model xmlns="http://rules/decisioncasemodel/definition" ruleCount="2"><header><action><description editableProperty="true">Invoke Web Service</description><xpath display="none">actions/soaprpc</xpath><type>soaprpc</type><propertiesPage>com/cordys/rule/actions/soaprpc.caf</propertiesPage><parameters/><ruleactionxml/><enabled display="none"/></action><condition><description editableProperty="true">Type</description><xpath>mqtt:mqtt_data/mqtt:type</xpath><valueType display="none">single</valueType></condition></header><rules><rule rule_id="080027e2-1180-a1ec-86de-35e33454942b"><name>Rule 2</name><description editableProperty="true">Rule 2</description><condition><description editableProperty="true" value="is ws">is &lt;value&gt;</description><xpath>mqtt:mqtt_data/mqtt:type</xpath><valueType>single</valueType><values><value>ws</value></values><expression>mqtt:mqtt_data/mqtt:type=ws</expression></condition><action action_id="080027e2-1180-a1ec-86de-35e33434142b"><description editableProperty="true" value="Invoke">Invoke</description><xpath display="none">actions/soaprpc</xpath><type>soaprpc</type><propertiesPage>com/cordys/rule/actions/soaprpc.caf</propertiesPage><parameters/><ruleactionxml><soaprpc xmlns="http://rules/commontypes" name="soaprpc-soap" refId="00505601-18A3-A1E7-B985-54136E298DBD" lastModified="2021-07-09T07:16:52.124"><namespace>http://schemas/OpenTextEntityIdentityComponents/Role/operations</namespace><method/><parameters><GetAllRoles xmlns="http://schemas/OpenTextEntityIdentityComponents/Role/operations"><contains xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true">PARAMETER</contains><ns0:Cursor xmlns:ns0="http://schemas.opentext.com/bps/entity/core" offset="0" limit="100"/></GetAllRoles></parameters></soaprpc></ruleactionxml><enabled>true</enabled></action></rule></rules></model>', '<xmlschemas rootSchemaNameSpace="https://appworks-tips.com/xsd/mqtt" namespaceReferencePrefix="mqtt" fragmentName="mqtt_data"><xmlschema location="080027e2-1180-a1ec-86de-35e336d9942b" importedLocations="" includedLocations=""><xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.cordys.com/xmlschema/XMLSchemaDefinitionDesigntime/1.0" xmlns:mqtt="https://appworks-tips.com/xsd/mqtt" attributeFormDefault="unqualified" elementFormDefault="qualified" targetNamespace="https://appworks-tips.com/xsd/mqtt"><xs:element xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.cordys.com/businessobjectdocument/BusinessObjectDocument/1.0" name="mqtt_data"><xs:complexType><xs:sequence><xs:element type="xs:string" name="type"/><xs:element type="xs:string" name="broker"/><xs:element type="xs:string" name="topic"/><xs:element type="xs:string" name="payload"/></xs:sequence></xs:complexType></xs:element></xs:schema></xmlschema></xmlschemas>', '080027e2-1180-a1eb-b822-6f0c30002584', '080027e2-1180-a1ec-86de-35e338b2142b');

INSERT INTO "br_triggers" ("trigger_id", "rule_id", "version", "template_id", "template_name", "on_insert", "on_update", "on_delete", "orgcontext") VALUES
	('080027e2-1180-a1ec-86e0-e26893c08ba4', '080027e2-1180-a1ec-86de-35e338dc942b', '1.0', '080027e2-1180-a1ec-86de-35e3362f942b', 'mqtt_data', 1, 1, 1, 'o=appworks_tips,cn=cordys,cn=defaultInst,o=mydomain.com');

INSERT INTO "rulegroup" ("rulegroupid", "orgcontext", "rulegroupname", "rulegroupowner", "rulegroupdescription", "rulegrouppriority") VALUES
	('080027e2-1180-a1ec-86de-35e330e4942b', 'o=appworks_tips,cn=cordys,cn=defaultInst,o=mydomain.com', 'my_rulegroup', 'cn=awdev@appworks,cn=organizational users,o=appworks_tips,cn=cordys,cn=defaultInst,o=mydomain.com', 'my_rulegroup', 5);