actionEffectLogs Collection

{"_id": {"$oid": "6a3a11b297e5e28b119c6a83"}, "objectTypeId": "6a37fdec8690652730f521b7", "objectTypeExternalId": "areas", "triggerId": "6a3a117a97e5e28b119c6a7f", "triggerName": "test", "triggerType": "RESOURCE_BASED", "facilityId": "1643103503", "entityObjectId": "6a3a11b08690652730f528fa", "eventType": "CREATE", "status": "SUCCESS", "startedAt": 1782190514162, "completedAt": 1782190514177, "durationMs": 15, "effectLogs": [{"effectId": "6a3a119c97e5e28b119c6a81", "effectName": "e1", "effectType": "SQL_QUERY", "executionOrder": 1, "status": "SUCCESS", "skipped": false, "attempt": 1, "maxAttempts": 1, "startedAt": 1782190514, "completedAt": 1782190514, "durationMs": 14, "input": {"sql": "select * from users u limit 1;"}, "output": {"result": [{"id": 1701115958, "created_at": 1701115958, "modified_at": 1776969954, "organisations_id": 1617625401, "employee_id": "L-global.admin.09", "email": "ga.09@mailinator.com", "first_name": "Nilam", "archived": false, "last_name": "L", "created_by": 1617625401, "modified_by": 1617625401, "locked_at": null, "department": null, "failed_login_attempts": 0, "is_system_user": false, "password": "$2a$10$3sz3uOzIjQ2kUa9gGgq4C.xaBq8Gp1hWy2VHXnZl.Sef4QzhC9hqS", "password_updated_at": 1774377744, "username": "global.admin.09", "state": "PASSWORD_EXPIRED", "failed_additional_verification_attempts": 0, "challenge_questions_id": 1, "challenge_questions_answer": "leucine", "failed_challenge_question_attempts": 0, "type": "LOCAL"}]}}], "effectsSummary": {"total": 1, "success": 1, "failure": 0, "skipped": 0}, "metadata": {"changeStreamResumeToken": "{\"_data\": \"826A3A11B2000000012B042C01002B066E5A10048DC6740281F9401EBF1DE2AF9C42ECEE463C6F7065726174696F6E54797065003C696E736572740046646F63756D656E744B65790046645F696400646A3A11B08690652730F528FA000004\"}"}, "changeStreamData": {"_id": "6a3a11b08690652730f528fa", "operationType": "insert", "eventType": "CREATE", "fullDocument": {"_id": {"$oid": "6a3a11b08690652730f528fa"}, "objectTypeId": {"$oid": "6a37fdec8690652730f521b7"}, "version": 1, "collection": "areas", "displayName": "test", "externalId": "1", "objectType": {"_id": {"$oid": "6a37fdec8690652730f521b7"}, "externalId": "areas", "displayName": "Areas", "version": 1}, "properties": [{"_id": {"$oid": "6a37fdec8690652730f521b8"}, "externalId": "displayName", "displayName": "Name", "value": "test", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521b9"}, "externalId": "externalId", "displayName": "ID", "value": "1", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521ba"}, "externalId": "createdAt", "displayName": "Created At", "value": "1782190512", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521bb"}, "externalId": "updatedAt", "displayName": "Updated At", "value": "1782190512", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521bc"}, "externalId": "createdBy", "displayName": "Created By", "value": "1617625400", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521bd"}, "externalId": "updatedBy", "displayName": "Updated By", "value": "1617625400", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521be"}, "externalId": "usageStatus", "displayName": "Usage Status", "value": "1", "choices": []}], "relations": [], "modifiedAt": 1782190512, "createdAt": 1782190512, "createdBy": {"_id": "1617625400", "employeeId": "L-account.owner.01", "firstName": "Vivek", "lastName": "L"}, "modifiedBy": {"_id": "1617625400", "employeeId": "L-account.owner.01", "firstName": "Vivek", "lastName": "L"}, "usageStatus": 1, "facilityId": "1643103503", "shortCode": "UMEgc36hy0", "searchable": {"6a37fdec8690652730f521b8": "test", "6a37fdec8690652730f521be": 1, "6a37fdec8690652730f521bd": 1617625400, "6a37fdec8690652730f521ba": 1782190512, "6a37fdec8690652730f521b9": "1", "6a37fdec8690652730f521bc": 1617625400, "6a37fdec8690652730f521bb": 1782190512}, "_class": "com.leucine.streem.collections.EntityObject"}, "documentKey": {"_id": {"$oid": "6a3a11b08690652730f528fa"}}, "ns": {"db": "qa_d", "coll": "areas"}, "clusterTime": 1782190514}, "sourceData": {"_id": {"$oid": "6a3a11b08690652730f528fa"}, "objectTypeId": {"$oid": "6a37fdec8690652730f521b7"}, "version": 1, "collection": "areas", "displayName": "test", "externalId": "1", "objectType": {"_id": {"$oid": "6a37fdec8690652730f521b7"}, "externalId": "areas", "displayName": "Areas", "version": 1}, "properties": [{"_id": {"$oid": "6a37fdec8690652730f521b8"}, "externalId": "displayName", "displayName": "Name", "value": "test", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521b9"}, "externalId": "externalId", "displayName": "ID", "value": "1", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521ba"}, "externalId": "createdAt", "displayName": "Created At", "value": "1782190512", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521bb"}, "externalId": "updatedAt", "displayName": "Updated At", "value": "1782190512", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521bc"}, "externalId": "createdBy", "displayName": "Created By", "value": "1617625400", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521bd"}, "externalId": "updatedBy", "displayName": "Updated By", "value": "1617625400", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521be"}, "externalId": "usageStatus", "displayName": "Usage Status", "value": "1", "choices": []}], "relations": [], "modifiedAt": 1782190512, "createdAt": 1782190512, "createdBy": {"_id": "1617625400", "employeeId": "L-account.owner.01", "firstName": "Vivek", "lastName": "L"}, "modifiedBy": {"_id": "1617625400", "employeeId": "L-account.owner.01", "firstName": "Vivek", "lastName": "L"}, "usageStatus": 1, "facilityId": "1643103503", "shortCode": "UMEgc36hy0", "searchable": {"6a37fdec8690652730f521b8": "test", "6a37fdec8690652730f521be": 1, "6a37fdec8690652730f521bd": 1617625400, "6a37fdec8690652730f521ba": 1782190512, "6a37fdec8690652730f521b9": "1", "6a37fdec8690652730f521bc": 1617625400, "6a37fdec8690652730f521bb": 1782190512}, "_class": "com.leucine.streem.collections.EntityObject"}, "retrigger": false, "replay": false, "archived": false, "createdAt": 1782190514, "_class": "com.leucine.ontology.collections.ActionEffectLog"}

