Hi ,
I have requirement that i need to create a grid from process model ( Process task report ) and filter the data
load( local!pagingInfo: a!pagingInfo(startIndex: 1, batchSize:25), with( local!datasubset: a!queryProcessAnalytics( report: cons!MSL_TASK_REPORT_LEAD, contextProcessModels: cons!MSL_PARENT_PROCESS_MODEL, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "c1", operator: "=", value: if(rule!MSL_checkIsNullOrEmpty(ri!status)," ",ri!status), ), a!queryFilter( field: "c9", operator: "=", value: if(rule!MSL_checkIsNullOrEmpty(ri!SgorDg)," ",ri!SgorDg), ) }, ), pagingInfo: local!pagingInfo ) ), { a!boxLayout( label:"Tasks", style: "ACCENT", contents: a!sectionLayout( contents: { a!gridField_19r1( totalCount: local!datasubset.totalCount, value:local!pagingInfo, saveInto:local!pagingInfo, columns: { a!gridTextColumn( label:"Task Name", field:"c0", data:index(local!datasubset.data,"c0",{}), links:a!forEach( items:index(local!datasubset,"identifiers",{}), expression:a!processTaskLink( task:fv!item ) ) ), a!gridTextColumn( label:"Status", field:"c1", data:index(local!datasubset.data,"c1",{}) ), a!gridTextColumn( label:"Process", field:"c2", data:index(local!datasubset.data,"c2",{}) ), a!gridTextColumn( label:"Start Date", field:"c3", data:index(local!datasubset.data,"c3",{}) ), a!gridTextColumn( label:"Task Id", field:"c4", data:index(local!datasubset.data,"c4",{}) ), a!gridTextColumn( label:"Request Id", field:"c5", data:index(local!datasubset.data,"c5",{}) ), a!gridTextColumn( label:"Active Task", field:"c6", data:index(local!datasubset.data,"c6",{}) ), a!gridTextColumn( label:"Task Asignee", field:"c7", data:index(local!datasubset.data,"c7",{}) ), a!gridTextColumn( label:"Process Id", field:"c8", data:index(local!datasubset.data,"c8",{}) ), a!gridTextColumn( label:"SgorDg", field:"c9", data:index(local!datasubset.data,"c9",{}) ), a!gridTextColumn( label:"End Time ", field:"c11", data:index(local!datasubset.data,"c11",{}) ) } ) } ) ) } ) )
i passing this to my interface
load( local!Status, local!MSL_SDGD, local!pagingInfo:a!pagingInfo(startIndex: 1, batchSize: 25), { a!columnsLayout( columns: { a!columnLayout( contents: { a!dropdownField( label: "MSL_SDGD", labelPosition: "ABOVE", placeholderLabel: "--- Select a Value ---", choiceLabels: {cons!MSL_SDGD[1],cons!MSL_SDGD[2] }, choiceValues: {cons!MSL_SDGD[1],cons!MSL_SDGD[2]}, value:local!MSL_SDGD, saveInto: {local!MSL_SDGD}, validations: {} ) } ), a!columnLayout( contents: { a!dropdownField( label: "Status", labelPosition: "ABOVE", placeholderLabel: "--- Select a Value ---", choiceLabels: {cons!TSL_REQUEST_STARUS[1],cons!TSL_REQUEST_STARUS[2] }, choiceValues: {cons!TSL_REQUEST_STARUS[1],cons!TSL_REQUEST_STARUS[2]}, value:local!Status, saveInto: {local!Status}, validations: {} ) } ) } ), rule!MSL_Process_Report(SgOrDg:local!MSL_SDGD,status:local!Status) } )
my requirement is without selection it should show grid and if i will filter it show appropriate selection
thanks
Dan
Discussion posts and replies are publicly visible