$expand nested properties

[Kelly Harrison]

I'm able to $expand multiple levels of nested properties as follows:

        this.query = new Query().expand('Product($expand=Customer)');

While this works, it is awkward to manipulate the odata uri this way and I don't know if it's supported.  Is there a better way to do this?  Traditional dot-style property notation in <e-column> doesn't seem to make the DataManager add the $expand option to the uri.

Thanks!

-k

[Thavasianand Sankaranarayanan]

Hi Kelly, 

Thanks for contacting us. 

You can manipulate the expand Query using “query” property of Grid as like the below way. Please refer the code example and sample from the link below, 

App.component.html 

<div class="control-section"> 

    <ejs-grid #grid [dataSource]='data' [query]="query" [pageSettings]='pageSettings'> 

            <e-columns> 

            <e-column field='UserName' headerText='Customer ID' width='160'></e-column> 

            <e-column field='FirstName' width='120' textAlign='Right'></e-column> 

            <e-column field='LastName' width='150' ></e-column> 

        </e-columns> 

    </ejs-grid> 

 

</div> 

App.component.ts 

const SERVICE_URI: string = 'https://services.odata.org/V4/(S(0j5uiuuhvaybfuc2llcclf3g))/TripPinServiceRW/People'; 

 

@Component({ 

    selector: 'app-root', 

    templateUrl: 'app.component.html' 

}) 

export class AppComponent { 

    public data: DataManager;  

    public pageSettings: Object;  

public query:any 

    @ViewChild('grid',{static: true}) 

    public grid: GridComponent; 

 

    ngOnInit(): void { 

        this.data= new DataManager({ url: SERVICE_URI, adaptor: new ODataV4Adaptor }) 

        this.query = new Query().expand('Trips'); 

    } 

} 

Sample: https://stackblitz.com/edit/angular-147985-expand?file=app.component.html 

Screenshot:  

 

Please get backto us, if you need further assistance. 

Regards, 

Thavasianand S. 

[Kelly Harrison]

That's exactly what I'm doing.  However, that doesn't answer the question of nested properties with multiple levels.  In my case, it's something like this:

ProductInventory -> Product -> Customer

In the grid displaying ProductInventory data, I want to show the Customer name.  Using .expand('Product.Customer') doesn't work while my method does.  However that doesn't seem to be the way the API is meant to be used.

[Manivel Sellamuthu]

Hi Kelly, 

 

Thanks for your update. 

 

We havevalidated your requirement. you can expand multiple levels by nesting the expand param. Please find the below nested expand query. 

 

 this.query = new Query().expand('Products($expand=Customer)');  

 

Please get back to us, if you need further assistance. 

 

Regards, 

Manivel