Skip to main content
M
marios6581
February 7, 2025
Question

Error on a Grid

  • February 7, 2025
  • 3 replies
  • 0 views

Hello everyone

I am facing the following issue:

Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridField [line 3]: No enum constant com.appiancorp.core.expr.portable.cdt.LogicalOperator.<>

 

And after some triage, I am not able to find the route cause for this issue. Can you give me some tips? 

Thanks in advance

Edit: 

a!localVariables(
local!paging,
a!gridField(
label: "Envelope List",
labelPosition: "COLLAPSED",
emptyGridMessage: "No Envelopes",
data: rule!VCP_qr_getEnvelopeLookupView(filters: ri!filters),
columns: {
a!gridColumn(
label: "Envelope Name",
value: if(
ri!isReportMode,
a!linkField(
links: a!recordLink(
label: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{905ee3c6-5418-44bb-b35d-29317c1ed879}name'],
recordType: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope',
identifier: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{40f426bc-eaa3-4dca-9838-d365bd5e9f0b}id']
)
),
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{905ee3c6-5418-44bb-b35d-29317c1ed879}name']
),
sortField: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{905ee3c6-5418-44bb-b35d-29317c1ed879}name'
),
a!gridColumn(
label: "Projects",
value: if(
ri!isReportMode,
a!richTextDisplayField(
value: a!richTextBulletedList(
items: reject(
rule!GBL_isBlankOrEmpty,
union(
split(
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{c9abb56c-f1e2-401e-8007-885a5ebb2342}vcpDocument.relationships.{eacfe80d-ab69-4ea4-b86c-2b86af901811}vcpRefProjectDocument.relationships.{cdc02932-054e-4a93-96bf-8274d2f45546}vcpRefProjectDocument.fields.{62239b5b-833c-46b8-98b1-c0d2611e9bca}name'],
"; "
),
split(
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{c9abb56c-f1e2-401e-8007-885a5ebb2342}vcpDocument.relationships.{eacfe80d-ab69-4ea4-b86c-2b86af901811}vcpRefProjectDocument.relationships.{cdc02932-054e-4a93-96bf-8274d2f45546}vcpRefProjectDocument.fields.{62239b5b-833c-46b8-98b1-c0d2611e9bca}name'],
"; "
)
)
)
)
),
joinarray(
union(
split(
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{c9abb56c-f1e2-401e-8007-885a5ebb2342}vcpDocument.relationships.{eacfe80d-ab69-4ea4-b86c-2b86af901811}vcpRefProjectDocument.relationships.{cdc02932-054e-4a93-96bf-8274d2f45546}vcpRefProjectDocument.fields.{62239b5b-833c-46b8-98b1-c0d2611e9bca}name'],
"; "
),
split(
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{c9abb56c-f1e2-401e-8007-885a5ebb2342}vcpDocument.relationships.{eacfe80d-ab69-4ea4-b86c-2b86af901811}vcpRefProjectDocument.relationships.{cdc02932-054e-4a93-96bf-8274d2f45546}vcpRefProjectDocument.fields.{62239b5b-833c-46b8-98b1-c0d2611e9bca}name'],
"; "
)
),
", "
)
)
),
a!gridColumn(
label: "Entities",
value: a!localVariables(
local!entities: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{c9abb56c-f1e2-401e-8007-885a5ebb2342}vcpDocument.relationships.{55e0b492-fd8f-4063-b6bb-1caba94c4bfa}vcpEntityLookup.fields.{d4e5c7fe-e1d9-4571-9807-e9e5a22558c6}name'],
local!entityDocuments: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{c7cf32c4-3af5-40b1-b78e-5673caea2452}vcpEntityDocument.relationships.{2c7934fc-1b86-443c-ad54-96d79738bf61}vcpEntityLookup.fields.{d4e5c7fe-e1d9-4571-9807-e9e5a22558c6}name'],
local!fundEntities: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{c9abb56c-f1e2-401e-8007-885a5ebb2342}vcpDocument.relationships.{b3f3ba3c-edf8-4fcc-a168-a8175d828116}vcpFundEntityLookup.fields.{1fd52331-8fcf-4185-b70b-f48fa65990cf}name'],
local!entityValues: reject(
a!isNullOrEmpty(_),
union(
a!flatten(
{
local!entities,
local!entityDocuments,
local!fundEntities
}
),
a!flatten(
{
local!entities,
local!entityDocuments,
local!fundEntities
}
)
)
),
if(
ri!isReportMode,
a!richTextDisplayField(
value: a!richTextBulletedList(items: local!entityValues)
),
joinarray(local!entityValues, ", ")
)
)
),
a!gridColumn(
label: "Initiator",
sortField: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{e75ebf7a-7233-4597-81d7-a0d19542bf52}initiator',
value: rule!GBL_displayUserFirstLast(
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{e75ebf7a-7233-4597-81d7-a0d19542bf52}initiator']
)
),
a!gridColumn(
label: "Validators",
value: if(
ri!isReportMode,
a!richTextDisplayField(
value: a!richTextBulletedList(
items: reject(
a!isNullOrEmpty(_),
apply(
rule!GBL_displayUserFirstLast,
{
index(
fv!row,
'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{04781fd5-aeaf-47f3-a2fa-c0b811de5a40}vcpValidator.fields.{c3484087-8fd0-4baf-bc20-06d8b0abf54f}username',
null
)
}
)
)
)
),
joinarray(
apply(
rule!GBL_displayUserFirstLast,
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{04781fd5-aeaf-47f3-a2fa-c0b811de5a40}vcpValidator.fields.{c3484087-8fd0-4baf-bc20-06d8b0abf54f}username']
),
", "
)
)
),
a!gridColumn(
label: "Executors",
value: if(
ri!isReportMode,
a!richTextDisplayField(
value: a!richTextBulletedList(
items: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{a9dec80e-6776-490e-801e-40aad12026f6}vcpExecutor.fields.{b8b6d31a-e79e-4a7d-95e6-f2590bc797f2}fullName']
)
),
joinarray(
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{a9dec80e-6776-490e-801e-40aad12026f6}vcpExecutor.fields.{b8b6d31a-e79e-4a7d-95e6-f2590bc797f2}fullName'],
", "
)
)
),
a!gridColumn(
label: "Completion Due Date",
sortField: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{763938ef-ed6d-4751-bbda-03dc10a07e7c}executionDueDate',
value: rule!GBL_formatDateTimeMonthText(
dateTime: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{763938ef-ed6d-4751-bbda-03dc10a07e7c}executionDueDate'],
includeDow: true()
)
),
a!gridColumn(
label: "Envelope Group",
value: if(
or(
rule!GBL_isBlankOrEmpty(
tointeger(
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{9b3e1845-42c9-4db4-bcf1-4d16ccd66fca}functionalGroup']
)
),
not(
a!doesGroupExist(
a!defaultValue(
value: tointeger(
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{9b3e1845-42c9-4db4-bcf1-4d16ccd66fca}functionalGroup']
),
default: 0
)
)
)
),
null,
if(
find(
"VCP",
group(
tointeger(
tointeger(
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{9b3e1845-42c9-4db4-bcf1-4d16ccd66fca}functionalGroup']
)
),
"groupName"
)
) = 0,
group(
tointeger(
tointeger(
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{9b3e1845-42c9-4db4-bcf1-4d16ccd66fca}functionalGroup']
)
),
"groupName"
),
replace(
group(
tointeger(
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{9b3e1845-42c9-4db4-bcf1-4d16ccd66fca}functionalGroup']
),
"groupName"
),
1,
4,
""
)
)
)
),
a!gridColumn(
label: "Envelope Status",
sortField: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{d47e47db-59ff-40ea-b401-bcbca126a891}fkRefStatusId',
value: if(
ri!isReportMode,
a!tagField(
tags: a!tagItem_24r2(
text: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{d19b841b-52e4-4f5f-bcff-2c4e18fa1376}vcpReferenceData.fields.{0fac8ef1-2817-40fa-966b-d5dc2f7752a0}label'],
backgroundColor: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{d19b841b-52e4-4f5f-bcff-2c4e18fa1376}vcpReferenceData.fields.{73c9e10c-6b52-4ccd-9044-891de873bc41}iconColor']
)
),
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{d19b841b-52e4-4f5f-bcff-2c4e18fa1376}vcpReferenceData.fields.{0fac8ef1-2817-40fa-966b-d5dc2f7752a0}label']
)
),
a!gridColumn(
label: "Last Activity Date",
sortField: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{74e6b035-31e5-476e-87b1-320b5fcd3e21}updatedOn',
value: rule!GBL_formatDateTimeMonthText(
dateTime: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{74e6b035-31e5-476e-87b1-320b5fcd3e21}updatedOn'],
includeDow: true()
)
),
/* Download Mode */
a!gridColumn(
label: "Envelope Initiation Date",
sortField: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{bb757547-c1fb-4e8e-b700-8e9e9c396eb1}createdOn',
value: rule!GBL_formatDateTimeMonthText(
dateTime: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{bb757547-c1fb-4e8e-b700-8e9e9c396eb1}createdOn'],
includeDow: true()
),
showWhen: ri!isReportMode = false()
),
a!gridColumn(
label: "Process",
value: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{f9e6858b-2843-44d8-b265-d5d4929e8c7e}vcpProcess.fields.{56c0f228-2904-4f81-816f-170b41c0e7ba}name'],
showWhen: ri!isReportMode = false()
),
a!gridColumn(
label: "Sub Process",
value: joinarray(
union(
touniformstring(
split(
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{c9abb56c-f1e2-401e-8007-885a5ebb2342}vcpDocument.relationships.{b5d303cd-3d68-4a4a-80c3-c20dd93b4953}vcpRefSubProcess.fields.{944d51ce-76e7-4175-9d18-bd62e9fc13fe}name'],
"; "
)
),
touniformstring(
split(
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{c9abb56c-f1e2-401e-8007-885a5ebb2342}vcpDocument.relationships.{b5d303cd-3d68-4a4a-80c3-c20dd93b4953}vcpRefSubProcess.fields.{944d51ce-76e7-4175-9d18-bd62e9fc13fe}name'],
"; "
)
)
),
", "
),
showWhen: ri!isReportMode = false()
),
a!gridColumn(
label: "Initiator Department",
value: joinarray(
a!forEach(
items: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{e75ebf7a-7233-4597-81d7-a0d19542bf52}initiator'],
expression: rule!VCP_findDepartmentsOfAnUser(fv!item)
),
", "
),
showWhen: ri!isReportMode = false()
),
a!gridColumn(
label: "Validator Department",
value: joinarray(
a!flatten(
a!forEach(
items: union(
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{04781fd5-aeaf-47f3-a2fa-c0b811de5a40}vcpValidator.fields.{2539745e-dbb8-4791-b8e6-0ff5cf24f6fe}departmentId'],
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{04781fd5-aeaf-47f3-a2fa-c0b811de5a40}vcpValidator.fields.{2539745e-dbb8-4791-b8e6-0ff5cf24f6fe}departmentId']
),
expression: rule!VCP_findDepartmentsByDepartmentId(departmentId: fv!item)
)
),
", "
),
showWhen: ri!isReportMode = false()
),
a!gridColumn(
label: "Is Validation Skipped",
value: if(
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{d47e47db-59ff-40ea-b401-bcbca126a891}fkRefStatusId'] = cons!VCP_INT_REF_ENVELOPE_STATUS_PENDING_INITIATION,
"",
if(
and(
a!flatten(
a!forEach(
items: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{04781fd5-aeaf-47f3-a2fa-c0b811de5a40}vcpValidator.fields.{80fb1e4a-4f57-4cc6-af72-53bc630b8764}skipValidation'],
expression: if(
rule!GBL_isBlankOrEmpty(fv!item),
false(),
true()
)
)
)
),
"Yes",
"No"
)
),
showWhen: ri!isReportMode = false()
),
a!gridColumn(
label: "Envelope Link",
value: a!linkField(
links: {
a!recordLink(
label: "Envelope Link",
recordType: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope',
identifier: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{40f426bc-eaa3-4dca-9838-d365bd5e9f0b}id']
)
}
),
showWhen: ri!isReportMode = false()
),
a!gridColumn(
label: "Comments",
value: reject(
rule!GBL_isBlank,
index(
index(
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{aa245f79-a86d-4e5b-8033-067c6cfffe0e}vcpAuditTrial'],
wherecontains(
cons!VCP_INT_REF_ENVELOPE_STATUS_PENDING_INITIATION,
tointeger(
index(
fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{aa245f79-a86d-4e5b-8033-067c6cfffe0e}vcpAuditTrial'],
'recordType!{facd3057-756c-457f-b570-0e123e87ded1}VCP Audit Trial.fields.{de89700a-a6ff-4559-bd6b-45ded82ee448}fkStatusId',
{}
)
)
),
{}
),
'recordType!{facd3057-756c-457f-b570-0e123e87ded1}VCP Audit Trial.fields.{46e4ce23-eab8-4258-b2b3-a7e211d0638b}comments',
{}
)
),
showWhen: ri!isReportMode = false()
)
},
pagingSaveInto: a!save(local!paging, fv!pagingInfo),
height: "AUTO",
initialSorts: a!sortInfo(
field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{74e6b035-31e5-476e-87b1-320b5fcd3e21}updatedOn',
ascending: false()
),
borderStyle: "LIGHT",
pageSize: 15,
showExportButton: not(ri!isReportMode),
showRefreshButton: false(),
showSearchBox: false(),
showWhen: ri!showWhen
)
)

