Custom load data: order by does not work

Radzen Studio Angular
1

Hello,
I have put custom code below in grid loadData() but now I click on columns to change sort order and I see the query always sort using second column.
Can you help me?
This is the code:

grid0LoadData(event: any) {
if ((this.recenti.value==false || this.recenti.value==null) && ("am" !== this.security.user.roles[0])) {
this.ricocoDb.getRicocoConRuolos(${event.filter} and (Ruolo eq '${this.security.user.roles[0]}'), event.top, event.skip, ${event.orderby}, event.top != null && event.skip != null, null, null, null)
.subscribe((result: any) => {
this.getRicocosResult = result.value;

  this.getRicocosCount = event.top != null && event.skip != null ? result['@odata.count'] : result.value.length;
  }, (result: any) => {

  });
}

if ((this.recenti.value==false || this.recenti.value==null) && ("am" ===  this.security.user.roles[0])) {
      this.ricocoDb.getRicocoConRuolos(`${event.filter}`, event.top, event.skip, ``, event.top != null && event.skip != null, null, null, null)
  .subscribe((result: any) => {
      this.getRicocosResult = result.value;

  this.getRicocosCount = event.top != null && event.skip != null ? result['@odata.count'] : result.value.length;
  }, (result: any) => {

  });
}

if (this.recenti.value==true && ("am" !==  this.security.user.roles[0])) {
      this.ricocoDb.getRecentiConRuolos(`${event.filter} and (Ruolo eq '${this.security.user.roles[0]}')`, event.top, event.skip, `${event.orderby}`, event.top != null && event.skip != null, null, null, null)
  .subscribe((result: any) => {
      this.getRicocosResult = result.value;

  this.getRicocosCount = event.top != null && event.skip != null ? result['@odata.count'] : result.value.length;
  }, (result: any) => {

  });
}

if (this.recenti.value==true && ("am" ===  this.security.user.roles[0])) {
      this.ricocoDb.getRecentiConRuolos(`${event.filter}`, event.top, event.skip, ``, event.top != null && event.skip != null, null, null, null)
  .subscribe((result: any) => {
      this.getRicocosResult = result.value;

  this.getRicocosCount = event.top != null && event.skip != null ? result['@odata.count'] : result.value.length;
  }, (result: any) => {

  });
}

}

2

Can you log this value to see if it is the correct one? You can use console.log(event.orderby)

I saw that one of the invokes is missing the ${event.orderby} altogether - it passes empty string instead:

  this.ricocoDb.getRecentiConRuolos(`${event.filter}`, event.top, event.skip, ``, event.top != null && event.skip != null, null, null, null)

Is this intended?

3

In some invoke the "orderby" parameter takes no value.
In others invokes the orderby wants a value and it is infact ${event.orderby} as you suggested.
I do not know why in someone is not needed but now it works.
Thanks,
Mario