I need to join two tables that don't have a direct link, by using nested data
I have table 1 that looks like
{
NumberIdentifier: "Test",
NestedData: {
OtherIdentifier: "Test2"
}
}
And table 2 that looks like
{
NumberIdentifier: "Test",
OtherIdentifer: "Test2"
}
Number identifer cannot be guaranteed to be unique, so I'm trying to join on both
I've gotten as far as
Table1.findMany( {
select: {
Table2: {
OtherIdentifier: true
}}}}
But can't find any way to finish this without doing post query data processing, which I really want to avoid if possible.
I'm open to computed fields, but those don't seem to work on nested data either.
{
NumberIdentifier: "Test",
NestedData: {
OtherIdentifier: "Test2"
}
}
And table 2 that looks like
{
NumberIdentifier: "Test",
OtherIdentifer: "Test2"
}
Number identifer cannot be guaranteed to be unique, so I'm trying to join on both
I've gotten as far as
Table1.findMany( {
select: {
Table2: {
OtherIdentifier: true
}}}}
But can't find any way to finish this without doing post query data processing, which I really want to avoid if possible.
I'm open to computed fields, but those don't seem to work on nested data either.