Code for data Rule:

a!recordData(
  recordType: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope',
  filters: a!queryLogicalExpression(
    operator: "AND",
    filters: {
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{a9dec80e-6776-490e-801e-40aad12026f6}vcpExecutor.fields.{0fc241f2-9af6-4f43-aae7-59f54952ab5d}emailAddress',
        operator: "includes",
        value: ri!filters.executorName,
        applywhen: rule!GBL_isNotBlank(ri!filters.executorName)
      ),
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{905ee3c6-5418-44bb-b35d-29317c1ed879}name',
        operator: "includes",
        value: ri!filters.envelopeName,
        applyWhen: rule!GBL_isNotBlank(ri!filters.envelopeName)
      ),
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{e75ebf7a-7233-4597-81d7-a0d19542bf52}initiator',
        operator: "includes",
        value: ri!filters.initiator,
        applyWhen: rule!GBL_isNotBlank(ri!filters.initiator)
      ),
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{d47e47db-59ff-40ea-b401-bcbca126a891}fkRefStatusId',
        operator: "in",
        value: ri!filters.fkRefStatusId,
        applyWhen: rule!GBL_isNotBlank(ri!filters.fkRefStatusId)
      ),
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{9f4c1570-e00c-4abf-9721-4502308fe992}fkRefProcessId',
        operator: "=",
        value: ri!filters.fkRefProcessId,
        applyWhen: rule!GBL_isNotBlank(ri!filters.fkRefProcessId)
      ),
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{c9abb56c-f1e2-401e-8007-885a5ebb2342}vcpDocument.fields.{6a044eb7-379e-4402-8cbb-e32762bed3a4}id',
        operator: "in",
        value: tointeger(
          rule!VCP_qe_getDocumentIdsByProjectIds(
            projectId: tointeger(split(ri!filters.fkRefProjectId, ";"))
          )
        ),
        applyWhen: rule!GBL_isNotBlank(ri!filters.fkRefProjectId)
      ),
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{04781fd5-aeaf-47f3-a2fa-c0b811de5a40}vcpValidator.fields.{c3484087-8fd0-4baf-bc20-06d8b0abf54f}username',
        operator: "includes",
        value: tostring(ri!filters.validatorUsername),
        applyWhen: rule!GBL_isNotBlank(ri!filters.validatorUsername)
      ),
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{763938ef-ed6d-4751-bbda-03dc10a07e7c}executionDueDate',
        operator: ">=",
        value: ri!filters.executionDueDateFrom,
        applyWhen: rule!GBL_isNotBlank(ri!filters.executionDueDateFrom)
      ),
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{763938ef-ed6d-4751-bbda-03dc10a07e7c}executionDueDate',
        operator: "<=",
        value: ri!filters.executionDueDateTo,
        applyWhen: rule!GBL_isNotBlank(ri!filters.executionDueDateTo)
      ),
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{74e6b035-31e5-476e-87b1-320b5fcd3e21}updatedOn',
        operator: ">=",
        value: ri!filters.lastActivityDateFrom,
        applyWhen: rule!GBL_isNotBlank(ri!filters.lastActivityDateFrom)
      ),
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{74e6b035-31e5-476e-87b1-320b5fcd3e21}updatedOn',
        operator: "<=",
        value: ri!filters.lastActivityDateTo,
        applyWhen: rule!GBL_isNotBlank(ri!filters.lastActivityDateTo)
      ),
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{9b3e1845-42c9-4db4-bcf1-4d16ccd66fca}functionalGroup',
        operator: "=",
        value: ri!filters.functionalGroupFilter,
        applyWhen: rule!GBL_isNotBlank(ri!filters.functionalGroupFilter)
      ),
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{bb757547-c1fb-4e8e-b700-8e9e9c396eb1}createdOn',
        operator: ">=",
        value: rule!GBL_convertDateToDateTime(date: ri!filters.initiatedOn),
        applyWhen: rule!GBL_isNotBlank(ri!filters.initiatedOn)
      ),
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{bb757547-c1fb-4e8e-b700-8e9e9c396eb1}createdOn',
        operator: "<=",
        value: rule!GBL_convertDateToDateTime(
          date: ri!filters.initiatedOn,
          userHour: 23,
          userMinute: 59,
          userSecond: 59
        ),
        applyWhen: rule!GBL_isNotBlank(ri!filters.initiatedOn)
      ),
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{9f4c1570-e00c-4abf-9721-4502308fe992}fkRefProcessId',
        operator: "=",
        value: ri!filters.fkProcessId,
        applyWhen: rule!GBL_isNotBlank(ri!filters.fkProcessId)
      ),
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{c9abb56c-f1e2-401e-8007-885a5ebb2342}vcpDocument.fields.{e555b741-68f4-4e6e-8654-48627501f81d}fkRefSubProcessId',
        operator: "=",
        value: ri!filters.fkSubProcessId,
        applyWhen: rule!GBL_isNotBlank(ri!filters.fkSubProcessId)
      ),
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{c9abb56c-f1e2-401e-8007-885a5ebb2342}vcpDocument.fields.{cf0292c4-54ce-4780-a249-caaa1696a30f}fundEntityId',
        operator: "=",
        value: ri!filters.fundEntityId,
        applyWhen: rule!GBL_isNotBlank(ri!filters.fundEntityId)
      ),
      a!queryFilter(
        field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{465aad88-c20d-486e-b729-c378fde368dc}isActive',
        operator: "=",
        value: true
      )
    },
    logicalExpressions: a!queryLogicalExpression(
      operator: "OR",
      filters: {
        a!queryFilter(
          field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{c9abb56c-f1e2-401e-8007-885a5ebb2342}vcpDocument.fields.{f078bb81-ece8-4d31-9681-85a1f2acbdaa}fkRefEntityId',
          operator: "=",
          value: ri!filters.fkRefEntityId,
          applyWhen: a!isNotNullOrEmpty(ri!filters.fkRefEntityId)
        ),
        a!queryFilter(
          field: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{c9abb56c-f1e2-401e-8007-885a5ebb2342}vcpDocument.relationships.{6c467fbd-905c-45b9-a752-0fd90d698cba}vcpEntityDocument.fields.{a04e90db-9a6a-49cf-8a01-0035422c86ed}fkRefEntityId',
          operator: "=",
          value: ri!filters.fkRefEntityId,
          applyWhen: a!isNotNullOrEmpty(ri!filters.fkRefEntityId)
        )
      }
    ),
    ignoreFiltersWithEmptyValues: true()
  ),
  relatedRecordData: {
    a!relatedRecordData(
      relationship: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{c9abb56c-f1e2-401e-8007-885a5ebb2342}vcpDocument'
    ),
    a!relatedRecordData(
      relationship: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{c7cf32c4-3af5-40b1-b78e-5673caea2452}vcpEntityDocument'
    ),
    a!relatedRecordData(
      relationship: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{a9dec80e-6776-490e-801e-40aad12026f6}vcpExecutor'
    ),
    a!relatedRecordData(
      relationship: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.relationships.{04781fd5-aeaf-47f3-a2fa-c0b811de5a40}vcpValidator'
    )
  }
)

