Thread: Retrieve Specific Fields with Built-in Operative

When using WSI to retrieve information, is it possible to specify which fields are wanted?

For example a simple operation to get all Manufacturers gets the entire table:

<AspDotNetStorefrontImport Verbose="false">
<GetEntityHelper EntityType="Manufacturer"/>
</AspDotNetStorefrontImport>

Is there a way to get only ID and Name?

I know I can do this using embedded SQL but then I have to include the db name and we have multiple copies of aspdnsf and they all have different db names which makes the programming much more difficult.

The only way to achieve what you want would be like below, other than that customization is required:

<ExecuteSQL Name="string">
<SQL>
<![CDATA[
select FieldName from TableName where whatever clause you want
]]>
</SQL>
</ExecuteSQL>

Alfred,

I believe that method requires the db name. I just built my sql with a db_name variable that I fill in at run time depending on which site was selected.

It's not as "clean" as I'd like but it works OK.

Thanks for your response.

Tom