I have created a task report in that status column showing as 0,1 and 2 like that but i want to show that as a text like "Assigned", :Completed" like this.
Could you please help me on this? when i tried with below code. i am getting the error as "Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!forEach [line 18]: Error in a!forEach() expression during iteration 7: Expression evaluation error at function a!forEach [line 32]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function 'index' parameter 2 [line 54]: Cannot add incompatible operands of type List of User or Group and type Number (Integer)."
load( local!pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 5 ), with( local!report: a!queryProcessAnalytics( report: cons!MY_TASKS_REPORT, query: a!query( pagingInfo: local!pagingInfo ) ), a!gridField( label: local!report.name, instructions: local!report.description, totalCount: local!report.totalCount, columns: { a!forEach( items: local!report.columnConfigs, expression: with( local!columnData: index( local!report.data,fv!item.field,{}), local!columnDataCount: count( local!columnData), /*local!configuredFormatting: local!report.columnConfigs.configuredFormatting,*/ local!configuredFormatting:apply(tostring(_),local!report.columnConfigs.configuredFormatting), a!gridTextColumn( label: fv!item.label, field: fv!item.field, data:with( local!label:fv!item.label, local!field:fv!item.field, if( local!columnDataCount > 0, a!forEach( items: local!columnData, expression: if( contains(local!configuredFormatting,"TASK_STATUS"), index( { "Assigned", "Accepted", "Completed", "Not Started", "Cancelled", "Paused", "Unattended", "Aborted", "Cancelled By Exception", "Submitted", "Running", "Error" }, /* * Task status ids start with 0, so add one to reach the first index */ tointeger(index(local!columnData, fv!item + 1, -1 )), "Other" ), tostring(fv!item) ) ), {} )), links: if( fv!item.configuredDrilldown = "TASK_DETAILS", a!forEach( items: index( local!report.data, fv!item.drilldownField, {} ), expression: a!processTaskLink( task: fv!item ) ), null ) ) ) ) }, value: local!pagingInfo, saveInto: local!pagingInfo ) ) )
Discussion posts and replies are publicly visible
sukheshc0001 ,
Please go through the below article.
https://community.appian.com/discussions/f/general/8749/status-value-of-task-if-is-not-attended
Hope this resolve your issue..!