Another finding seems that I am the only one suffering from this issue. My team is good. 


Update: 

I was able to track the issue down and locate the source of the problem.

This issue in on the isManager section of this ER: 

 a!localVariables(
  local!isInitiator: a!isUserMemberOfGroup(
    loggedInUser(),
    cons!VCP_GROUP_INITIATORS
  ),
  local!isValidator: a!isUserMemberOfGroup(
    loggedInUser(),
    cons!VCP_GROUP_VALIDATORS
  ),
  local!isExecutor: a!isUserMemberOfGroup(
    loggedInUser(),
    cons!VCP_GROUP_EXECUTORS
  ),
  local!isManager: a!isUserMemberOfGroup(loggedInUser(), cons!VCP_GROUP_MANAGERS),
  local!commonFilters: {
    a!queryFilter(
      field: 'recordType!{ba520eff-8388-4d3f-a7c6-320b1aeccdab}VCP Document.fields.{70479822-f752-4bba-bb8a-b16fd7e48f2f}fkRefTechDocumentTypeId',
      operator: "<>",
      value: cons!VCP_INT_REF_TECH_DOCUMENT_TYPE_CERTIFICATE
    ),
    a!queryFilter(
      field: 'recordType!{ba520eff-8388-4d3f-a7c6-320b1aeccdab}VCP Document.fields.{20ae61a4-7469-400e-88c8-b874d3344d49}isActive',
      operator: "=",
      value: true()
    )
  },
  a!queryLogicalExpression(
    operator: "OR",
    logicalExpressions: {
      if(
        local!isInitiator,
        a!queryLogicalExpression(
          operator: "OR",
          logicalExpressions: {
            a!queryLogicalExpression(
              operator: "AND",
              filters: {
                a!queryFilter(
                  field: 'recordType!{ba520eff-8388-4d3f-a7c6-320b1aeccdab}VCP Document.relationships.{ad4a8e08-f0d7-48b0-a048-c55c01c444fb}vcpEnvelope.fields.{e75ebf7a-7233-4597-81d7-a0d19542bf52}initiator',
                  operator: "=",
                  value: tostring(loggedInUser())
                ),
                local!commonFilters
              }
            ),
            a!queryLogicalExpression(
              operator: "AND",
              filters: {
                a!queryFilter(
                  field: 'recordType!{ba520eff-8388-4d3f-a7c6-320b1aeccdab}VCP Document.relationships.{ad4a8e08-f0d7-48b0-a048-c55c01c444fb}vcpEnvelope.fields.{9b3e1845-42c9-4db4-bcf1-4d16ccd66fca}functionalGroup',
                  operator: "in",
                  value: intersection(
                    tointeger(
                      a!groupsByType(
                        groupType: cons!VCP_GROUP_TYPE_TEAM_GROUP
                      ).data
                    ),
                    tointeger(getgroupsformemberuser(loggedInUser()))
                  )
                ),
                local!commonFilters
              }
            )
          }
        ),
        {}
      ),
      if(
        local!isValidator,
        a!queryLogicalExpression(
          operator: "AND",
          filters: {
            a!queryFilter(
              field: 'recordType!{ba520eff-8388-4d3f-a7c6-320b1aeccdab}VCP Document.relationships.{ad4a8e08-f0d7-48b0-a048-c55c01c444fb}vcpEnvelope.relationships.{04781fd5-aeaf-47f3-a2fa-c0b811de5a40}vcpValidator.fields.{c3484087-8fd0-4baf-bc20-06d8b0abf54f}username',
              operator: "=",
              value: tostring(loggedInUser())
            ),
            local!commonFilters
          }
        ),
        {}
      ),
      if(
        local!isExecutor,
        a!queryLogicalExpression(
          operator: "AND",
          filters: {
            a!queryFilter(
              field: 'recordType!{ba520eff-8388-4d3f-a7c6-320b1aeccdab}VCP Document.relationships.{ad4a8e08-f0d7-48b0-a048-c55c01c444fb}vcpEnvelope.relationships.{a9dec80e-6776-490e-801e-40aad12026f6}vcpExecutor.fields.{28f55be3-d798-4fab-bb9b-092b09475115}username',
              operator: "=",
              value: tostring(loggedInUser())
            ),
            local!commonFilters
          }
        ),
        {}
      ),
      if(
        local!isManager,
        a!queryLogicalExpression(
          operator: "AND",
          logicalExpressions: {
            a!queryLogicalExpression(
              operator: "OR",
              filters: {
                a!queryFilter(
                  field: 'recordType!{ba520eff-8388-4d3f-a7c6-320b1aeccdab}VCP Document.relationships.{ad4a8e08-f0d7-48b0-a048-c55c01c444fb}vcpEnvelope.fields.{f951b778-101c-4085-bdd8-418bfbde8285}isRestrictedAccess',
                  operator: "is null"
                ),
                a!queryFilter(
                  field: 'recordType!{ba520eff-8388-4d3f-a7c6-320b1aeccdab}VCP Document.relationships.{ad4a8e08-f0d7-48b0-a048-c55c01c444fb}vcpEnvelope.fields.{f951b778-101c-4085-bdd8-418bfbde8285}isRestrictedAccess',
                  operator: "=",
                  value: false()
                )
              }
            ),
            a!queryFilter(
              field: 'recordType!{ba520eff-8388-4d3f-a7c6-320b1aeccdab}VCP Document.relationships.{ad4a8e08-f0d7-48b0-a048-c55c01c444fb}vcpEnvelope.fields.{9b3e1845-42c9-4db4-bcf1-4d16ccd66fca}functionalGroup',
              operator: "<>",
              value: tointeger(cons!VCP_GROUP_KYC_TEAM)
            ),
            local!commonFilters
          }
        ),
        {}
      )
    }
  )
)

If I am manager, I get the error. This is located on a Record-Level Security rule. 

3 replies

mathieud0001
mathieud0001
February 7, 2025

Would it be possible to post the code?

konduruc733182
konduruc733182
February 10, 2025

Hello [mention:956bfa14eb8d4a8ebba9d5577b424c85:e9ed411860ed4f2ba0265705b8793d05] 

Could you let us know what is the rule used for data doing. Is there any filer within that rule?

stefanhelzle0001
stefanhelzle0001
February 10, 2025

We already discussed that in another thread. Please post the code of that expression.

Terms & ConditionsAccessibility statement