Set 'X' dynamically in 'next x days filter' in Advanced Find

Question

In my custom Dashboard, I would like to show a list of data. When I am creating a custom view using Advance Find, I am using "next x days" filter. Can I set that 'X' dynamically from my custom field? Each row can have different X.

I can do this using SQL Reporting Services, but I would like to prefer normal list. Is there a way or do I have to use report?

Thank you.

score 0 · Answer 1 · edited Jun 04 '13 at 19:20

Actually it looks impossible to do this without some workaround customization! (To my knowledge). But you could change condition filters with a plugin every time it loads. To do this, you could create a new entity and a numeral field on it. Every time the dashboard loads you could change the condition of the view by replacing the value from that entity. The below snippet helps you in the plugin:

public void Execute(IServiceProvider serviceProvider)
        {
            // Obtain the execution context from the service provider.
            IPluginExecutionContext context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext));


         if (context.Mode == 0 && context.Stage == 20 && context.MessageName.Equals("RetrieveMultiple"))          
         {
            if (context.InputParameters.Contains("Query"))
            {
                if (context.InputParameters["Query"] is QueryExpression)
                {
                    QueryExpression objQueryExpression = (QueryExpression)context.InputParameters["Query"];

                    if (objQueryExpression.EntityName == "account")
                    {
                        IOrganizationServiceFactory serviceFactory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory));
                        IOrganizationService  service = serviceFactory.CreateOrganizationService(context.UserId);
                        ConditionExpression privateFlagCondition;


                            privateFlagCondition = new ConditionExpression()
                            {
                                AttributeName = "statustype",
                                Operator = ConditionOperator.Equal,
                                Values = { "1" }
                            };


                        FilterExpression newFilter = new FilterExpression()
                        {
                            FilterOperator = LogicalOperator.Or,
                            Conditions = { privateFlagCondition }
                        };

                        objQueryExpression.Criteria.AddFilter(newFilter);
                    }

                }
            }
        }
    }

Set 'X' dynamically in 'next x days filter' in Advanced Find

1 Answers1