Filtering of records in a form based on real type of array field

Finance and Operations/AX Developer Forum
1

Hi all,

I have an issue with filtering of records on a form (which I am trying to add in executequery of the form datasource) based on real type of field which is of array type.

My requirement is
I have a field say field1 (real type) which is of array type.(i.e I have fields as
field1(0), field1(1), field1(2), field1(3), field1(4) )
I have records in the table as

Record1 5 0 5 0 0
Record2 2 5 6 5 8
Record3 0 0 0 0 0
Record4 0 0 0 4 5
Record5 0 0 0 0 0
(The values above are values of field(0) ,field(1) ,field(2) ,field(3) ,field(4) respectively)

Now I want only those records in the form which have values of any of the fields field(0) ,field(1) ,field(2) ,field(3) ,field(4) to be non-zero (for the above example only record1 , record2 and record4)
Am trying it out in the executequery method of the datasource but unable to write the query for real type of array field.

Can anybody help me out on this ?

Thanks in Advance !!

2

see this link http://www.axaptapedia.com/Expressions_in_query_ranges

3

I have already gone through that link , but could not make it for real type of array filed.

If possible could you please provide me the query for real type of array field.

Thanks in advance !!

4

I think using Arrays in query have some limitations - let me check with this.

5

Can anybody please help me out on this asap as this a pretty urgent issue for the client ?

Thanks in Advance

6

I can suggest you an alternative way.

You add a new field to the Table - NoYesId

And update this field when all the values of the array elements are zero.

Now use this NoYesId in the executeQuery method- It will solve your problem indirectly.

7

Actually I should not change the Table structure.

All I can do is use the existing fields and filter the data.

8

This is still an issue for me . Can anybody please help me out on this ?