Hello!
Is there any way to set a column filter from a custom action in the graph?
Like:
Answer
Set column filters from code
Best answer by aaghaei
Assuming what you are showing here is result of a public view then yes you can.
If you want your public view be filtered by a fixed value like True/False or any similar constants, then just rewrite your public view in graph ext (use the same view name but with revised where statements)
If you want your view results change by some dynamic parameters, then you will need a view delegate in the graph ext which is a bit more complex. In the delegate then you can append the desired view by WhereAnd<> or WhereOr<> or even set a whole new where statement by WhereNew<>
+10Assuming what you are showing here is result of a public view then yes you can.
If you want your public view be filtered by a fixed value like True/False or any similar constants, then just rewrite your public view in graph ext (use the same view name but with revised where statements)
If you want your view results change by some dynamic parameters, then you will need a view delegate in the graph ext which is a bit more complex. In the delegate then you can append the desired view by WhereAnd<> or WhereOr<> or even set a whole new where statement by WhereNew<>
Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Assuming what you are showing here is result of a public view then yes you can.
If you want your public view be filtered by a fixed value like True/False or any similar constants, then just rewrite your public view in graph ext (use the same view name but with revised where statements)
If you want your view results change by some dynamic parameters, then you will need a view delegate in the graph ext which is a bit more complex. In the delegate then you can append the desired view by WhereAnd<> or WhereOr<> or even set a whole new where statement by WhereNew<>
Thanks aaghaei.
I’ve tried using a view delegate. But the problem here is that I would like to keep the original view results, and just filter the records the user would see on the grid after executing an action.
When I tried the view delegate the results are modified on every reload.
+10It is exactly what I meant by passing parameters. If a parameter for example is provided then you filter by its value otherwise you show all. If you want the filtered result as initial display, then you can set your default parameter value in code and user can reset the filter if needed or vice versa
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.