budibase-comment-box icon indicating copy to clipboard operation
budibase-comment-box copied to clipboard

Comment Box not visualizing _existing_ comment records supplied from a DB text field

Open aMacDawg opened this issue 4 months ago • 1 comments

Expected/desired outcome: As a Budibase user, I have a table that stores 'chat logs' that I would like to use the Budibase Comment Box for visualizing these logs as individual chats similar to how the conversation would be experienced by an end-user in a conventional chat/messneger application

Current outcome: no 'comments' or messages are displayed despite a table being connected specifically with a comment string/text field that stores (stringified) JSON that conforms to this schema:

{
  "message": "This is a sample comment.",
  "email": "[email protected]",
  "name": "John Doe",
  "timestamp": 1633036800000
}

Current outcome/test case 2: I attempted to submit a new comment into my connected postgres environment, but upon entering some text and clicking the post button, I didn't see any request attempt when simultaneously inspecting the dev console

Edit: clarifying the relational (postgres) DB table - currently I'm storing each "comment" as its own record in a table specifically for storing these comments/messages. The comment field maps to my understanding of the model as storing a single stringified JSON in the schema described above, the other fields of this chat_comment table are:

| id | created_at (timestamp) | conversation_id (convo id as written from application logic) | comment (string) |

I have the comment box nested in a Data Provider component that maps from the table and I filter on each conversation_id value since this comment box component is opened in a modal

aMacDawg avatar Oct 13 '24 02:10 aMacDawg