Drop down filtered on previous field

Radzen.Blazor Components
1

I have a page that has a drop down of customers and saves the customer ID to that field. next to customer drop down I have an opportunity drop down that has customer ID as one of the fields. I would like that if a user selects customer "A" in customer drop down I would like the opportunity drop down only show opportunities for customer "A". I tried using the query builder for opportunity drop down but no success. How do I do this / is there a sample anywhere I can use to learn how to do it? I am using Blazor Studio.

2

Check this demo:

3

Thanks I will have a look tomorrow. :slight_smile:

4

Ok so I had a look. I am using Radzen Studio and I am using partial classes so I am having a hard time converting your example. I am thinking I need to add the cu_cust_id filter in the following code, just not sure how:
protected async Task customerLookUpsLoadData(LoadDataArgs args)
{
try
{
var result = await DB_154253_radzencrmService.GetCustomerLookUps(new Query { Top = args.Top, Skip = args.Skip, Filter = args.Filter, OrderBy = args.OrderBy });

            customerLookUps = result.Value.AsODataEnumerable();
            customerLookUpsCount = result.Count;
        }
        catch (Exception)
        {
            NotificationService.Notify(new NotificationMessage { Severity = NotificationSeverity.Error, Summary = "Error", Detail = "Unable to load" });
        }
        try
        {
            var result = await DB_154253_radzencrmService.GetCustomerLookUps(top: args.Top, skip: args.Skip, count: args.Top != null && args.Skip != null, filter: args.Filter, orderby: args.OrderBy);

            customerLookUps = result.Value.AsODataEnumerable();
            customerLookUpsCount = result.Count;
        }
        catch (Exception)
        {
            NotificationService.Notify(new NotificationMessage { Severity = NotificationSeverity.Error, Summary = "Error", Detail = "Unable to load" });
        }
    }


    protected async Task opportunityLookUpsLoadData(LoadDataArgs args)
    {
        try
        {
            var result = await DB_154253_radzencrmService.GetOpportunityLookUps(new Query { Top = args.Top, Skip = args.Skip, Filter = args.Filter, OrderBy = args.OrderBy });

            opportunityLookUps = result.Value.AsODataEnumerable();
            opportunityLookUpsCount = result.Count;
        }
        catch (Exception)
        {
            NotificationService.Notify(new NotificationMessage { Severity = NotificationSeverity.Error, Summary = "Error", Detail = "Unable to load" });
        }
        try
        {
            var result = await DB_154253_radzencrmService.GetOpportunityLookUps(top: args.Top, skip: args.Skip, count:args.Top != null && args.Skip != null, filter: args.Filter, orderby: args.OrderBy);

            opportunityLookUps = result.Value.AsODataEnumerable();
            opportunityLookUpsCount = result.Count;
        }
        catch (Exception)
        {
            NotificationService.Notify(new NotificationMessage { Severity = NotificationSeverity.Error, Summary = "Error", Detail = "Unable to load" });
        }
    }
}

}