Join of 1 x N

[vitorvk2]

Hello everything is fine? @ujjwalguptaofficial

I want to know if it is possible to perform a JOIN of 1 x N

Where all JOIN elements are inside an array.

Example:

const tblCustomerChats = {
	name: 'CustomerChats',
	columns: {
	    id: {
		primaryKey: true,
		autoIncrement: false,
		dataType: DATA_TYPE.Number,
	    },
	    hash: {
		dataType: DATA_TYPE.String,
	    },
	    message: {
		dataType: DATA_TYPE.String,
	    },
	}
}

const tblCustomerChatReactions = {
	name: 'CustomerChatReactions',
	columns: {
	    id: {
		primaryKey: true,
		autoIncrement: false,
		dataType: DATA_TYPE.Number,
	    },
	    reaction_text: {
		dataType: DATA_TYPE.String
	    },
	    customer_chat_id: {
		dataType: DATA_TYPE.Number,
	    }
	}
}

return:

{
	id : 1,
	hash: "fseFGSEG4",
	message: "Hello"
	reactions: [
		{id: 23, reaction_text: ":)", customer_chat_id: 1}
		{id: 25, reaction_text: ":(", customer_chat_id: 1}
		{id: 50, reaction_text: ">:(", customer_chat_id: 1}
	]
}

[ujjwalguptaofficial]

no query wise its not possible, but you can use get it logically.

way 1

1. Get all chats id
2. Loop through chat ids and query chat reaction

use transactions for faster results - https://jsstore.net/docs/transaction