Skip to main content
M
marios6581
February 7, 2025
Question

Error on a Grid

  • February 7, 2025
  • 2 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
)
)

2 replies

stefanhelzle0001
stefanhelzle0001
February 7, 2025

Can you share the code of this expression "VCP_qr_getEnvelopeLookupView"?

And we need to know what that ri!filters contains.

When posting code, try to keep the indentation. Makes it much more readable.

gayatria0439
gayatria0439
February 10, 2025

Hi [mention:956bfa14eb8d4a8ebba9d5577b424c85:e9ed411860ed4f2ba0265705b8793d05] , Could you please show or explain the rule !VCP_qr_getEnvelopeLookupView() that you passed as data on line 7.? Additionally, kindly ensure that the correct constants have been passed and that the ruleInputs are created according to the specified datatype provided in the code.

Terms & ConditionsAccessibility statement