You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@olingo.apache.org by Prerna Chawla <pr...@gmail.com> on 2014/06/20 08:49:22 UTC
Support for join
Hi
Is there any API providing support for join in ODATA ? Or it is just the
construction of URL using expand query option.
Thanks
Prerna
Re: Support for join
Posted by "Bolz, Michael" <mi...@sap.com>.
Hi Prerna,
As far as I know is a Full Outer Join not directly supported by OData
(either V2/V3/V4).
Kind regards,
Michael
From: Prerna Chawla <pr...@gmail.com>
Reply-To: "user@olingo.apache.org" <us...@olingo.apache.org>
Date: Montag, 23. Juni 2014 09:31
To: "user@olingo.apache.org" <us...@olingo.apache.org>
Subject: Re: Support for join
Hi Michael,
Thanks for your reply.In v4 according to this document
https://www.oasis-open.org/committees/download.php/46084/ODataExtensionforDa
taAggregationv1.0.pdf
implicitly expand means Left Outer Join.So the URL that you have provided
will give Left Outer Join.Is there any way for Full Outer Join? (in Odata
v4,as you said in v2 that is not possible)
Thanks,
Prerna
On Mon, Jun 23, 2014 at 11:42 AM, Mibo <mi...@apache.org> wrote:
> Hi Prerna,
>
> In OData V2 exists no system query option for an outer join.
> As you suggest a „$expand“ in combination with a „$select“ seems to be the
> choice for your use case.
> As example:
> "http://services.odata.org/V4/Northwind/Northwind.svc/Customers?$expand=Orders
> &$select=CompanyName,Orders“
> to expand and select the Customer with their name and Order information.
>
> Kind regards,
> Michael
>
>
>> On Jun 23, 2014, at 7:38 AM, Prerna Chawla <pr...@gmail.com> wrote:
>>
>> An example for more clarification.Sample database is given below
>> CustomerID----------------------CustomerName
>> 1 -----------------------------------Alfreds Futterkiste
>> 2------------------------------------Ana Trujillo
>> 3 ---------------------------------- Antonio Moreno
>> And a selection from the "Orders" table:
>> OrderID--------CustomerID
>> 10308------------------2
>> 10309-----------------37
>> 10310----------------77
>>
>> Output should be in case of Outer Join---
>> Name-------------------------------OrderId
>> Alfreds Futterkiste-----------------null
>> Ana Trujillo------------------------10308
>> Antonio Moreno----------------------null
>> null--------------------------------10309
>> null--------------------------------10310
>>
>> What will be OData URL that needs to be constructed for this case? I am not
>> able to figure it out(using OData v2)
>>
>>
>> On Fri, Jun 20, 2014 at 12:19 PM, Prerna
>> Chawla<pr...@gmail.com>wrote:
>>> Hi
>>>
>>> Is there any API providing support for join in ODATA ? Or it is just the
>>> construction of URL using expand query option.
>>>
>>> Thanks
>>> Prerna
>>
Re: Support for join
Posted by Prerna Chawla <pr...@gmail.com>.
Hi Michael,
Thanks for your reply.In v4 according to this document
https://www.oasis-open.org/committees/download.php/46084/ODataExtensionforDataAggregationv1.0.pdf
implicitly expand means Left Outer Join.So the URL that you have provided
will give Left Outer Join.Is there any way for Full Outer Join? (in Odata
v4,as you said in v2 that is not possible)
Thanks,
Prerna
On Mon, Jun 23, 2014 at 11:42 AM, Mibo <mi...@apache.org> wrote:
> Hi Prerna,
>
> In OData V2 exists no system query option for an outer join.
> As you suggest a „$expand“ in combination with a „$select“ seems to be the
> choice for your use case.
> As example:
> "
> http://services.odata.org/V4/Northwind/Northwind.svc/Customers?$expand=Orders&$select=CompanyName,Orders
> “
> to expand and select the Customer with their name and Order information.
>
> Kind regards,
> Michael
>
>
> On Jun 23, 2014, at 7:38 AM, Prerna Chawla <pr...@gmail.com>
> wrote:
>
> An example for more clarification.Sample database is given below
> CustomerID----------------------CustomerName
> 1 -----------------------------------Alfreds Futterkiste
> 2------------------------------------Ana Trujillo
> 3 ---------------------------------- Antonio Moreno
> And a selection from the "Orders" table:
> OrderID--------CustomerID
> 10308------------------2
> 10309-----------------37
> 10310----------------77
>
> Output should be in case of Outer Join---
> Name-------------------------------OrderId
> Alfreds Futterkiste-----------------null
> Ana Trujillo------------------------10308
> Antonio Moreno----------------------null
> null--------------------------------10309
> null--------------------------------10310
>
> What will be OData URL that needs to be constructed for this case? I am
> not able to figure it out(using OData v2)
>
>
> On Fri, Jun 20, 2014 at 12:19 PM, Prerna Chawla<pr...@gmail.com>
> wrote:
>
>> Hi
>>
>> Is there any API providing support for join in ODATA ? Or it is just the
>> construction of URL using expand query option.
>>
>> Thanks
>> Prerna
>>
>
>
Re: Support for join
Posted by Mibo <mi...@apache.org>.
Hi Prerna,
In OData V2 exists no system query option for an outer join.
As you suggest a „$expand“ in combination with a „$select“ seems to be the choice for your use case.
As example:
"http://services.odata.org/V4/Northwind/Northwind.svc/Customers?$expand=Orders&$select=CompanyName,Orders“
to expand and select the Customer with their name and Order information.
Kind regards,
Michael
> On Jun 23, 2014, at 7:38 AM, Prerna Chawla <pr...@gmail.com> wrote:
>
>
> An example for more clarification.Sample database is given below
> CustomerID----------------------CustomerName
> 1 -----------------------------------Alfreds Futterkiste
> 2------------------------------------Ana Trujillo
> 3 ---------------------------------- Antonio Moreno
> And a selection from the "Orders" table:
> OrderID--------CustomerID
> 10308------------------2
> 10309-----------------37
> 10310----------------77
>
>
> Output should be in case of Outer Join---
> Name-------------------------------OrderId
> Alfreds Futterkiste-----------------null
> Ana Trujillo------------------------10308
> Antonio Moreno----------------------null
> null--------------------------------10309
> null--------------------------------10310
>
>
> What will be OData URL that needs to be constructed for this case? I am not able to figure it out(using OData v2)
>
>
>
> On Fri, Jun 20, 2014 at 12:19 PM, Prerna Chawla<prernachawla30@gmail.com
>>wrote:
>> Hi
>> Is there any API providing support for join in ODATA ? Or it is just the construction of URL using expand query option.
>>
>>
>> Thanks
>> Prerna
>>
>>
>>
>
>
>
Re: Support for join
Posted by Prerna Chawla <pr...@gmail.com>.
An example for more clarification.Sample database is given below
CustomerID----------------------CustomerName
1 -----------------------------------Alfreds Futterkiste
2------------------------------------Ana Trujillo
3 ---------------------------------- Antonio Moreno
And a selection from the "Orders" table:
OrderID--------CustomerID
10308------------------2
10309-----------------37
10310----------------77
Output should be in case of Outer Join---
Name-------------------------------OrderId
Alfreds Futterkiste-----------------null
Ana Trujillo------------------------10308
Antonio Moreno----------------------null
null--------------------------------10309
null--------------------------------10310
What will be OData URL that needs to be constructed for this case? I am not
able to figure it out(using OData v2)
On Fri, Jun 20, 2014 at 12:19 PM, Prerna Chawla <pr...@gmail.com>
wrote:
> Hi
>
> Is there any API providing support for join in ODATA ? Or it is just the
> construction of URL using expand query option.
>
> Thanks
> Prerna
>