Skip to main content
A
akshayg0006
Inspiring
February 8, 2021
Question

Have to remove one particular option in field

  • February 8, 2021
  • 6 replies
  • 0 views

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

    6 replies

    csteward
    csteward
    Brainy
    February 8, 2021

    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.  

    A
    akshayg0006Author
    Inspiring
    February 8, 2021

    Hi,

    I need to display data in grid(for which hv created a view) but while exporting in Excel i don't want  "best" to be exported to Excel, however the "best" field should be changed to a blank value " " in the export..

    csteward
    csteward
    Brainy
    February 8, 2021

    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.

    Terms & ConditionsAccessibility statement