{"_id": {"$oid": "6a3a124ef652f5c51ad24ab1"}, "objectTypeId": "6a37fdec8690652730f521b7", "objectTypeExternalId": "areas", "triggerId": "6a3a117a97e5e28b119c6a7f", "triggerName": "test", "triggerType": "RESOURCE_BASED", "facilityId": "1643103503", "entityObjectId": "6a3a12338690652730f52901", "eventType": "CREATE", "status": "SUCCESS", "startedAt": 1782190670593, "completedAt": 1782190670611, "durationMs": 18, "effectLogs": [{"effectId": "6a3a119c97e5e28b119c6a81", "effectName": "e1", "effectType": "SQL_QUERY", "executionOrder": 1, "status": "SUCCESS", "skipped": false, "attempt": 1, "maxAttempts": 1, "startedAt": 1782190670, "completedAt": 1782190670, "durationMs": 17, "input": {"sql": "select * from users u limit 1;"}, "output": {"result": [{"id": 1701115958, "created_at": 1701115958, "modified_at": 1776969954, "organisations_id": 1617625401, "employee_id": "L-global.admin.09", "email": "ga.09@mailinator.com", "first_name": "Nilam", "archived": false, "last_name": "L", "created_by": 1617625401, "modified_by": 1617625401, "locked_at": null, "department": null, "failed_login_attempts": 0, "is_system_user": false, "password": "$2a$10$3sz3uOzIjQ2kUa9gGgq4C.xaBq8Gp1hWy2VHXnZl.Sef4QzhC9hqS", "password_updated_at": 1774377744, "username": "global.admin.09", "state": "PASSWORD_EXPIRED", "failed_additional_verification_attempts": 0, "challenge_questions_id": 1, "challenge_questions_answer": "leucine", "failed_challenge_question_attempts": 0, "type": "LOCAL"}]}}], "effectsSummary": {"total": 1, "success": 1, "failure": 0, "skipped": 0}, "metadata": {"changeStreamResumeToken": "{\"_data\": \"826A3A1233000000012B042C01002B026E5A10048DC6740281F9401EBF1DE2AF9C42ECEE463C6F7065726174696F6E54797065003C696E736572740046646F63756D656E744B65790046645F696400646A3A12338690652730F52901000004\"}"}, "changeStreamData": {"_id": "6a3a12338690652730f52901", "operationType": "insert", "eventType": "CREATE", "fullDocument": {"_id": {"$oid": "6a3a12338690652730f52901"}, "objectTypeId": {"$oid": "6a37fdec8690652730f521b7"}, "version": 1, "collection": "areas", "displayName": "test 2", "externalId": "23", "objectType": {"_id": {"$oid": "6a37fdec8690652730f521b7"}, "externalId": "areas", "displayName": "Areas", "version": 1}, "properties": [{"_id": {"$oid": "6a37fdec8690652730f521b8"}, "externalId": "displayName", "displayName": "Name", "value": "test 2", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521b9"}, "externalId": "externalId", "displayName": "ID", "value": "23", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521ba"}, "externalId": "createdAt", "displayName": "Created At", "value": "1782190643", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521bb"}, "externalId": "updatedAt", "displayName": "Updated At", "value": "1782190643", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521bc"}, "externalId": "createdBy", "displayName": "Created By", "value": "1617625400", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521bd"}, "externalId": "updatedBy", "displayName": "Updated By", "value": "1617625400", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521be"}, "externalId": "usageStatus", "displayName": "Usage Status", "value": "1", "choices": []}], "relations": [], "modifiedAt": 1782190643, "createdAt": 1782190643, "createdBy": {"_id": "1617625400", "employeeId": "L-account.owner.01", "firstName": "Vivek", "lastName": "L"}, "modifiedBy": {"_id": "1617625400", "employeeId": "L-account.owner.01", "firstName": "Vivek", "lastName": "L"}, "usageStatus": 1, "facilityId": "1643103503", "shortCode": "UMEpPscjmw", "searchable": {"6a37fdec8690652730f521b8": "test 2", "6a37fdec8690652730f521be": 1, "6a37fdec8690652730f521bd": 1617625400, "6a37fdec8690652730f521ba": 1782190643, "6a37fdec8690652730f521b9": "23", "6a37fdec8690652730f521bc": 1617625400, "6a37fdec8690652730f521bb": 1782190643}, "_class": "com.leucine.streem.collections.EntityObject"}, "documentKey": {"_id": {"$oid": "6a3a12338690652730f52901"}}, "ns": {"db": "qa_d", "coll": "areas"}, "clusterTime": 1782190643}, "sourceData": {"_id": {"$oid": "6a3a12338690652730f52901"}, "objectTypeId": {"$oid": "6a37fdec8690652730f521b7"}, "version": 1, "collection": "areas", "displayName": "test 2", "externalId": "23", "objectType": {"_id": {"$oid": "6a37fdec8690652730f521b7"}, "externalId": "areas", "displayName": "Areas", "version": 1}, "properties": [{"_id": {"$oid": "6a37fdec8690652730f521b8"}, "externalId": "displayName", "displayName": "Name", "value": "test 2", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521b9"}, "externalId": "externalId", "displayName": "ID", "value": "23", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521ba"}, "externalId": "createdAt", "displayName": "Created At", "value": "1782190643", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521bb"}, "externalId": "updatedAt", "displayName": "Updated At", "value": "1782190643", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521bc"}, "externalId": "createdBy", "displayName": "Created By", "value": "1617625400", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521bd"}, "externalId": "updatedBy", "displayName": "Updated By", "value": "1617625400", "choices": []}, {"_id": {"$oid": "6a37fdec8690652730f521be"}, "externalId": "usageStatus", "displayName": "Usage Status", "value": "1", "choices": []}], "relations": [], "modifiedAt": 1782190643, "createdAt": 1782190643, "createdBy": {"_id": "1617625400", "employeeId": "L-account.owner.01", "firstName": "Vivek", "lastName": "L"}, "modifiedBy": {"_id": "1617625400", "employeeId": "L-account.owner.01", "firstName": "Vivek", "lastName": "L"}, "usageStatus": 1, "facilityId": "1643103503", "shortCode": "UMEpPscjmw", "searchable": {"6a37fdec8690652730f521b8": "test 2", "6a37fdec8690652730f521be": 1, "6a37fdec8690652730f521bd": 1617625400, "6a37fdec8690652730f521ba": 1782190643, "6a37fdec8690652730f521b9": "23", "6a37fdec8690652730f521bc": 1617625400, "6a37fdec8690652730f521bb": 1782190643}, "_class": "com.leucine.streem.collections.EntityObject"}, "retrigger": false, "replay": false, "archived": false, "createdAt": 1782190670, "_class": "com.leucine.ontology.collections.ActionEffectLog"}

{"_id": {"$oid": "6a462e87f652f5c51ad24ab6"}, "objectTypeId": "6a421e4b5731a933914103de", "objectTypeExternalId": "autoIdUtility2", "triggerId": "6a462e2f65d48d44d938c43f", "triggerName": "Action Effect", "triggerType": "RESOURCE_BASED", "facilityId": "1643103503", "entityObjectId": "6a462e7d65d48d44d938c4a9", "eventType": "CREATE", "status": "SUCCESS", "startedAt": 1782984324355, "completedAt": 1782984327658, "durationMs": 3303, "effectLogs": [{"effectId": "6a462e2f65d48d44d938c440", "effectName": "Effect", "effectType": "NOTIFICATION", "executionOrder": 1, "status": "SUCCESS", "skipped": false, "attempt": 1, "maxAttempts": 1, "startedAt": 1782984324, "completedAt": 1782984327, "durationMs": 3303, "input": {"subject": "Object", "body": "Object Creation", "to": ["akash.verma@leucinetech.com"]}, "output": {"message": "Notification sent"}}], "effectsSummary": {"total": 1, "success": 1, "failure": 0, "skipped": 0}, "metadata": {"changeStreamResumeToken": "{\"_data\": \"826A462E84000000012B042C01002B046E5A100476FEA4E899C848F5837BC56C69C7BC23463C6F7065726174696F6E54797065003C696E736572740046646F63756D656E744B65790046645F696400646A462E7D65D48D44D938C4A9000004\"}"}, "changeStreamData": {"_id": "6a462e7d65d48d44d938c4a9", "operationType": "insert", "eventType": "CREATE", "fullDocument": {"_id": {"$oid": "6a462e7d65d48d44d938c4a9"}, "objectTypeId": {"$oid": "6a421e4b5731a933914103de"}, "version": 1, "collection": "autoIdUtility2", "displayName": "Test", "externalId": "AUTO-JUL26-1", "objectType": {"_id": {"$oid": "6a421e4b5731a933914103de"}, "externalId": "autoIdUtility2", "displayName": "auto id utility 2", "version": 1}, "properties": [{"_id": {"$oid": "6a421e4b5731a933914103df"}, "externalId": "displayName", "displayName": "Name", "value": "Test", "choices": []}, {"_id": {"$oid": "6a421e4b5731a933914103e0"}, "externalId": "externalId", "displayName": "Id", "value": "AUTO-JUL26-1", "choices": []}, {"_id": {"$oid": "6a421e4b5731a933914103e1"}, "externalId": "createdAt", "displayName": "Created At", "value": "1782984317", "choices": []}, {"_id": {"$oid": "6a421e4b5731a933914103e2"}, "externalId": "updatedAt", "displayName": "Updated At", "value": "1782984317", "choices": []}, {"_id": {"$oid": "6a421e4b5731a933914103e3"}, "externalId": "createdBy", "displayName": "Created By", "value": "711503530026606592", "choices": []}, {"_id": {"$oid": "6a421e4b5731a933914103e4"}, "externalId": "updatedBy", "displayName": "Updated By", "value": "711503530026606592", "choices": []}, {"_id": {"$oid": "6a421e4b5731a933914103e5"}, "externalId": "usageStatus", "displayName": "Usage Status", "value": "1", "choices": []}], "relations": [], "modifiedAt": 1782984317, "createdAt": 1782984317, "createdBy": {"_id": "711503530026606592", "employeeId": "9000", "firstName": "Akash_pp", "lastName": ""}, "modifiedBy": {"_id": "711503530026606592", "employeeId": "9000", "firstName": "Akash_pp", "lastName": ""}, "usageStatus": 1, "facilityId": "1643103503", "shortCode": "V1THax3X8I", "searchable": {"6a421e4b5731a933914103e5": 1, "6a421e4b5731a933914103e3": 711503530026606592, "6a421e4b5731a933914103e4": 711503530026606592, "6a421e4b5731a933914103e0": "AUTO-JUL26-1", "6a421e4b5731a933914103e1": 1782984317, "6a421e4b5731a933914103df": "Test", "6a421e4b5731a933914103e2": 1782984317}, "_class": "com.leucine.streem.collections.EntityObject"}, "documentKey": {"_id": {"$oid": "6a462e7d65d48d44d938c4a9"}}, "ns": {"db": "qa_d", "coll": "autoIdUtility2"}, "clusterTime": 1782984324}, "sourceData": {"_id": {"$oid": "6a462e7d65d48d44d938c4a9"}, "objectTypeId": {"$oid": "6a421e4b5731a933914103de"}, "version": 1, "collection": "autoIdUtility2", "displayName": "Test", "externalId": "AUTO-JUL26-1", "objectType": {"_id": {"$oid": "6a421e4b5731a933914103de"}, "externalId": "autoIdUtility2", "displayName": "auto id utility 2", "version": 1}, "properties": [{"_id": {"$oid": "6a421e4b5731a933914103df"}, "externalId": "displayName", "displayName": "Name", "value": "Test", "choices": []}, {"_id": {"$oid": "6a421e4b5731a933914103e0"}, "externalId": "externalId", "displayName": "Id", "value": "AUTO-JUL26-1", "choices": []}, {"_id": {"$oid": "6a421e4b5731a933914103e1"}, "externalId": "createdAt", "displayName": "Created At", "value": "1782984317", "choices": []}, {"_id": {"$oid": "6a421e4b5731a933914103e2"}, "externalId": "updatedAt", "displayName": "Updated At", "value": "1782984317", "choices": []}, {"_id": {"$oid": "6a421e4b5731a933914103e3"}, "externalId": "createdBy", "displayName": "Created By", "value": "711503530026606592", "choices": []}, {"_id": {"$oid": "6a421e4b5731a933914103e4"}, "externalId": "updatedBy", "displayName": "Updated By", "value": "711503530026606592", "choices": []}, {"_id": {"$oid": "6a421e4b5731a933914103e5"}, "externalId": "usageStatus", "displayName": "Usage Status", "value": "1", "choices": []}], "relations": [], "modifiedAt": 1782984317, "createdAt": 1782984317, "createdBy": {"_id": "711503530026606592", "employeeId": "9000", "firstName": "Akash_pp", "lastName": ""}, "modifiedBy": {"_id": "711503530026606592", "employeeId": "9000", "firstName": "Akash_pp", "lastName": ""}, "usageStatus": 1, "facilityId": "1643103503", "shortCode": "V1THax3X8I", "searchable": {"6a421e4b5731a933914103e5": 1, "6a421e4b5731a933914103e3": 711503530026606592, "6a421e4b5731a933914103e4": 711503530026606592, "6a421e4b5731a933914103e0": "AUTO-JUL26-1", "6a421e4b5731a933914103e1": 1782984317, "6a421e4b5731a933914103df": "Test", "6a421e4b5731a933914103e2": 1782984317}, "_class": "com.leucine.streem.collections.EntityObject"}, "retrigger": false, "replay": false, "archived": false, "createdAt": 1782984327, "_class": "com.leucine.ontology.collections.ActionEffectLog"}