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
>