Maximum Any/All Depth

ozgur_agi · May 26, 2020, 9:53am

Hello,
I created a datagrid with a relatively deep expand chain. I used a filter which used 2 nested any's. On the OData query, I get an error as follows:

"The Any/All nesting limit of '1' has been exceeded. 'MaxAnyAllExpressionDepth' can be configured on ODataQuerySettings or EnableQueryAttribute."

I see that the parameter is here. However, I could not know where/how to integrate this new parameter to the radzen project (not experienced in C#). Can you please help me with this?

Best,

enchev · May 26, 2020, 11:37am

Hi @ozgur_agi,

We can add it to EnableQueryAttribute similar to MaxExpansionDepth and MaxNodeCount settings:

github.com

akorchev/radzen/blob/master/CRMDemo/server/Controllers/CRM/ContactsController.cs#L34


[Route("mvc/odata/CRM/Contacts")]
public partial class ContactsController : ODataController
{
  private Data.CrmContext context;


  public ContactsController(Data.CrmContext context)
  {
    this.context = context;
  }
  // GET /odata/Crm/Contacts
  [EnableQuery(MaxExpansionDepth=10,MaxNodeCount=1000)]
  [HttpGet]
  public IEnumerable<Models.Crm.Contact> GetContacts()
  {
    var items = this.context.Contacts.AsQueryable<Models.Crm.Contact>();
    this.OnContactsRead(ref items);


    return items;
  }


  partial void OnContactsRead(ref IQueryable<Models.Crm.Contact> items);

For example MaxAnyAllExpressionDepth=10. Will this work for you?

ozgur_agi · May 26, 2020, 12:29pm

Thank you for the help. I added it to the initial controller and added that file to "Ignore code generation list" (since it was replaced if I dont do it.)

Now all works, thanks