DataGrid filtered by Parameter only if it is not null

Eugenio_Chiarello · December 4, 2020, 11:11am

Hello,
I have a page using a datagrid and each row open another page using aparameter eg. OperatorID, in new page I can filter by query the data by the parameter, but if the parameter is empty or not present I need to return all rows.
I'm trying to do this but I have some problems using expression.
Can someone help me writing a sample code?

Thank you

enchev · December 4, 2020, 2:50pm

This thread might help you:

Here is the actual code:

github.com

radzenhq/radzen-examples/blob/master/DefaultColumnFilter/meta/pages/orders.json#L140


      
            {
              "name": "$expand",
              "value": "Customer,Employee,Shipper"
            },
            {
              "name": "$count",
              "value": "event.top != null && event.skip != null"
            },
            {
              "name": "$filter",
              "value": "${event.filter ? event.filter + ' and ':''}${this.defaultOrderID ? 'OrderID eq ' + this.defaultOrderID : ''}"
            },
            {
              "name": "$orderby",
              "value": "${event.orderby}"
            },
            {
              "name": "$expand",
              "value": "Customer,Employee,Shipper"
            }
          ],

Eugenio_Chiarello · December 4, 2020, 4:26pm

Thank you all works great