Unexpected Advanced Query Warning

The Unexpected Advanced Query warning is issued in the following situations:

There is a mismatch between the number of columns SELECT'ed and the output structure in <query>: you have an advanced query whose output structure does not match the attributes being selected. This can happen because the number of attributes is different or because there is a data type mismatch.

Edit your advanced query and depending on your requirements, do one of the following: change the Output Structure of this query; or change the attributes being selected.

SELECT statements with 'Expand Inline' parameters cannot be validated against the output structure in <query>: since you have an advanced query with expand in line parameters, it is not possible to check whether the Output Structure matches the selected attributes.

You should open your Advanced query and check whether the Output Structure contains the necessary attributes to fetch the selected attributes, specified through the Inline parameters

SELECT statements with '*' cannot be validated against the output structure in <query>: since you are selecting all (*) the attributes of the involved entities in an advanced query, Service Studio is not able to confirm that the Output Structure matches these attributes.

You should open your Advanced query and check whether the Output Structure contains the necessary attributes to fetch the selected attributes. To avoid this warning it is advisable that you use SELECT {Entity}.* instead.

There is a mismatch between the SELECT'ed entities and the output structure in <query>: you are selecting the entities, in your advanced query, with SELECT {Entity}.* and the output structure includes these entities or entities with the same definition. In this situation, Service Studio is not able to confirm that the Output Structure matches the selected attributes. This warning is launched when, for example, you are selecting: SELECT {EntityA}.* , {EntityB}.* and the order in the Output structure is EntityB and EntityA.

You should change the order by which entities are selected to make it the same as the Output Structure.

Clicking the symbol will launch the Advanced query editor where the warning was detected.