Infinity SDK: Cannot export custom listbuilder if image field is sorted

An error occurs when exporting a custom Listbuilder that is sorted on its image column.

Error: The file could not be downloaded. {"message": "This ad-hoc query includes one of more fields that have been removed from the underlying source query view. You can edit the query to see more information and make appropriate adjustments."}
We're currently evaluating this issue for a fix in a future patch or service pack.  

Workaround: Do not sort on the image column, or sort on a different column. This will download the file, but the image column will not exist in the Excel file (even though the image is stored in Blackbaud.AppFx.Browser.exe).

Steps to Duplicate

1) Create a QueryViewSpec with a Listbuilder section. In the SQL, include this in the SELECT section (case clause optional): 'res:warning' AS IMAGE
In the OutputField section, include this: <OutputField Name="Image" Caption="Icon" DataType="String" IsImageKey="true" />
Do not sort on the Image column. Save this spec, copy it to \bin\custom, and load it.

2) In CRM, enter Page Designer and create a custom tab on the Constituent page.
3) On the new tab section, use the following settings:
SectionType: Listbuilder
SectionDisplayStyle: Block
QueryView: "YourQueryViewSpecName"
ContextType: PageContext
Style: StandardGridView

4) The listbuilder displays the image column with the warning icon.
5) Sort the image column on ascending or descending.
6) Use the 'More' drop-down to export the Listbuilder to Excel as .xlsx.
7) See error.


 Blackbaud Infinity SDK

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.