N1QL join on any attribute


#1

Could I join 2 documents based on any attribute that is available in the document? For example, check below. I have 2 types of documents available in my bucket. Could I join these 2 docs based on customer_id. Plz note the customer_id is not the key/Document_id. I’m auto generating the key/Document_id based on UUID.

// Orders
{
“Test_Bucket”: {
“doc_type”: “orders”,
“order_id”: “1234-5678”,
“company_name”: “TEST Bank”,
“creation_date_time”: “20160111_161225862”,
“customer_id”: “INAB100190”

},
{
“Test_Bucket”: {
“doc_type”: “orders”,
“order_id”: “7589-3654”,
“company_name”: “TEST Bank”,
“creation_date_time”: “20160111_161225862”,
“customer_id”: “INAB100190”
}
}

// Customers
{
“Test_Bucket”: {
“doc_type”: “customer_info”,
“customer_id”: “JVBF100545"
“name”: “Mark”,
“email”: "mark@mark.com
},
{
“doc_type”: “customer_info”,
“customer_id”: “INAB100190"
“name”: “Steve”,
“email”: "steve@steve.com
}
}


#2

Currently, one document must be able to produce the primary key (ID) of the other document. General JOINs on any attribute are not yet supported.