Hi all,
grid field is showing the error when I am query entity to view the data in the interface, the CDT are of the ARRAY type. when I am removing the filter I am getting this error if I keep the filter I am getting another error. can you please help me with this error.
a!localVariables( local!VerificationDecision, local!listingetails:a!queryEntity( entity: cons!SHA_LISTING_DS, query: a!query( selection: a!querySelection( columns: { a!queryColumn( field:"propertyTypeIdFk", alias:"propertyTypeIdFk" ), a!queryColumn( field:"propertyName", alias:"propertyName" ), a!queryColumn( field:"propertyAddress", alias:"propertyAddress" ), a!queryColumn( field:"propertyDescription", alias:"propertyDescription" ), a!queryColumn( field:"floorPlanName", alias:"floorPlanName" ), a!queryColumn( field:"neighborhood", alias:"neighborhood" ), a!queryColumn( field:"price", alias:"price" ), a!queryColumn( field:"squareFootage", alias:"squareFootage" ), a!queryColumn( field:"bedRooms", alias:"bedRooms" ), a!queryColumn( field:"bathRooms", alias:"bathRooms" ), a!queryColumn( field:"pets", alias:"pets" ), a!queryColumn( field:"doubleOccupancy", alias:"doubleOccupancy" ), } ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "listingId", operator: "in", value: ri!listing, applywhen: not(isnull(ri!listing)) )}, ignoreFiltersWithEmptyValues: true ), pagingInfo:a!pagingInfo( startIndex: 1, batchSize: -1, sort: a!sortInfo( field:"listingId", ascending: true() ) ),), fetchTotalCount: true() ).data,
local!ammenityDetails:a!queryEntity( entity: cons!SHA_NEWAMMENITIES, query: a!query( selection: a!querySelection( columns: { a!queryColumn( field:"listingIdFk", alias:"listingIdFk" ), a!queryColumn( field:"ammenityTypeIdFk", alias:"ammenityTypeIdFk" ) }
), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "ammenityId", operator: "=", value: ri!ammenity, applywhen: not(isnull(ri!ammenity)) )}, ignoreFiltersWithEmptyValues: true ), pagingInfo:a!pagingInfo( startIndex: 1, batchSize: -1, sort: a!sortInfo( field:"ammenityId", ascending: true() ) ),
), fetchTotalCount: true() ).data,
if( or(isnull(local!VerificationDecision), isnull(ri!listing) ), a!sectionLayout( label: "Student Status", contents: { a!gridField( label: "listingId", labelPosition: "ABOVE", data: a!queryEntity( entity: cons!SHA_LISTING_DS, query: a!query( /*filter: a!queryFilter(*/ /*field: "listingId",*/ /*operator: "=",*/ /*value: tointeger(index(local!listingetails.data,"listingId",null()))*/ /*),*/ pagingInfo: fv!pagingInfo ), fetchTotalCount: true ), columns: { a!gridColumn( label: "listingId", sortField: "listingId", value: a!linkField( links: { a!dynamicLink( label: fv!row.listingId, value: fv!row.listingId, saveInto: {local!VerificationDecision, a!save(ri!listing,a!queryEntity( entity: cons!SHA_LISTING_DS, query: a!query( filter: a!queryFilter( field: "listing", operator: "=", value: local!VerificationDecision, applyWhen: isnull(local!VerificationDecision)=false ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1
) ) ).data
), a!save(ri!button_txt,null
) } ) } ), align: "END" ), a!gridColumn( label: "Property Name", sortField: "propertyName", value: a!linkField( links: { a!dynamicLink( label: fv!row.propertyName, value: fv!row.listing, saveInto: {local!VerificationDecision, a!save(ri!listing,a!queryEntity( entity: cons!SHA_LISTING_DS, query: a!query( filter: a!queryFilter( field: "listing", operator: "=", value: local!VerificationDecision, applyWhen: isnull(local!VerificationDecision)=false ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1
)
} ) } ) ), a!gridColumn( label: "price", sortField: "price", value: fv!row.price ), a!gridColumn( label: "squareFootage", sortField: "squareFootage", value: fv!row.squareFootage ),
}, pageSize: 10, initialSorts: { a!sortInfo( field: "listingId", ascending: false ) }, pagingSaveInto: local!listingetails, validations: {}, spacing: "DENSE", height: "AUTO", borderStyle: "STANDARD", refreshAlways: true ) }, showWhen:or(isnull(local!VerificationDecision), isnull(ri!listing)), isCollapsible: true ),
rule!SHA_readonlyinterface() )
Discussion posts and replies are publicly visible
try this..........
/* ...your code... */
local!listingDetails: a!queryEntity( entity: cons!SHA_LISTING_DS, query: a!query( selection: a!querySelection(columns: { /* ...columns... */ }), filter: if(not(isnull(ri!listing)), a!queryFilter( field: "listingId", operator: "EQUALS", value: ri!listing ), null ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1, sort: a!sortInfo(field: "listingId", ascending: true) ) ), fetchTotalCount: true)
/* ...your code code... */