Best Practice for AiF Queries

[ideveloper]

Hi.

I have a Query for an AiF-Service which is build with ca. 5 Tables.
The disadvantage of this is the overhead of the Service schema. It could deliver me all fields of the tables, but I need only 5 of them.

Is it a best practice solution to build the Query with the "drag and drop" Method or should I create a display field in the custom table, where I try to get the values from the according tables.

Or is there an another solution to minimize the schema?

Tanks.

Regards
ideveloper

[kashperuk]

Can't you just turn off (remove) the fields you don't need from the schema?

[ideveloper]

Hi.

I create the AIF-Service (and the schema) with the AIF Document Service Wizard. It gets a Query as an input value.
The fields in the query can not be deleted.

[kashperuk]

Well, so, first of all, you should change the fields on the query (you need to set the property Dynamic on the Fields node to No, and then manually add only the fields you need).

But also, in the service setup, you can control, which fields are visible/mandatory/etc.
I don't have an AX 2009 version here, but you should be able to find it - it's somewhere under AIF setup.

[ideveloper]

Thank you for the answer.
This solution works well.

[kashperuk]

OK, just to clarify for others that might be reading this in a couple of months:
The setup is found on Endpoints, and is called Data policies.