Sql Server
Question

I have used this query in sql widget but getting warning , how can I remove this warning ?

Please Refer Attachement.


doubt.png

Solution

Hey @Sangam 

This cause just because you are printing *(all column) which is may not get mapped with output structure you have added.
The better way solution is to add {tablename}.columnname in select for those column which you have added in structure.

Hope you understand.

Thanks

Yogesh

Hi Sangam, Instead of * you need to select entity attribute same as your output parameter type. Thanks Vinod
Solution

Hey @Sangam 

This cause just because you are printing *(all column) which is may not get mapped with output structure you have added.
The better way solution is to add {tablename}.columnname in select for those column which you have added in structure.

Hope you understand.

Thanks

Yogesh

Hi Sangam, Instead of * you need to select entity attribute same as your output parameter type. Thanks Vinod
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.