We are currently performing maintenance on Appian Community. As a result, discussions posts and replies are temporarily unavailable. We appreciate your patience.

How to get filter value of the recordType into a specific variable

Hi,

I am using a read-only grid with data as "recordType" and I was able to load the gridcolumns. So far so good.

Now I am trying to download the data using "exportDataStoreEntityToExcel"  smart service .

Now, then I try to pass pass the selected filter value to the "exportDataStoreEntityToExcel", it is not working.

Is there away I can get filter value of the recordType into a specific variable?

filters: a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "disabled",
operator: "=",
value: 'recordType!{3b28d66a-bc4f-445a-ade2-11f4b0bb38cf}LA Leads.filters.{ab7a2ca5-0634-4536-a28b-8904f23d0e04}Disabled'
)

},
ignoreFiltersWithEmptyValues: true
)

  Discussion posts and replies are publicly visible

Parents
  • See, these are the issues you face when you don't wanna use OOTB Export excel feature of Record based grids and instead try to duplicate the same functionality using Export DSE to Excel SS. There is no way you can save user filter values in any variable inside grid cause user filters and export are record functionalities.

    The alternative here is to create custom filters which will look exactly like record user filters using combinations of cardLayout, sidebysideLayout and dopdownField and save the values in localVariables.

    Now, since you can't use recordType as your data source in grid (due to custom filters) you will have to query the DSE or recordType whichever you prefer with the selected custom filters and pass the resultant datasubset to the data parameter in gridField and likely pass those filters in Export DSE to Excel SS too.

    I will strongly recommend to go with the OOTB Export feature only until and unless there is some real cause for not using it.

Reply
  • See, these are the issues you face when you don't wanna use OOTB Export excel feature of Record based grids and instead try to duplicate the same functionality using Export DSE to Excel SS. There is no way you can save user filter values in any variable inside grid cause user filters and export are record functionalities.

    The alternative here is to create custom filters which will look exactly like record user filters using combinations of cardLayout, sidebysideLayout and dopdownField and save the values in localVariables.

    Now, since you can't use recordType as your data source in grid (due to custom filters) you will have to query the DSE or recordType whichever you prefer with the selected custom filters and pass the resultant datasubset to the data parameter in gridField and likely pass those filters in Export DSE to Excel SS too.

    I will strongly recommend to go with the OOTB Export feature only until and unless there is some real cause for not using it.

Children