CODEWITHSUNDEEP
methodsaxaptax++dynamics-ax-2012dynamic-queries
Sturla
Sturla

Reputation: 3626

Dynamics AX 2012, filtering out data in queries by using business logis

I am using Dynamics AX 2012 R2.

I am creating a query for a view where I have to filter out data based on predefined business logic.

For example, I have one table in my query (simplified) and I want to be able to filter out rows in the view where the sum of value1 and value2 and value3 are equal to zero.

I cannot use the query range in the query since I have around 20 values (columns) that I need to check before I filter out the rows. It doesn´t allow it, it only handles around 10 values or so

I dont like creating a "full" view, e.g. view with all rows then a view method with the business logic that has to be applied to filter out the rows and then a query based on that view where the rows are filter out.

Do you have any ideas?

Upvotes: 1

Views: 2134

Answers (1)

Jan B. Kjeldsen
Jan B. Kjeldsen

Reputation: 18051

Why not make a computed view field for the sum of your fields?

I dont like creating a "full" view, e.g. view with all rows then a view method with the business logic that has to be applied to filter out the rows and then a query based on that view where the rows are filter out.

You are cutting out a useful method (but you need not make any queries).

Another approach would be to make a redundant field in your base table with your 20 fields added.

Update: Please read View Basics.

Upvotes: 1

Related Questions