Hi All,
I have a requirement tehre is column in a table story multiple values with text datatype
and when I'm trying to filter them on grid using filters then I'm using this code to show on filter dropdown: line 68-82
then getting dropdown as this::
But from first screenshot when I'm trying to search any one of the data from array example: 213396 then my grid is displaying empty data and for other data as well who are in array in gridhelp me achieve this,Thankyou!
Discussion posts and replies are publicly visible
Can you share the code of your filter?
sure here is the code for filter:
here SLS_QRY_getWorkOrderDropdownData is ER for calling field of that particular table , I have attached code for this ER as well
a!localVariables( local!queryResult: a!queryRecordType( recordType: 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync', fields: a!aggregationFields( groupings: { a!grouping( field:ri!fieldName, alias: "data" ) } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 5000 ) ).data, local!data:Index(local!queryResult,"data",{}), union(local!data,local!data) )
local!activityIDDropdownValues: reject( fn!isnull, rule!SLS_QRY_getWorkOrderDropdownData( FieldName: 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{526678f5-f98a-4f93-a22c-aa7c05df57ab}maestroRefId' ), ), local!activityIDDropdownMultipleValues: if( length(trim(split( local!activityIDDropdownValues, ";"))) > 1, trim(split( local!activityIDDropdownValues, ";")), local!activityIDDropdownValues ), a!columnLayout( contents: { a!multipleDropdownField( choiceLabels: union(local!activityIDDropdownMultipleValues,local!activityIDDropdownMultipleValues), choiceValues: union(local!activityIDDropdownMultipleValues,local!activityIDDropdownMultipleValues), label: "Activity ID", placeholder: "--Select Activity ID --", value: local!currentActivityID, saveInto: { local!currentActivityID, a!save(local!selectedActivityID, null) }, searchDisplay: "ON" ) }, width: "AUTO" ),
Where and how do you apply that filter? I would expect to see an a!queryFilter() somewhere.
a!localVariables( local!selectedValue, local!selectedValueStatus: rule!SLS_QRY_getWorkOrderCurrentStatus(recordId: local!selectedValue), local!selectedValuefiltered: reject( fn!isnull, a!forEach( items: local!selectedValueStatus, expression: if( fv!item['recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{59c88299-7c3c-485c-8e80-116509932002}status'] > "2", fv!item, null ) ) ), local!refresh: 0, local!activityPaging: a!pagingInfo( startIndex: 1, batchSize: cons!SLS_INT_BATCH_SIZE, sort: a!sortInfo( field: 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{39638375-b861-45d8-a71c-8ac4277de8a1}IdSLSWorkOrder', ascending: false ) ), local!siteId: index( index( rule!SLS_QRY_getWorkOrderDetails(siteName: null), "data", {} ), 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{5577e033-0e7e-41a3-9522-db47d0f4779e}siteID', {} ), local!SiteIds: Index( todatasubset( a!forEach( local!siteId, 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync'( 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{5577e033-0e7e-41a3-9522-db47d0f4779e}siteID': fv!item ) ), local!activityPaging ).Data, 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{5577e033-0e7e-41a3-9522-db47d0f4779e}siteID', {} ), local!siteData: rule!SLS_GetSiteDetailsFromMaestro( SiteIds: local!SiteIds, fields: { 'recordType!{0e049d77-e6eb-4df6-a780-729a9ee508f2}Site.fields.{idSiteLocation}idSiteLocation', 'recordType!{0e049d77-e6eb-4df6-a780-729a9ee508f2}Site.fields.{siteId}siteId', 'recordType!{0e049d77-e6eb-4df6-a780-729a9ee508f2}Site.fields.{siteName}siteName' } ), local!workOrderDropdownValues: rule!SLS_QRY_getWorkOrderDropdownData( FieldName: 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{39638375-b861-45d8-a71c-8ac4277de8a1}IdSLSWorkOrder' ), local!currentWorkOrder, local!isSLSEditor: a!isUserMemberOfGroup( loggedInUser(), { cons!SLS_GROUP_APP_EDITORS, cons!SLS_GROUP_EDITORS } ), local!selectedWorkOrder, local!currentSiteID, local!selectedSiteID, local!activityIDDropdownValues: reject( fn!isnull, rule!SLS_QRY_getWorkOrderDropdownData( FieldName: 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{526678f5-f98a-4f93-a22c-aa7c05df57ab}maestroRefId' ), ), local!activityIDDropdownMultipleValues: if( length(trim(split( local!activityIDDropdownValues, ";"))) > 1, trim(split( local!activityIDDropdownValues, ";")), local!activityIDDropdownValues ), local!currentActivityID, local!selectedActivityID, local!assignedToDropdownValues: reject( fn!isnull, union( touniformstring(rule!SLS_QRY_getWorkOrderDropdownData( FieldName: 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{33409ebc-43db-4ffd-b572-71918cb216da}assignedTo' )), touniformstring(loggedInUser())) ), local!currentAssignedTo: loggedInUser(), local!selectedAssignedTo: loggedInUser(), local!selectedStatus, local!statusDropdownValues: rule!SLS_QRY_getWorkOrderStatus(isActive: true), local!currentStatus: index( local!statusDropdownValues['recordType!{dd9d5db9-e3a0-42a9-9e24-2a4dc07db855}SLS Work Order Status Sync.fields.{0f14af3c-c0de-4010-a9b9-7e29f719f59f}idWorkorderStatus'], { 1, 2 }, "" ), local!sourceDropdownValues: reject( fn!isnull, rule!SLS_QRY_getWorkOrderDropdownData( FieldName: 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{c25af599-da0e-42a0-9250-8c25a3821525}source' ) ), local!CurrentSource, local!SelectedSource, local!currentCreatedBy, local!selectedCreatedBy, local!isApplyFilterButtonDisabled: and( a!isNullOrEmpty(local!currentWorkOrder), a!isNullOrEmpty(local!currentSiteID), a!isNullOrEmpty(local!currentActivityID), a!isNullOrEmpty(local!currentAssignedTo), a!isNullOrEmpty(local!currentStatus), a!isNullOrEmpty(local!CurrentSource), a!isNullOrEmpty(local!selectedCreatedBy) ), local!selectedRows, local!getWorkOrderDetails: rule!SLS_QRY_getWorkOrderSync( selectedWorkOrder: local!selectedWorkOrder, selectedSiteID: local!selectedSiteID, selectedActivityID: local!selectedActivityID, selectedAssignedTo: local!selectedAssignedTo, selectedStatus: local!selectedStatus, SelectedSource: local!SelectedSource, selectedCreatedBy: local!selectedCreatedBy, refresh: local!refresh ), { rule!SLS_PageHeaderTitle(Title: cons!SLS_SITE_TITLES[3]), a!sectionLayout( contents: a!cardLayout( contents: { a!sectionLayout( label: "Filters", labelSize: "EXTRA_SMALL", labelColor: cons!TWM_ACCENT_COLOR, contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!multipleDropdownField( choiceLabels: a!forEach( items: local!workOrderDropdownValues, expression: rule!SLS_Format_WorkOrderID(fv!item) ), choiceValues: local!workOrderDropdownValues, label: "Work Order", placeholder: "--Select Work Order --", value: local!currentWorkOrder, saveInto: { local!currentWorkOrder, a!save(local!selectedWorkOrder, null) }, searchDisplay: "ON" ) }, width: "AUTO" ), a!columnLayout( contents: { a!pickerFieldCustom( label: "Site ID", maxSelections: 1, placeholder: "--Select Site ID--", suggestFunction: rule!SLS_QRY_GetSiteCustomFieldPicker(SiteName: _), selectedLabels: a!defaultValue(local!currentSiteID, null), value: tostring(local!currentSiteID), saveInto: { local!currentSiteID }, ), }, width: "AUTO" ), a!columnLayout( contents: { a!multipleDropdownField( choiceLabels: union(local!activityIDDropdownMultipleValues,local!activityIDDropdownMultipleValues), choiceValues: union(local!activityIDDropdownMultipleValues,local!activityIDDropdownMultipleValues), label: "Activity ID", placeholder: "--Select Activity ID --", value: local!currentActivityID, saveInto: { local!currentActivityID, a!save(local!selectedActivityID, null) }, searchDisplay: "ON" ) }, width: "AUTO" ), } ), a!columnsLayout( columns: { a!columnLayout( contents: a!dropdownField( choiceLabels: a!forEach( items: local!sourceDropdownValues, expression: rule!APN_displayUser(fv!item) ), choiceValues: local!sourceDropdownValues, label: "Source", placeholder: "--Select Source--", value: local!CurrentSource, saveInto: { local!CurrentSource, a!save(local!SelectedSource, null) } ), width: "AUTO" ), a!columnLayout( contents: a!multipleDropdownField( choiceLabels: a!forEach( items: local!assignedToDropdownValues, expression: rule!APN_displayUser(fv!item) ), choiceValues: local!assignedToDropdownValues, label: "Assigned To", placeholder: "--Select Assigned To--", value: touniformstring(local!currentAssignedTo), saveInto: { local!currentAssignedTo, a!save(local!selectedAssignedTo, null) } ), width: "AUTO" ), a!columnLayout( contents: a!multipleDropdownField( choiceLabels: index( local!statusDropdownValues, 'recordType!{dd9d5db9-e3a0-42a9-9e24-2a4dc07db855}SLS Work Order Status Sync.fields.{22dddfa3-5b42-4204-805c-6c9257c1e641}description', null ), choiceValues: touniformstring( index( local!statusDropdownValues, 'recordType!{dd9d5db9-e3a0-42a9-9e24-2a4dc07db855}SLS Work Order Status Sync.fields.{0f14af3c-c0de-4010-a9b9-7e29f719f59f}idWorkorderStatus', null ) ), label: "Status", placeholder: "--Select Status--", value: touniformstring(local!currentStatus), saveInto: { local!currentStatus, a!save(local!selectedStatus, null) } ), width: "AUTO" ), } ), a!buttonArrayLayout( Buttons: { a!buttonWidget( label: "Apply Filters", icon: "check", saveInto: { a!save( local!selectedWorkOrder, local!currentWorkOrder ), a!save( local!selectedSiteID, local!currentSiteID ), a!save( local!selectedActivityID, local!currentActivityID ), a!save( local!selectedAssignedTo, local!currentAssignedTo ), a!save( local!selectedStatus, local!currentStatus ), a!save( local!SelectedSource, local!CurrentSource ), a!save( local!selectedCreatedBy, local!currentCreatedBy ) }, color: cons!TC_TEXT_COLOR_MEDIUM_PURPLE, disabled: local!isApplyFilterButtonDisabled ), a!buttonWidget( label: "Clear Filters", icon: "times", saveInto: { a!save(local!currentWorkOrder, null), a!save(local!selectedWorkOrder, null), a!save(local!currentSiteID, null), a!save(local!selectedSiteID, null), a!save(local!currentActivityID, null), a!save(local!selectedActivityID, null), a!save(local!currentAssignedTo, null), a!save(local!selectedAssignedTo, null), a!save(local!currentStatus, null), a!save(local!selectedStatus, null), a!save(local!CurrentSource, null), a!save(local!SelectedSource, null), a!save(local!currentCreatedBy, null), a!save(local!selectedCreatedBy, null), }, color: "NEGATIVE", disabled: local!isApplyFilterButtonDisabled ) }, align: "END" ) }, isCollapsible: true, isInitiallyCollapsed: false, marginAbove: "STANDARD", marginBelow: "NONE" ) }, height: "AUTO", showWhen: true(), style: "NONE", shape: "ROUNDED", padding: "LESS", marginAbove: "NONE", marginBelow: "STANDARD", showBorder: false, showShadow: true ), marginBelow: "NONE" ), a!columnsLayout( columns: { a!columnLayout(width: "WIDE_PLUS"), a!columnLayout(width: "MEDIUM_PLUS"), a!columnLayout( contents: a!cardLayout( contents: { a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!richTextIcon( icon: "plus-square", showWhen: true, color: "POSITIVE", size: "MEDIUM" ) }, tooltip: cons!SLS_TEXT[35], align: "CENTER" ) }, link: a!startProcessLink( processModel: cons!SLS_PM_CREATE_EDIT_WORK_ORDER, processParameters: { WorkOrderSync: null } ), shape: "SEMI_ROUNDED", accessibilityText: "Create New " ), width: "EXTRA_NARROW" ), a!columnLayout( contents: { a!cardLayout( contents: a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!richTextIcon( icon: "pencil-square-o", color: if( a!isNotNullOrEmpty(local!selectedValue), "ACCENT", cons!TC_TEXT_COLOR_SHUTTLE_GREY ), size: "MEDIUM" ) }, tooltip: if( a!isNullOrEmpty(local!selectedValue), cons!SLS_TEXT[36], cons!SLS_TEXT[37] ), align: "CENTER" ), link: a!startProcessLink( processModel: cons!SLS_PM_CREATE_EDIT_WORK_ORDER, processParameters: { idWorkOrder: local!selectedValue, WorkOrderSync: null }, showWhen: if( a!isNotNullOrEmpty(local!selectedValue), true, false ) ), style: if( a!isNotNullOrEmpty(local!selectedValue), "NONE", "STANDARD" ), shape: "SEMI_ROUNDED", marginAbove: "NONE" ) }, width: "EXTRA_NARROW" ), a!columnLayout( contents: { a!cardLayout( contents: a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!richTextIcon( icon: "trash", color: if( and( a!isNotNullOrEmpty(local!selectedValue), a!isNullOrEmpty(local!selectedValuefiltered) ), "NEGATIVE", cons!TC_TEXT_COLOR_SHUTTLE_GREY ), size: "MEDIUM" ) }, tooltip: if( a!isNullOrEmpty(local!selectedValue), cons!SLS_TEXT[36], cons!SLS_TEXT[38] ), align: "CENTER" ), link: a!startProcessLink( processModel: cons!SLS_PM_CREATE_EDIT_WORK_ORDER, processParameters: { WorkOrderSync: local!selectedRows, isDelete: true, idWorkOrder: local!selectedValue }, showWhen: if( a!isNullOrEmpty(local!selectedValuefiltered, ), true, false ), ), style: if( a!isNotNullOrEmpty(local!selectedValue), "NONE", "STANDARD" ), shape: "SEMI_ROUNDED", marginAbove: "NONE" ) }, width: "EXTRA_NARROW" ) }, showWhen: local!isSLSEditor ), a!columnsLayout( columns: { a!columnLayout( contents: { a!gridField( labelPosition: "ABOVE", data: local!getWorkOrderDetails, columns: { a!gridColumn( label: "Work Order ID", sortField: 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{39638375-b861-45d8-a71c-8ac4277de8a1}IdSLSWorkOrder', value: a!linkField( links: { a!recordLink( label: rule!SLS_Format_WorkOrderID( Id: fv!row['recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{39638375-b861-45d8-a71c-8ac4277de8a1}IdSLSWorkOrder'] ), recordType: 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync', identifier: fv!row['recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{39638375-b861-45d8-a71c-8ac4277de8a1}IdSLSWorkOrder'] ) } ), align: "CENTER", width: "NARROW_PLUS" ), a!gridColumn( label: "Site ID", sortField: 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{5577e033-0e7e-41a3-9522-db47d0f4779e}siteID', value: a!richTextDisplayField( value: a!richTextItem( text: fv!row['recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{5577e033-0e7e-41a3-9522-db47d0f4779e}siteID'], link: a!recordLink( recordType: cons!TWM_RECORD_SITE, identifier: index( touniformstring( index( Index(local!siteData, "Data", {}), 'recordType!{0e049d77-e6eb-4df6-a780-729a9ee508f2}Site.fields.{idSiteLocation}idSiteLocation', {} ) ), wherecontains( fv!row['recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{5577e033-0e7e-41a3-9522-db47d0f4779e}siteID'], touniformstring( index( Index(local!siteData, "Data", {}), 'recordType!{0e049d77-e6eb-4df6-a780-729a9ee508f2}Site.fields.{siteId}siteId', {} ) ) ), {} ), openLinkIn: "NEW_TAB" ) ) ), width: "NARROW", align: "CENTER" ), a!gridColumn( label: "Site name", sortField: 'recordType!{0e049d77-e6eb-4df6-a780-729a9ee508f2}Site.fields.{siteName}siteName', value: index( Index( rule!SLS_GetSiteDetailsFromMaestro( SiteIds: fv!row['recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{5577e033-0e7e-41a3-9522-db47d0f4779e}siteID'] ), "Data", {} ), 'recordType!{0e049d77-e6eb-4df6-a780-729a9ee508f2}Site.fields.{siteName}siteName', {} ), width: "AUTO" ), a!gridColumn( label: "Activity ID", sortField: 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{526678f5-f98a-4f93-a22c-aa7c05df57ab}maestroRefId', align: "START", value: a!richTextDisplayField( value: { a!forEach( items: split( fv!row['recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{526678f5-f98a-4f93-a22c-aa7c05df57ab}maestroRefId'], ";" ), expression: a!richTextItem( text: if( a!isNullOrEmpty(tostring(fv!item)), "", tostring(fv!item) & ", " ), link: a!recordLink( recordType: cons!TWM_RECORD_ACTIVITY, identifier: if( a!isNotNullOrEmpty( fv!row['recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{526678f5-f98a-4f93-a22c-aa7c05df57ab}maestroRefId'] ), index( rule!SLS_QRY_getActivityData(refNum: fv!item), 'recordType!{ebe4ee39-04be-47b9-9af7-4fb739a53d20}Activity.fields.{idActivity}idActivity', {} ), null ), openLinkIn: "NEW_TAB" ), linkStyle: "STANDALONE" ) ) } ), width: "NARROW_PLUS", ), a!gridColumn( label: "Activity Name", sortField: 'recordType!{ebe4ee39-04be-47b9-9af7-4fb739a53d20}Activity.fields.{name}name', value: a!forEach( items: split( fv!row['recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{526678f5-f98a-4f93-a22c-aa7c05df57ab}maestroRefId'], ";" ), expression: if( a!isNotNullOrEmpty( fv!row['recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{526678f5-f98a-4f93-a22c-aa7c05df57ab}maestroRefId'] ), index( rule!SLS_QRY_getActivityData(refNum: fv!item), 'recordType!{ebe4ee39-04be-47b9-9af7-4fb739a53d20}Activity.fields.{name}name', {} ), null ), ), width: "NARROW_PLUS" ), a!gridColumn( label: "Assigned To", sortField: 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{33409ebc-43db-4ffd-b572-71918cb216da}assignedTo', value: rule!APN_displayUser( user: touser( fv!row['recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{33409ebc-43db-4ffd-b572-71918cb216da}assignedTo'] ) ), width: "NARROW_PLUS" ), a!gridColumn( label: "Status", sortField: 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{59c88299-7c3c-485c-8e80-116509932002}status', value: a!match( value: fv!row['recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{59c88299-7c3c-485c-8e80-116509932002}status'], equals: "1", then: "DRAFT", equals: "2", then: "FULFILLMENT", equals: "3", then: "SLS SUBMITTED", equals: "4", then: "SLS APPROVED", equals: "5", then: "COMPLETED", default: {} ) ), a!gridColumn( label: "Description", sortField: 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{1d548967-5733-46c9-aa0c-2069e16e4d75}description', value: fv!row['recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{1d548967-5733-46c9-aa0c-2069e16e4d75}description'] ), a!gridColumn( label: "Source", sortField: 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{c25af599-da0e-42a0-9250-8c25a3821525}source', value: fv!row['recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{c25af599-da0e-42a0-9250-8c25a3821525}source'] ), a!gridColumn( label: "Created By", sortField: 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{4b140838-ebd9-4d54-b93f-e3003d389e9c}createdBy', value: rule!APN_displayUser( user: fv!row['recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{4b140838-ebd9-4d54-b93f-e3003d389e9c}createdBy'] ), width: "NARROW_PLUS" ), a!gridColumn( label: "Created On", sortField: 'recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{6811e4d8-8cc1-4c9d-8ff2-8d5e2a82a726}createdOn', value: if( a!isNullOrEmpty( fv!row['recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{6811e4d8-8cc1-4c9d-8ff2-8d5e2a82a726}createdOn'] ), "-", text( fv!row['recordType!{ea92f291-a913-4e02-be7b-c4de2844fe08}SLS Work Order Sync.fields.{6811e4d8-8cc1-4c9d-8ff2-8d5e2a82a726}createdOn'], "dd/mm/yyyy" ) ), width: "NARROW_PLUS" ) }, pageSize: 15, selectable: local!isSLSEditor, selectionStyle: "CHECKBOX", selectionValue: local!selectedValue, selectionSaveInto: { local!selectedValue, a!save(local!selectedRows, append(local!selectedRows, fv!selectedRows)), a!save(local!selectedRows, difference(local!selectedRows, fv!deselectedRows)) }, validations: {}, refreshOnVarChange: local!refresh, refreshAfter: "RECORD_ACTION", height: "MEDIUM_PLUS", showRefreshButton: false, ) } ) } ) } )
Posting 700 lines of code here and then expecting me to read all of it is an imposition!
It seems like you store multiple "maestroRefId" values as a semicolon separated list in the DB. I do not see any queryFilter in your code. You will have to adapt that filter to your way of storing data.
BTW, doing a database query in a grid column value calls for bad performance.