Chatbot Conversation History
Review saved chatbot questions, responses, intents, tools, and AI model activity.
View saved snapshots
{
"decision": "openai_agent",
"tool_result_status": "found",
"results_snapshot": [
{
"id": 236,
"platform_name": "Patient Booking",
"module_name": "Appointment Requests",
"record_type": "appointment_request",
"full_name": "John Santos",
"reference_number": "BOOKING-REQ-91",
"synced_at": "2026-06-04 17:09:11",
"payload_fields": {
"appointment_request_id": 91,
"reference_number": "BOOKING-REQ-91",
"user_id": 11,
"patient_id": 8,
"patient_name": "John Santos",
"patient_mobile": "9444444444",
"patient_birthdate": "1998-01-01",
"doctor_id": 3,
"doctor_name": "Alvin Galang Penafiel",
"doctor_specialty": "Internal Medicine",
"clinic": "Emergency Department",
"date": "2026-06-04",
"start": "16:48:23",
"end": "17:48:23",
"status": "cancelled",
"reason": "Cancelled by Administrator.",
"is_synced_to_emr": "true",
"created_at": "2026-06-04 16:48:23",
"updated_at": "2026-06-04 16:49:21"
},
"status": "cancelled"
},
{
"id": 235,
"platform_name": "Patient Booking",
"module_name": "Appointment Requests",
"record_type": "appointment_request",
"full_name": "Buten Dball Master",
"reference_number": "BOOKING-REQ-92",
"synced_at": "2026-06-04 17:09:11",
"payload_fields": {
"appointment_request_id": 92,
"reference_number": "BOOKING-REQ-92",
"user_id": 8,
"patient_id": 5,
"patient_name": "Buten Dball Master",
"patient_mobile": "9222222222",
"patient_birthdate": "1946-02-20",
"doctor_id": 3,
"doctor_name": "Alvin Galang Penafiel",
"doctor_specialty": "Internal Medicine",
"clinic": "Emergency Department",
"date": "2026-06-04",
"start": "16:56:06",
"end": "17:56:06",
"status": "approved",
"reason": "Emergency response: Help!!!!!",
"is_synced_to_emr": "true",
"created_at": "2026-06-04 16:56:06",
"updated_at": "2026-06-04 16:56:06"
},
"status": "approved"
},
{
"id": 197,
"platform_name": "Patient Booking",
"module_name": "Appointment Requests",
"record_type": "appointment_request",
"full_name": "John Santos",
"reference_number": "BOOKING-REQ-90",
"synced_at": "2026-06-04 17:09:11",
"payload_fields": {
"appointment_request_id": 90,
"reference_number": "BOOKING-REQ-90",
"user_id": 11,
"patient_id": 8,
"patient_name": "John Santos",
"patient_mobile": "9444444444",
"patient_birthdate": "1998-01-01",
"doctor_id": 3,
"doctor_name": "Alvin Galang Penafiel",
"doctor_specialty": "Internal Medicine",
"clinic": "Emergency Department",
"date": "2026-06-04",
"start": "16:38:26",
"end": "17:38:26",
"status": "cancelled",
"reason": "Cancelled by Administrator.",
"is_synced_to_emr": "true",
"created_at": "2026-06-04 16:13:07",
"updated_at": "2026-06-04 16:49:26"
},
"status": "cancelled"
},
{
"id": 234,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "asdasdasdaseqwe",
"reference_number": "DISP-EMG-311",
"synced_at": "2026-06-04 17:09:06",
"payload_fields": {
"emergency_id": 311,
"reference_number": "DISP-EMG-311",
"incident": "asdasdasdaseqwe",
"reported_by": "John Santos",
"reporter_phone": "9444444444",
"latitude": "15.0359420",
"longitude": "120.6983010",
"status": "unread",
"created_at": "2026-06-04 16:48:16",
"updated_at": "2026-06-04 16:48:16"
},
"status": "unread"
},
{
"id": 233,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "Help!!!!!",
"reference_number": "DISP-EMG-312",
"synced_at": "2026-06-04 17:09:06",
"payload_fields": {
"emergency_id": 312,
"reference_number": "DISP-EMG-312",
"incident": "Help!!!!!",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "14.2900000",
"longitude": "121.0000000",
"status": "read",
"created_at": "2026-06-04 16:56:00",
"updated_at": "2026-06-04 17:04:48"
},
"status": "read"
},
{
"id": 232,
"platform_name": "BITAL EMR",
"module_name": "Patient Records",
"record_type": "patient",
"full_name": "John Santos",
"reference_number": "EMR-PAT-422",
"synced_at": "2026-06-04 17:09:00",
"payload_fields": {
"patient_id": 422,
"reference_number": "EMR-PAT-422",
"full_name": "John Santos",
"first_name": "John",
"middle_name": null,
"last_name": "Santos",
"birthdate": "1998-01-01",
"age": "28",
"gender": "Unknown",
"civil_status": "Unknown",
"height": null,
"weight": null,
"mobile": "9444444444",
"telephone": null,
"type_of_transaction": "Emergency",
"card_number": "DISP-EMG-310",
"address": null,
"notes": "[2026-06-04 16:48:24] Emergency auto-booking from Dispatch App. Emergency ID: 311. Incident: Emergency. Related records attached: 7.",
"occupation": null,
"guardian_name": null,
"relationship": null,
"guardian_address": null,
"referring_physician": null,
"primary_care_physician": null,
"referring_institution": null,
"pastmedical": null,
"vaccination": null,
"drug": null,
"dosage": null,
"medical": null,
"obgyn": null,
"others": null,
"created_at": "2026-06-04 16:48:24",
"updated_at": "2026-06-04 16:48:24"
},
"age": "28",
"gender": "Unknown",
"birthdate": "1998-01-01",
"phone": "9444444444"
},
{
"id": 231,
"platform_name": "BITAL EMR",
"module_name": "Patient Records",
"record_type": "patient",
"full_name": "Buten Dball Master",
"reference_number": "EMR-PAT-423",
"synced_at": "2026-06-04 17:09:00",
"payload_fields": {
"patient_id": 423,
"reference_number": "EMR-PAT-423",
"full_name": "Buten Dball Master",
"first_name": "Buten",
"middle_name": "Dball",
"last_name": "Master",
"birthdate": "1946-02-20",
"age": "80",
"gender": "Unknown",
"civil_status": "Unknown",
"height": null,
"weight": null,
"mobile": "9222222222",
"telephone": null,
"type_of_transaction": "Emergency",
"card_number": "BOOKING-REQ-89",
"address": null,
"notes": "[2026-06-04 16:56:06] Emergency auto-booking from Dispatch App. Emergency ID: 312. Incident: Emergency. Related records attached: 36.",
"occupation": null,
"guardian_name": null,
"relationship": null,
"guardian_address": null,
"referring_physician": null,
"primary_care_physician": null,
"referring_institution": null,
"pastmedical": null,
"vaccination": null,
"drug": null,
"dosage": null,
"medical": null,
"obgyn": null,
"others": null,
"created_at": "2026-06-04 16:56:06",
"updated_at": "2026-06-04 16:56:06"
},
"age": "80",
"gender": "Unknown",
"birthdate": "1946-02-20",
"phone": "9222222222"
},
{
"id": 194,
"platform_name": "Patient Booking",
"module_name": "Appointment Requests",
"record_type": "appointment_request",
"full_name": "Buten Dball Master",
"reference_number": "BOOKING-REQ-89",
"synced_at": "2026-06-04 16:56:05",
"payload_fields": {
"appointment_request_id": 89,
"reference_number": "BOOKING-REQ-89",
"user_id": 8,
"patient_id": 5,
"patient_name": "Buten Dball Master",
"patient_mobile": "9222222222",
"patient_birthdate": "1946-02-20",
"doctor_id": 3,
"doctor_name": "Alvin Galang Penafiel",
"doctor_specialty": "Internal Medicine",
"clinic": "Emergency Department",
"date": "2026-06-04",
"start": "08:07:06",
"end": "09:07:06",
"status": "cancelled",
"reason": "Cancelled by Administrator.",
"is_synced_to_emr": "true",
"created_at": "2026-06-04 16:07:06",
"updated_at": "2026-06-04 16:49:32"
},
"status": "cancelled"
},
{
"id": 192,
"platform_name": "Patient Booking",
"module_name": "Appointment Requests",
"record_type": "appointment_request",
"full_name": "Buten Dball Master",
"reference_number": "BOOKING-PAT-5",
"synced_at": "2026-06-04 16:56:05",
"payload_fields": {
"patient_id": 5,
"reference_number": "BOOKING-PAT-5",
"full_name": "Buten Dball Master",
"first_name": "Buten",
"middle_name": "Dball",
"last_name": "Master",
"birthdate": "1946-02-20",
"age": "80",
"gender": "Unknown",
"civil_status": "Unknown",
"height": null,
"weight": null,
"mobile": "9222222222",
"telephone": null,
"type_of_transaction": "Emergency",
"card_number": "BOOKING-REQ-84",
"address": null,
"notes": "[2026-06-02 14:58:07] Emergency auto-booking from Dispatch App. Emergency ID: 286. Incident: Emergency. Related records attached: 8.\n[2026-06-02 14:58:35] Emergency auto-booking from Dispatch App. Emergency ID: 287. Incident: Emergency. Related records attached: 9.\n[2026-06-02 14:59:02] Emergency au...",
"occupation": null,
"company_name": null,
"guardian_name": null,
"relationship": null,
"guardian_address": null,
"referring_physician": null,
"primary_care_physician": null,
"referring_institution": null,
"created_at": "2026-06-02 14:58:07",
"updated_at": "2026-06-04 16:07:06"
},
"age": "80",
"gender": "Unknown",
"birthdate": "1946-02-20",
"phone": "9222222222"
},
{
"id": 116,
"platform_name": "Patient Booking",
"module_name": "Appointment Requests",
"record_type": "appointment_request",
"full_name": "Buten Dball Master",
"reference_number": "BOOKING-REQ-84",
"synced_at": "2026-06-04 16:56:05",
"payload_fields": {
"appointment_request_id": 84,
"reference_number": "BOOKING-REQ-84",
"user_id": 8,
"patient_id": 5,
"patient_name": "Buten Dball Master",
"patient_mobile": "9222222222",
"patient_birthdate": "1946-02-20",
"doctor_id": 3,
"doctor_name": "Alvin Galang Penafiel",
"doctor_specialty": "Internal Medicine",
"clinic": "Emergency Department",
"date": "2026-06-02",
"start": "09:03:59",
"end": "10:03:59",
"status": "cancelled",
"reason": "Cancelled by Administrator.",
"is_synced_to_emr": "true",
"created_at": "2026-06-02 17:04:00",
"updated_at": "2026-06-04 16:49:37"
},
"status": "cancelled"
},
{
"id": 114,
"platform_name": "Patient Booking",
"module_name": "Appointment Requests",
"record_type": "appointment_request",
"full_name": "Buten Dball Master",
"reference_number": "BOOKING-REQ-86",
"synced_at": "2026-06-04 16:56:05",
"payload_fields": {
"appointment_request_id": 86,
"reference_number": "BOOKING-REQ-86",
"user_id": 8,
"patient_id": 5,
"patient_name": "Buten Dball Master",
"patient_mobile": "9222222222",
"patient_birthdate": "1946-02-20",
"doctor_id": 3,
"doctor_name": "Alvin Galang Penafiel",
"doctor_specialty": "Internal Medicine",
"clinic": "Emergency Department",
"date": "2026-06-03",
"start": "08:32:29",
"end": "09:32:29",
"status": "cancelled",
"reason": "Cancelled by Administrator.",
"is_synced_to_emr": "true",
"created_at": "2026-06-03 16:32:07",
"updated_at": "2026-06-04 16:49:43"
},
"status": "cancelled"
},
{
"id": 196,
"platform_name": "Patient Booking",
"module_name": "Appointment Requests",
"record_type": "appointment_request",
"full_name": "John Santos",
"reference_number": "BOOKING-PAT-8",
"synced_at": "2026-06-04 16:48:22",
"payload_fields": {
"patient_id": 8,
"reference_number": "BOOKING-PAT-8",
"full_name": "John Santos",
"first_name": "John",
"middle_name": null,
"last_name": "Santos",
"birthdate": "1998-01-01",
"age": "28",
"gender": "Unknown",
"civil_status": "Unknown",
"height": null,
"weight": null,
"mobile": "9444444444",
"telephone": null,
"type_of_transaction": "Emergency",
"card_number": "DISP-EMG-282",
"address": null,
"notes": "[2026-06-04 16:13:07] Emergency auto-booking from Dispatch App. Emergency ID: 310. Incident: Emergency. Related records attached: 3.\r\n[2026-06-04 16:38:27] Emergency auto-booking from Dispatch App. Emergency ID: 310. Incident: Emergency. Related records attached: 5.",
"occupation": null,
"company_name": null,
"guardian_name": null,
"relationship": null,
"guardian_address": null,
"referring_physician": null,
"primary_care_physician": null,
"referring_institution": null,
"created_at": "2026-06-04 16:13:07",
"updated_at": "2026-06-04 16:38:27"
},
"age": "28",
"gender": "Unknown",
"birthdate": "1998-01-01",
"phone": "9444444444"
},
{
"id": 230,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "ads kj adad shkjadsnk jads nkjad s",
"reference_number": "DISP-EMG-310",
"synced_at": "2026-06-04 16:44:46",
"payload_fields": {
"emergency_id": 310,
"reference_number": "DISP-EMG-310",
"incident": "ads kj adad shkjadsnk jads nkjad s",
"reported_by": "John Santos",
"reporter_phone": "9444444444",
"latitude": "15.0359370",
"longitude": "120.6983270",
"status": "read",
"created_at": "2026-06-04 16:13:03",
"updated_at": "2026-06-04 16:38:13"
},
"status": "read"
},
{
"id": 87,
"platform_name": "Dispatch App",
"module_name": "Responder Records",
"record_type": "responder",
"full_name": "Health Responder",
"reference_number": "DISP-RESP-3",
"synced_at": "2026-06-04 08:08:52",
"payload_fields": {
"responder_id": 3,
"reference_number": "DISP-RESP-3",
"responder_code": "26-000000000",
"responder_name": "Health Responder",
"service_id": 12,
"service_name": "MS - Ambulance",
"latitude": "15.0359390",
"longitude": "120.6983172",
"status": "inactive",
"created_at": "2026-06-02 09:56:19",
"updated_at": "2026-06-04 16:06:43"
},
"status": "inactive"
},
{
"id": 193,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "asdjasjondfpas nf",
"reference_number": "DISP-EMG-309",
"synced_at": "2026-06-04 08:08:50",
"payload_fields": {
"emergency_id": 309,
"reference_number": "DISP-EMG-309",
"incident": "asdjasjondfpas nf",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359390",
"longitude": "120.6983170",
"status": "unread",
"created_at": "2026-06-04 16:07:00",
"updated_at": "2026-06-04 16:07:00"
},
"status": "unread"
},
{
"id": 95,
"platform_name": "Dispatch App",
"module_name": "Service Records",
"record_type": "service",
"full_name": "MS - Ambulance",
"reference_number": "DISP-SERVICE-12",
"synced_at": "2026-06-04 05:57:41",
"payload_fields": {
"service_id": 12,
"reference_number": "DISP-SERVICE-12",
"name": "MS - Ambulance",
"description": "...",
"created_at": "2025-06-25 01:05:34",
"updated_at": "2025-06-25 01:05:34"
}
},
{
"id": 94,
"platform_name": "Dispatch App",
"module_name": "Service Records",
"record_type": "service",
"full_name": "MS - Police Car",
"reference_number": "DISP-SERVICE-13",
"synced_at": "2026-06-04 05:57:41",
"payload_fields": {
"service_id": 13,
"reference_number": "DISP-SERVICE-13",
"name": "MS - Police Car",
"description": "...",
"created_at": "2025-06-25 01:05:40",
"updated_at": "2025-06-25 01:05:56"
}
},
{
"id": 93,
"platform_name": "Dispatch App",
"module_name": "Service Records",
"record_type": "service",
"full_name": "MS - Fire Rescue",
"reference_number": "DISP-SERVICE-14",
"synced_at": "2026-06-04 05:57:41",
"payload_fields": {
"service_id": 14,
"reference_number": "DISP-SERVICE-14",
"name": "MS - Fire Rescue",
"description": "...",
"created_at": "2025-06-25 01:05:50",
"updated_at": "2026-05-20 11:45:13"
}
},
{
"id": 92,
"platform_name": "Dispatch App",
"module_name": "Service Records",
"record_type": "service",
"full_name": "BR - Fire Stations",
"reference_number": "DISP-SERVICE-15",
"synced_at": "2026-06-04 05:57:41",
"payload_fields": {
"service_id": 15,
"reference_number": "DISP-SERVICE-15",
"name": "BR - Fire Stations",
"description": null,
"created_at": "2025-06-25 01:06:02",
"updated_at": "2025-06-25 01:06:02"
}
},
{
"id": 91,
"platform_name": "Dispatch App",
"module_name": "Service Records",
"record_type": "service",
"full_name": "BR - Hospitals",
"reference_number": "DISP-SERVICE-16",
"synced_at": "2026-06-04 05:57:41",
"payload_fields": {
"service_id": 16,
"reference_number": "DISP-SERVICE-16",
"name": "BR - Hospitals",
"description": null,
"created_at": "2025-06-25 01:06:09",
"updated_at": "2025-06-25 01:07:12"
}
},
{
"id": 90,
"platform_name": "Dispatch App",
"module_name": "Service Records",
"record_type": "service",
"full_name": "BR - Police Stations",
"reference_number": "DISP-SERVICE-17",
"synced_at": "2026-06-04 05:57:40",
"payload_fields": {
"service_id": 17,
"reference_number": "DISP-SERVICE-17",
"name": "BR - Police Stations",
"description": null,
"created_at": "2025-06-25 01:06:14",
"updated_at": "2025-06-25 01:06:14"
}
},
{
"id": 89,
"platform_name": "Dispatch App",
"module_name": "Responder Records",
"record_type": "responder",
"full_name": "Pulisman",
"reference_number": "DISP-RESP-1",
"synced_at": "2026-06-04 05:55:37",
"payload_fields": {
"responder_id": 1,
"reference_number": "DISP-RESP-1",
"responder_code": "00-01",
"responder_name": "Pulisman",
"service_id": 13,
"service_name": "MS - Police Car",
"latitude": "14.7417072",
"longitude": "120.9704234",
"status": "inactive",
"created_at": "2025-08-14 14:54:23",
"updated_at": "2025-08-14 14:55:33"
},
"status": "inactive"
},
{
"id": 88,
"platform_name": "Dispatch App",
"module_name": "Responder Records",
"record_type": "responder",
"full_name": "test",
"reference_number": "DISP-RESP-2",
"synced_at": "2026-06-04 05:55:37",
"payload_fields": {
"responder_id": 2,
"reference_number": "DISP-RESP-2",
"responder_code": "123",
"responder_name": "test",
"service_id": 13,
"service_name": "MS - Police Car",
"latitude": "15.0359462",
"longitude": "120.6983018",
"status": "inactive",
"created_at": "2026-05-19 09:23:07",
"updated_at": "2026-05-19 09:30:52"
},
"status": "inactive"
},
{
"id": 86,
"platform_name": "Dispatch App",
"module_name": "Incident Records",
"record_type": "incident",
"full_name": "Test",
"reference_number": "DISP-INC-90",
"synced_at": "2026-06-04 05:55:25",
"payload_fields": {
"incident_id": 90,
"reference_number": "DISP-INC-90",
"emergency_id": 173,
"incident_type": "Test",
"address": "15.0360928, 120.6984739",
"status": "resolved",
"assigned_at": "2025-06-27 05:18:27",
"resolved_at": "2025-06-27 05:28:07",
"created_at": "2025-06-27 05:18:27",
"updated_at": "2025-06-27 05:28:07"
},
"status": "resolved",
"address": "15.0360928, 120.6984739"
},
{
"id": 85,
"platform_name": "Dispatch App",
"module_name": "Incident Records",
"record_type": "incident",
"full_name": "Help me fire fire",
"reference_number": "DISP-INC-91",
"synced_at": "2026-06-04 05:55:25",
"payload_fields": {
"incident_id": 91,
"reference_number": "DISP-INC-91",
"emergency_id": 272,
"incident_type": "Help me fire fire",
"address": "15.035946, 120.698302",
"status": "resolved",
"assigned_at": "2026-05-19 17:10:41",
"resolved_at": "2026-05-19 17:11:02",
"created_at": "2026-05-19 17:10:41",
"updated_at": "2026-05-19 17:11:02"
},
"status": "resolved",
"address": "15.035946, 120.698302"
}
],
"master_person_snapshot": null,
"summary_snapshot": {
"intent": "List recent emergency records",
"tables_used": [
"synced_records"
],
"row_count": 25,
"display_fields": [
"id",
"platform_name",
"module_name",
"record_type",
"full_name",
"reference_number",
"synced_at",
"payload_fields"
],
"safe_sql_was_validated": true,
"query_source": "ai_sql_plan",
"payload_reading": "enabled_safe_payload_fields_only"
},
"metadata": {
"ip_address": "119.94.164.58",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36",
"created_from": "chatbot_ui",
"conversation_id": "54fb8a9b-853a-4617-9196-bcd8c25b1a2f",
"router_decision": {
"mode": "new_request",
"action_id": null,
"confidence": 92,
"rewritten_intent": "User is asking for a list of recent emergencies, which is a new query rather than a follow-up to the last specific incident details.",
"reason": "The message requests a broader list of recent emergencies, not a continuation of the previous single-record detail or summary actions."
}
}
}
View saved snapshots
{
"decision": "ai_follow_up_router",
"tool_result_status": "found",
"results_snapshot": [
{
"id": 86,
"platform_name": "Dispatch App",
"module_name": "Incident Records",
"record_type": "incident",
"full_name": "Test",
"reference_number": "DISP-INC-90",
"synced_at": "2026-06-04 05:55:25",
"payload_fields": {
"incident_id": 90,
"reference_number": "DISP-INC-90",
"emergency_id": 173,
"incident_type": "Test",
"address": "15.0360928, 120.6984739",
"status": "resolved",
"assigned_at": "2025-06-27 05:18:27",
"resolved_at": "2025-06-27 05:28:07",
"created_at": "2025-06-27 05:18:27",
"updated_at": "2025-06-27 05:28:07"
},
"status": "resolved",
"address": "15.0360928, 120.6984739"
}
],
"master_person_snapshot": null,
"summary_snapshot": {
"result_index": 0,
"source": "conversation_memory.last_results"
},
"metadata": {
"ip_address": "119.94.164.58",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36",
"created_from": "chatbot_ui",
"conversation_id": "54fb8a9b-853a-4617-9196-bcd8c25b1a2f",
"router_decision": {
"mode": "follow_up_action",
"action_id": "show_first_result_details",
"confidence": 92,
"rewritten_intent": "Show the details of the most recent emergency/incident result",
"reason": "The user is referring to the previously discussed last emergency, which matches the existing result details action."
}
}
}
View saved snapshots
{
"decision": "ai_follow_up_router",
"tool_result_status": "found",
"results_snapshot": [
{
"id": 86,
"platform_name": "Dispatch App",
"module_name": "Incident Records",
"record_type": "incident",
"full_name": "Test",
"reference_number": "DISP-INC-90",
"synced_at": "2026-06-04 05:55:25",
"payload_fields": {
"incident_id": 90,
"reference_number": "DISP-INC-90",
"emergency_id": 173,
"incident_type": "Test",
"address": "15.0360928, 120.6984739",
"status": "resolved",
"assigned_at": "2025-06-27 05:18:27",
"resolved_at": "2025-06-27 05:28:07",
"created_at": "2025-06-27 05:18:27",
"updated_at": "2025-06-27 05:28:07"
},
"status": "resolved",
"address": "15.0360928, 120.6984739"
}
],
"master_person_snapshot": null,
"summary_snapshot": {
"result_index": 0,
"source": "conversation_memory.last_results"
},
"metadata": {
"ip_address": "119.94.164.58",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36",
"created_from": "chatbot_ui",
"conversation_id": "54fb8a9b-853a-4617-9196-bcd8c25b1a2f",
"router_decision": {
"mode": "follow_up_action",
"action_id": "show_first_result_details",
"confidence": 78,
"rewritten_intent": "Ask for the most recent emergency/incident details from the last result",
"reason": "The user is referring to the previously retrieved latest incident and asking for its emergency-related details, which matches opening the first result."
}
}
}
View saved snapshots
{
"decision": "ai_follow_up_router",
"tool_result_status": "found",
"results_snapshot": [
{
"id": 86,
"platform_name": "Dispatch App",
"module_name": "Incident Records",
"record_type": "incident",
"full_name": "Test",
"reference_number": "DISP-INC-90",
"synced_at": "2026-06-04 05:55:25",
"payload_fields": {
"incident_id": 90,
"reference_number": "DISP-INC-90",
"emergency_id": 173,
"incident_type": "Test",
"address": "15.0360928, 120.6984739",
"status": "resolved",
"assigned_at": "2025-06-27 05:18:27",
"resolved_at": "2025-06-27 05:28:07",
"created_at": "2025-06-27 05:18:27",
"updated_at": "2025-06-27 05:28:07"
},
"status": "resolved",
"address": "15.0360928, 120.6984739"
}
],
"master_person_snapshot": null,
"summary_snapshot": {
"result_index": 0,
"source": "conversation_memory.last_results"
},
"metadata": {
"ip_address": "119.94.164.58",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36",
"created_from": "chatbot_ui",
"conversation_id": "54fb8a9b-853a-4617-9196-bcd8c25b1a2f",
"router_decision": {
"mode": "follow_up_action",
"action_id": "show_first_result_details",
"confidence": 92,
"rewritten_intent": "show the details of the latest incident result",
"reason": "The user is referring to the previously retrieved latest incident and asking to view it again, which matches the existing result-details follow-up action."
}
}
}
View saved snapshots
{
"decision": "ai_follow_up_router",
"tool_result_status": "found",
"results_snapshot": [
{
"id": 86,
"platform_name": "Dispatch App",
"module_name": "Incident Records",
"record_type": "incident",
"full_name": "Test",
"reference_number": "DISP-INC-90",
"synced_at": "2026-06-04 05:55:25",
"payload_fields": {
"incident_id": 90,
"reference_number": "DISP-INC-90",
"emergency_id": 173,
"incident_type": "Test",
"address": "15.0360928, 120.6984739",
"status": "resolved",
"assigned_at": "2025-06-27 05:18:27",
"resolved_at": "2025-06-27 05:28:07",
"created_at": "2025-06-27 05:18:27",
"updated_at": "2025-06-27 05:28:07"
},
"status": "resolved",
"address": "15.0360928, 120.6984739"
}
],
"master_person_snapshot": null,
"summary_snapshot": {
"result_index": 0,
"source": "conversation_memory.last_results"
},
"metadata": {
"ip_address": "119.94.164.58",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36",
"created_from": "chatbot_ui",
"conversation_id": "54fb8a9b-853a-4617-9196-bcd8c25b1a2f",
"router_decision": {
"mode": "follow_up_action",
"action_id": "show_first_result_details",
"confidence": 92,
"rewritten_intent": "Show the details of the latest incident result",
"reason": "The user is referring to the previously returned latest incident and asking to inspect it further, which matches the available follow-up action for showing the first result details."
}
}
}
View saved snapshots
{
"decision": "openai_agent",
"tool_result_status": "found",
"results_snapshot": [
{
"id": 86,
"platform_name": "Dispatch App",
"module_name": "Incident Records",
"record_type": "incident",
"full_name": "Test",
"reference_number": "DISP-INC-90",
"synced_at": "2026-06-04 05:55:25",
"payload_fields": {
"incident_id": 90,
"reference_number": "DISP-INC-90",
"emergency_id": 173,
"incident_type": "Test",
"address": "15.0360928, 120.6984739",
"status": "resolved",
"assigned_at": "2025-06-27 05:18:27",
"resolved_at": "2025-06-27 05:28:07",
"created_at": "2025-06-27 05:18:27",
"updated_at": "2025-06-27 05:28:07"
},
"status": "resolved",
"address": "15.0360928, 120.6984739"
}
],
"master_person_snapshot": null,
"summary_snapshot": {
"intent": "Find the most recent incident record received",
"tables_used": [
"synced_records"
],
"row_count": 1,
"display_fields": [
"id",
"platform_name",
"module_name",
"record_type",
"full_name",
"reference_number",
"synced_at",
"payload_fields"
],
"safe_sql_was_validated": true,
"query_source": "ai_sql_plan",
"payload_reading": "enabled_safe_payload_fields_only"
},
"metadata": {
"ip_address": "119.94.164.58",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36",
"created_from": "chatbot_ui",
"conversation_id": "54fb8a9b-853a-4617-9196-bcd8c25b1a2f",
"router_decision": {
"mode": "new_request",
"action_id": null,
"confidence": 92,
"rewritten_intent": "Ask for the most recent incident received",
"reason": "The user is asking a new query about the latest incident, not clearly continuing one of the available follow-up actions."
}
}
}
View saved snapshots
{
"decision": "openai_agent",
"tool_result_status": "found",
"results_snapshot": [
{
"total_incidents": 0
}
],
"master_person_snapshot": null,
"summary_snapshot": {
"intent": "Count today's incident records for the Dispatch App",
"tables_used": [
"synced_records"
],
"row_count": 1,
"display_fields": [
"total_incidents"
],
"safe_sql_was_validated": true,
"query_source": "ai_sql_plan",
"payload_reading": "enabled_safe_payload_fields_only"
},
"metadata": {
"ip_address": "119.94.164.58",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36",
"created_from": "chatbot_ui",
"conversation_id": "54fb8a9b-853a-4617-9196-bcd8c25b1a2f",
"router_decision": {
"mode": "new_request",
"action_id": null,
"confidence": 100,
"rewritten_intent": "how many total incidents do i have today?",
"reason": "No previous suggested actions are available."
}
}
}
View saved snapshots
{
"decision": "openai_agent",
"tool_result_status": "found",
"results_snapshot": [
{
"id": 194,
"platform_name": "Patient Booking",
"module_name": "Appointment Requests",
"record_type": "appointment_request",
"full_name": "Buten Dball Master",
"reference_number": "BOOKING-REQ-89",
"synced_at": "2026-06-04 08:08:56",
"payload_fields": {
"appointment_request_id": 89,
"reference_number": "BOOKING-REQ-89",
"user_id": 8,
"patient_id": 5,
"patient_name": "Buten Dball Master",
"patient_mobile": "9222222222",
"patient_birthdate": "1946-02-20",
"doctor_id": 3,
"doctor_name": "Alvin Galang Penafiel",
"doctor_specialty": "Internal Medicine",
"clinic": "Emergency Department",
"date": "2026-06-04",
"start": "08:07:06",
"end": "09:07:06",
"status": "approved",
"reason": "Emergency response: asdjasjondfpas nf",
"is_synced_to_emr": "true",
"created_at": "2026-06-04 16:07:06",
"updated_at": "2026-06-04 16:07:06"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "approved"
},
{
"id": 193,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "asdjasjondfpas nf",
"reference_number": "DISP-EMG-309",
"synced_at": "2026-06-04 08:08:50",
"payload_fields": {
"emergency_id": 309,
"reference_number": "DISP-EMG-309",
"incident": "asdjasjondfpas nf",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359390",
"longitude": "120.6983170",
"status": "unread",
"created_at": "2026-06-04 16:07:00",
"updated_at": "2026-06-04 16:07:00"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "unread"
},
{
"id": 192,
"platform_name": "Patient Booking",
"module_name": "Appointment Requests",
"record_type": "appointment_request",
"full_name": "Buten Dball Master",
"reference_number": "BOOKING-PAT-5",
"synced_at": "2026-06-04 08:07:06",
"payload_fields": {
"patient_id": 5,
"reference_number": "BOOKING-PAT-5",
"full_name": "Buten Dball Master",
"first_name": "Buten",
"middle_name": "Dball",
"last_name": "Master",
"birthdate": "1946-02-20",
"age": "80",
"gender": "Unknown",
"civil_status": "Unknown",
"height": null,
"weight": null,
"mobile": "9222222222",
"telephone": null,
"type_of_transaction": "Emergency",
"card_number": "DISP-EMG-287",
"address": null,
"notes": "[2026-06-02 14:58:07] Emergency auto-booking from Dispatch App. Emergency ID: 286. Incident: Emergency. Related records attached: 8.\n[2026-06-02 14:58:35] Emergency auto-booking from Dispatch App. Emergency ID: 287. Incident: Emergency. Related records attached: 9.\n[2026-06-02 14:59:02] Emergency au...",
"occupation": null,
"company_name": null,
"guardian_name": null,
"relationship": null,
"guardian_address": null,
"referring_physician": null,
"primary_care_physician": null,
"referring_institution": null,
"created_at": "2026-06-02 14:58:07",
"updated_at": "2026-06-03 16:32:30"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": "9222222222",
"birthdate": "1946-02-20",
"address": null,
"confidence_status": null,
"age": "80",
"gender": "Unknown"
},
{
"id": 116,
"platform_name": "Patient Booking",
"module_name": "Appointment Requests",
"record_type": "appointment_request",
"full_name": "Buten Dball Master",
"reference_number": "BOOKING-REQ-84",
"synced_at": "2026-06-04 08:07:06",
"payload_fields": {
"appointment_request_id": 84,
"reference_number": "BOOKING-REQ-84",
"user_id": 8,
"patient_id": 5,
"patient_name": "Buten Dball Master",
"patient_mobile": "9222222222",
"patient_birthdate": "1946-02-20",
"doctor_id": 3,
"doctor_name": "Alvin Galang Penafiel",
"doctor_specialty": "Internal Medicine",
"clinic": "Emergency Department",
"date": "2026-06-02",
"start": "09:03:59",
"end": "10:03:59",
"status": "approved",
"reason": "Emergency response: cmvbcvbmvcnmbvcbvc",
"is_synced_to_emr": "true",
"created_at": "2026-06-02 17:04:00",
"updated_at": "2026-06-02 17:04:00"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "approved"
},
{
"id": 114,
"platform_name": "Patient Booking",
"module_name": "Appointment Requests",
"record_type": "appointment_request",
"full_name": "Buten Dball Master",
"reference_number": "BOOKING-REQ-86",
"synced_at": "2026-06-04 08:07:06",
"payload_fields": {
"appointment_request_id": 86,
"reference_number": "BOOKING-REQ-86",
"user_id": 8,
"patient_id": 5,
"patient_name": "Buten Dball Master",
"patient_mobile": "9222222222",
"patient_birthdate": "1946-02-20",
"doctor_id": 3,
"doctor_name": "Alvin Galang Penafiel",
"doctor_specialty": "Internal Medicine",
"clinic": "Emergency Department",
"date": "2026-06-03",
"start": "08:32:29",
"end": "09:32:29",
"status": "approved",
"reason": "Emergency response: heasdasd",
"is_synced_to_emr": "true",
"created_at": "2026-06-03 16:32:07",
"updated_at": "2026-06-03 16:32:30"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "approved"
},
{
"id": 40,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "Help Emergency",
"reference_number": "DISP-EMG-273",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 273,
"reference_number": "DISP-EMG-273",
"incident": "Help Emergency",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359470",
"longitude": "120.6982950",
"status": "read",
"created_at": "2026-05-20 09:24:28",
"updated_at": "2026-05-20 09:24:52"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "read"
},
{
"id": 39,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "Help i need rescue",
"reference_number": "DISP-EMG-274",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 274,
"reference_number": "DISP-EMG-274",
"incident": "Help i need rescue",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359490",
"longitude": "120.6982950",
"status": "read",
"created_at": "2026-05-20 13:02:20",
"updated_at": "2026-05-20 13:02:32"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "read"
},
{
"id": 38,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "help",
"reference_number": "DISP-EMG-275",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 275,
"reference_number": "DISP-EMG-275",
"incident": "help",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359490",
"longitude": "120.6982950",
"status": "read",
"created_at": "2026-05-20 14:43:03",
"updated_at": "2026-05-20 14:43:16"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "read"
},
{
"id": 36,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "12",
"reference_number": "DISP-EMG-278",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 278,
"reference_number": "DISP-EMG-278",
"incident": "12",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359380",
"longitude": "120.6983080",
"status": "read",
"created_at": "2026-05-21 16:02:45",
"updated_at": "2026-05-21 16:02:54"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "read"
},
{
"id": 31,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "Accident help pls",
"reference_number": "DISP-EMG-283",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 283,
"reference_number": "DISP-EMG-283",
"incident": "Accident help pls",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359370",
"longitude": "120.6983220",
"status": "unread",
"created_at": "2026-06-02 13:53:43",
"updated_at": "2026-06-02 13:53:43"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "unread"
},
{
"id": 30,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "Accident help pls",
"reference_number": "DISP-EMG-284",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 284,
"reference_number": "DISP-EMG-284",
"incident": "Accident help pls",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359370",
"longitude": "120.6983220",
"status": "read",
"created_at": "2026-06-02 13:53:46",
"updated_at": "2026-06-02 13:56:41"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "read"
},
{
"id": 29,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "helpmeaccidenthere",
"reference_number": "DISP-EMG-285",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 285,
"reference_number": "DISP-EMG-285",
"incident": "helpmeaccidenthere",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359410",
"longitude": "120.6982960",
"status": "unread",
"created_at": "2026-06-02 14:55:04",
"updated_at": "2026-06-02 14:55:04"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "unread"
},
{
"id": 28,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "heasdasd",
"reference_number": "DISP-EMG-286",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 286,
"reference_number": "DISP-EMG-286",
"incident": "heasdasd",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359530",
"longitude": "120.6982340",
"status": "read",
"created_at": "2026-06-02 14:57:46",
"updated_at": "2026-06-02 16:49:17"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "read"
},
{
"id": 27,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "heasdasd",
"reference_number": "DISP-EMG-287",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 287,
"reference_number": "DISP-EMG-287",
"incident": "heasdasd",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359530",
"longitude": "120.6982340",
"status": "unread",
"created_at": "2026-06-02 14:58:08",
"updated_at": "2026-06-02 14:58:08"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "unread"
},
{
"id": 26,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "heasdasd",
"reference_number": "DISP-EMG-288",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 288,
"reference_number": "DISP-EMG-288",
"incident": "heasdasd",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359530",
"longitude": "120.6982340",
"status": "unread",
"created_at": "2026-06-02 14:58:34",
"updated_at": "2026-06-02 14:58:34"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "unread"
},
{
"id": 25,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "heasdasd",
"reference_number": "DISP-EMG-289",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 289,
"reference_number": "DISP-EMG-289",
"incident": "heasdasd",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359530",
"longitude": "120.6982340",
"status": "unread",
"created_at": "2026-06-02 14:59:01",
"updated_at": "2026-06-02 14:59:01"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "unread"
},
{
"id": 24,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "heasdasd",
"reference_number": "DISP-EMG-290",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 290,
"reference_number": "DISP-EMG-290",
"incident": "heasdasd",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359530",
"longitude": "120.6982340",
"status": "unread",
"created_at": "2026-06-02 14:59:29",
"updated_at": "2026-06-02 14:59:29"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "unread"
},
{
"id": 23,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "heasdasd",
"reference_number": "DISP-EMG-291",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 291,
"reference_number": "DISP-EMG-291",
"incident": "heasdasd",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359530",
"longitude": "120.6982340",
"status": "unread",
"created_at": "2026-06-02 14:59:57",
"updated_at": "2026-06-02 14:59:57"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "unread"
},
{
"id": 22,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "heasdasd",
"reference_number": "DISP-EMG-292",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 292,
"reference_number": "DISP-EMG-292",
"incident": "heasdasd",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359530",
"longitude": "120.6982340",
"status": "unread",
"created_at": "2026-06-02 15:00:22",
"updated_at": "2026-06-02 15:00:22"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "unread"
},
{
"id": 21,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "heasdasd",
"reference_number": "DISP-EMG-293",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 293,
"reference_number": "DISP-EMG-293",
"incident": "heasdasd",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359530",
"longitude": "120.6982340",
"status": "unread",
"created_at": "2026-06-02 15:00:44",
"updated_at": "2026-06-02 15:00:44"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "unread"
},
{
"id": 20,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "heasdasd",
"reference_number": "DISP-EMG-294",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 294,
"reference_number": "DISP-EMG-294",
"incident": "heasdasd",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359530",
"longitude": "120.6982340",
"status": "unread",
"created_at": "2026-06-02 15:01:09",
"updated_at": "2026-06-02 15:01:09"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "unread"
},
{
"id": 19,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "heasdasd",
"reference_number": "DISP-EMG-295",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 295,
"reference_number": "DISP-EMG-295",
"incident": "heasdasd",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359530",
"longitude": "120.6982340",
"status": "unread",
"created_at": "2026-06-02 15:01:35",
"updated_at": "2026-06-02 15:01:35"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "unread"
},
{
"id": 18,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "heasdasd",
"reference_number": "DISP-EMG-296",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 296,
"reference_number": "DISP-EMG-296",
"incident": "heasdasd",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359530",
"longitude": "120.6982340",
"status": "unread",
"created_at": "2026-06-02 15:02:00",
"updated_at": "2026-06-02 15:02:00"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "unread"
},
{
"id": 17,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "heasdasd",
"reference_number": "DISP-EMG-297",
"synced_at": "2026-06-04 05:55:10",
"payload_fields": {
"emergency_id": 297,
"reference_number": "DISP-EMG-297",
"incident": "heasdasd",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359530",
"longitude": "120.6982340",
"status": "unread",
"created_at": "2026-06-02 15:02:06",
"updated_at": "2026-06-02 15:02:06"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "unread"
},
{
"id": 16,
"platform_name": "Dispatch App",
"module_name": "Emergency Reports",
"record_type": "emergency",
"full_name": "heasdasd",
"reference_number": "DISP-EMG-298",
"synced_at": "2026-06-04 05:55:09",
"payload_fields": {
"emergency_id": 298,
"reference_number": "DISP-EMG-298",
"incident": "heasdasd",
"reported_by": "Buten Dball Master",
"reporter_phone": "9222222222",
"latitude": "15.0359530",
"longitude": "120.6982340",
"status": "read",
"created_at": "2026-06-02 15:02:06",
"updated_at": "2026-06-02 16:48:57"
},
"master_person_id": null,
"master_person_code": null,
"master_full_name": null,
"phone": null,
"birthdate": null,
"address": null,
"confidence_status": null,
"status": "read"
}
],
"master_person_snapshot": null,
"summary_snapshot": {
"intent": "Search for a person or record matching the phrase in synced records and master persons",
"tables_used": [
"synced_records",
"platform_person_links",
"master_persons"
],
"row_count": 25,
"display_fields": [
"id",
"platform_name",
"module_name",
"record_type",
"full_name",
"reference_number",
"synced_at",
"payload",
"master_person_id",
"master_person_code",
"master_full_name",
"phone",
"birthdate",
"address",
"confidence_status"
],
"safe_sql_was_validated": true,
"query_source": "ai_sql_plan",
"payload_reading": "enabled_safe_payload_fields_only"
},
"metadata": {
"ip_address": "119.94.164.58",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36",
"created_from": "chatbot_ui",
"conversation_id": "4c6b346c-975c-4a1a-a2b4-fd5c2901e547",
"router_decision": {
"mode": "new_request",
"action_id": null,
"confidence": 100,
"rewritten_intent": "find buten dball master",
"reason": "No previous suggested actions are available."
}
}
}
View saved snapshots
{
"decision": "openai_agent",
"tool_result_status": "not_found",
"results_snapshot": [],
"master_person_snapshot": null,
"summary_snapshot": {
"intent": "Search for a person or record matching the name phrase across synced records and master persons",
"tables_used": [
"synced_records",
"master_persons"
],
"row_count": 0,
"display_fields": [
"platform_name",
"module_name",
"record_type",
"full_name",
"reference_number",
"synced_at",
"payload_fields",
"master_person_code",
"master_full_name",
"phone",
"birthdate",
"address",
"confidence_status"
],
"safe_sql_was_validated": true,
"query_source": "ai_sql_plan",
"payload_reading": "enabled_safe_payload_fields_only"
},
"metadata": {
"ip_address": "119.94.164.58",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36",
"created_from": "chatbot_ui",
"conversation_id": "4c6b346c-975c-4a1a-a2b4-fd5c2901e547",
"router_decision": {
"mode": "new_request",
"action_id": null,
"confidence": 100,
"rewritten_intent": "find Master Dball Buten",
"reason": "No previous suggested actions are available."
}
}
}
View saved snapshots
{
"decision": "openai_agent",
"tool_result_status": "not_found",
"results_snapshot": [],
"master_person_snapshot": null,
"summary_snapshot": {
"intent": "Search for records matching the name or keyword 'buten master' across synced records and master persons",
"tables_used": [
"synced_records",
"master_persons"
],
"row_count": 0,
"display_fields": [
"full_name",
"reference_number",
"platform_name",
"module_name",
"record_type",
"synced_at",
"payload_fields"
],
"safe_sql_was_validated": true,
"query_source": "ai_sql_plan",
"payload_reading": "enabled_safe_payload_fields_only"
},
"metadata": {
"ip_address": "119.94.164.58",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36",
"created_from": "chatbot_ui",
"conversation_id": "4c6b346c-975c-4a1a-a2b4-fd5c2901e547",
"router_decision": {
"mode": "new_request",
"action_id": null,
"confidence": 100,
"rewritten_intent": "find buten master",
"reason": "No previous suggested actions are available."
}
}
}