• State Not Answered
  • Replies 7 replies
  • Subscribers 19 subscribers
  • Views 314 views
  • Users 0 members are here
Related Discussions
Home » Discussions » New to Appian

How to filter array of data from one id in grid

appian.user

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 grid

help me achieve this,
Thankyou!


  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer

    Can you share the code of your filter?

  • 0 in reply to Stefan Helzle

    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"
                  ),

  • 0
    Certified Lead Developer
     in reply to appian.user

    Where and how do you apply that filter? I would expect to see an a!queryFilter() somewhere.

  • 0 in reply to Stefan Helzle 

    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,
              
            )
          }
        )
      }
    )
  }
)


    Hi stefan , I have attached code snippet I hope you are get it

  • 0
    Certified Lead Developer
     in reply to appian.user

    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.

  • 0
    Certified Lead Developer
     in reply to appian.user

    The rule SLS_QRY_getWorkOrderSync() for the local getWorkOrderDetails, you are passing the selected Activity Id in it, is this rule returning data when you input 213396  as activity id? 

Reply Children
No Data
© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.