Have to remove one particular option in field

Question

Hi, 
 i have written a query filter which is working fine and displayed that in interface. 
 Now i need to download Excel which is also working fine but i need not have to include option: best 
 
 Suppose i have a drop down field which contains values: Good, better, best. But when i download Excel i should not see best option in Excel(instead it should be blank ) ..but the value in complete row should be downloaded. 
 applyWhen: {rule!AAP_isNotEmpty(ri!Status),remove(ri!Status,wherecontains("best",touniformstring(ri!Status)))} 
 
 Can someone help with what change i should do in code

Chris · Answer

To confirm, you DO want the row containing "best" to be exported to Excel, however the "best" field should be changed to a blank value "" in the export? If this is the case, typically it would be done on the database side by creating a view which removes this value, then export to Excel over the view - as we are limited as far as data manipulation between the DB and Excel during export.

Chris · Answer

The only way I could see to do this within Appian is with the deprecated "Export CDT to Excel" service - in which you can prepare the CDT (remove these values) prior to creating the Excel document. Otherwise, there isn't really a way to manipulate the data between the DB and your Excel file, so a view would be required on the database which handles this removal - then you can export from the view, vs the actual data store.

Have to remove one particular option in field

Top Replies