snapshot_comments

5 rows where snapshot_pk = 48

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: mobile_number, status_text, posted_by, remarks, comment_timestamp (date)

comment_pk ▼ snapshot_pk ordinal complaint_id mobile_number comment_timestamp status_text posted_by remarks raw_comment_json
72 48 48 1 103255140344 9100025128 2025-03-04T13:27:31Z Attended By Officer Sri. T.R.Prasad rectified {"id": "103255140344", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "04-MAR-2025 18:57:31"}
73 48 48 2 103255140344 9246180220 2025-03-03T14:19:04Z Attended By Officer asrinivasaRao problem not solved and ticket says it is resolved … lights still blinking and not working properly .pl resolve properly and solve the problem . without solving don’t close the tickets {"id": "103255140344", "mobile_number": "9246180220", "posted_by": "asrinivasaRao", "remarks": "problem not solved and ticket says it is resolved … lights still blinking and not working properly .pl resolve properly and solve the problem . without solving don’t close the tickets", "status": "Attended By Officer", "time_stamp": "03-MAR-2025 19:49:04"}
74 48 48 3 103255140344 9100025128 2025-03-03T13:11:49Z Attended By Officer Sri. T.R.Prasad rectified {"id": "103255140344", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "03-MAR-2025 18:41:49"}
75 48 48 4 103255140344 9100025128 2025-03-01T06:00:00Z Open Sri. T.R.Prasad f {"id": "103255140344", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "f", "status": "Open", "time_stamp": "01-MAR-2025 11:30:00"}
76 48 48 5 103255140344 9100025128 2025-03-01T01:41:16Z Open Sri. T.R.Prasad 2 {"id": "103255140344", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "2", "status": "Open", "time_stamp": "01-MAR-2025 07:11:16"}

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)
);