Hi ,
Actually , I have argent requirement that i need to create a filter using text field but I'm not able to archive ...
here is my code
load( local!fetch, local!pagingInfo:a!pagingInfo( startIndex:1, batchSize: cons!batch_no, sort:a!sortInfo( field:"projId", ascending:true())), with( local!StudentsData:a!queryEntity( entity:cons!RQA_double_item_ENTITY, query:a!query( filter:a!queryFilter( field:"field", operator:"=", value:ri!PorjectID ), pagingInfo:local!pagingInfo ), fetchTotalCount: true() ), { a!sectionLayout( label: "Fetch Details", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Students ID", required: true(), value: local!fetch, saveInto: local!fetch ), a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Search", value: local!fetch, submit: true() ) }, align: "START" ) } ), } ) } ), a!sectionLayout( label: "Students Details", contents:{ if(rule!RQA_checkIsNullOrEmpty(local!StudentsData), a!richTextDisplayField(label:"",value: "No Data Available"), a!gridField( label: "", totalCount:local!StudentsData.totalCount, columns: { if(rf!requesttype=cons!RQA_VALUES[1], a!gridTextColumn( label: "Students ID", field: "student", data: index(local!StudentsData.data,"student",{}), alignment: "CENTER" ),{}), a!gridTextColumn( label: "ClassID", field: "classid", data: index(local!StudentsData.data,"classid",null), alignment: "CENTER" ), ... .. .. ... .. .. .. }, value: local!pagingInfo, saveInto: local!pagingInfo, rowHeader: 1 /*selection: true()*/ ) ) }, isCollapsible:true()) } ) )
Discussion posts and replies are publicly visible
Hi
So you need to filter on two fields PorjectID and StudentId. for multiple filters you need to use a!queryLogicalExpression() in your query entity like
a!queryEntity(entity: cons!RQA_double_item_ENTITY,query: a!query(pagingInfo: local!pagingInfo,logicalExpression: a!queryLogicalExpression(operator: "AND",filters: {a!queryFilter(field: "field",operator: "=",value: ri!PorjectID),if(isnull(local!fetch),{},a!queryFilter(field: "StudentId",operator: "=",value: local!fetch))})),fetchTotalCount: true())