snapshot_comments

3 rows where snapshot_pk = 16

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: status_text, comment_timestamp (date)

comment_pk ▼ snapshot_pk ordinal complaint_id mobile_number comment_timestamp status_text posted_by remarks raw_comment_json
30 16 16 1 106255287909 9000701350 2025-09-20T10:59:05Z Attended By Officer P Srinivasa Rao phone number updated as per your request {"id": "106255287909", "mobile_number": "9000701350", "posted_by": "P Srinivasa Rao", "remarks": "phone number updated as per your request", "status": "Attended By Officer", "time_stamp": "20-SEP-2025 16:29:05"}
31 16 16 2 106255287909 9989930662 2025-06-02T07:02:38Z Open M.A. Quadeer pertains to Cir.5 Saroornagar {"id": "106255287909", "mobile_number": "9989930662", "posted_by": "M.A. Quadeer", "remarks": "pertains to Cir.5 Saroornagar", "status": "Open", "time_stamp": "02-JUN-2025 12:32:38"}
32 16 16 3 106255287909 7416998336 2025-05-31T19:19:37Z Open akshayakshay issue is only with , mobile number updation..upon chnage of owner. rest of all mutation is done correctly. akshay agaldiviti is the owner with mobile number 7416998336. the statu 'pending with dc for approval' is shown for mobile number updation {"id": "106255287909", "mobile_number": "7416998336", "posted_by": "akshayakshay", "remarks": "issue is only with , mobile number updation..upon chnage of owner. rest of all mutation is done correctly. akshay agaldiviti is the owner with mobile number 7416998336. the statu 'pending with dc for approval' is shown for mobile number updation", "status": "Open", "time_stamp": "01-JUN-2025 00:49:37"}

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE snapshot_comments (
    comment_pk INTEGER PRIMARY KEY,
    snapshot_pk INTEGER NOT NULL REFERENCES complaint_snapshots(snapshot_pk) ON DELETE CASCADE,
    ordinal INTEGER NOT NULL,
    complaint_id TEXT NOT NULL,
    mobile_number TEXT NOT NULL,
    comment_timestamp TEXT NOT NULL,
    status_text TEXT NOT NULL,
    posted_by TEXT NOT NULL,
    remarks TEXT NOT NULL,
    raw_comment_json TEXT NOT NULL,
    UNIQUE(snapshot_pk, ordinal)
);