Solved
Null?list must be used within a SAIL component.
Hi everyone, I hope you can help me with something that is driving me crazy. For some scenarios it works and for others it doesn't, but basically I have an interface where the only thing I do is show database information. I went from validating nulls in the following way, {} then to "" and finally null() but the error was always the same "Null?list must be used within a SAIL component."
I attach an example of my code, I hope you can help me identify what the problem is.
a!localVariables(
local!newComment,
local!dataVerification: if(
a!isNullOrEmpty(
ri!recordRequest['recordType!{f3693eb2-ffb2-4407-814e-681b44ba8ef5}TTC Request.relationships.{42fd7ed7-d716-49c6-b449-e1fa839b532a}client.fields.{82090d2d-4f09-4af2-9995-eda5781d1392}id']
),
"",
rule!TTC_getVerificationByIdClient(
idClient: ri!recordRequest['recordType!{f3693eb2-ffb2-4407-814e-681b44ba8ef5}TTC Request.relationships.{42fd7ed7-d716-49c6-b449-e1fa839b532a}client.fields.{82090d2d-4f09-4af2-9995-eda5781d1392}id']
)
),
local!lists: if(
a!isNullOrEmpty(
local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.relationships.{14a9cb32-9e4d-45cd-95ed-06d4efb6fcf1}taoMatchMetamap.fields.{88560bbd-34c6-41c1-a4b8-46296bedb7cf}types']
),
"",
trim(
split(
local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.relationships.{14a9cb32-9e4d-45cd-95ed-06d4efb6fcf1}taoMatchMetamap.fields.{88560bbd-34c6-41c1-a4b8-46296bedb7cf}types'],
";"
)
)
),
local!totalLists: if(
a!isNullOrEmpty(local!lists),
"",
reject(
fn!isnull,
union(local!lists, local!lists)
)
),
{
a!columnsLayout(
columns: {
a!columnLayout(
contents: {
rule!COECO_CardBackground(
contents: {
a!columnsLayout(
columns: {
a!columnLayout(
contents: {
a!richTextDisplayField(
labelPosition: "COLLAPSED",
value: {
a!richTextItem(
text: { "Visor Judicial" },
color: "ACCENT",
size: "MEDIUM",
style: { "STRONG" }
)
},
align: "CENTER"
),
a!tagField(
labelPosition: "COLLAPSED",
tags: {
a!tagItem(
text: if(
local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{49f77aaf-6d2c-476c-98d8-e5f56a975a1b}isViewer'],
"SI",
"NO"
),
backgroundColor: if(
local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{49f77aaf-6d2c-476c-98d8-e5f56a975a1b}isViewer'],
"#A00000",
cons!COECO_TXT_COLOR_GREEN
)
)
},
align: "CENTER"
)
}
),
a!columnLayout(
contents: {
a!richTextDisplayField(
labelPosition: "COLLAPSED",
value: {
a!richTextItem(
text: { "Listas Internas de Alertas" },
color: "ACCENT",
size: "MEDIUM",
style: { "STRONG" }
)
},
align: "CENTER"
),
a!tagField(
labelPosition: "COLLAPSED",
tags: {
a!tagItem(
text: if(
local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{ff07e6d7-b927-447c-8c09-1f0809e37ded}isInternal'],
"SI",
"NO"
),
backgroundColor: if(
local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{ff07e6d7-b927-447c-8c09-1f0809e37ded}isInternal'],
"#A00000",
cons!COECO_TXT_COLOR_GREEN
)
)
},
align: "CENTER"
)
}
),
a!columnLayout(
contents: {
a!richTextDisplayField(
labelPosition: "COLLAPSED",
value: {
a!richTextItem(
text: { "Listas Internacionales (MetaMAP)" },
color: "ACCENT",
size: "MEDIUM",
style: { "STRONG" }
)
},
align: "CENTER"
),
a!tagField(
labelPosition: "COLLAPSED",
tags: {
a!tagItem(
text: if(
a!isNullOrEmpty(
local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.relationships.{14a9cb32-9e4d-45cd-95ed-06d4efb6fcf1}taoMatchMetamap']
),
"NO",
"SI"
),
backgroundColor: if(
a!isNullOrEmpty(
local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.relationships.{14a9cb32-9e4d-45cd-95ed-06d4efb6fcf1}taoMatchMetamap']
),
cons!COECO_TXT_COLOR_GREEN,
"#A00000"
)
)
},
align: "CENTER"
)
}
)
}
)
},
style: "STANDARD",
marginBelow: "STANDARD",
height: "AUTO"
)
}
)
}
),
a!columnsLayout(
columns: {
a!columnLayout(
contents: {
rule!COECO_CardBackground(
contents: {
a!sectionLayout(
label: "Listas Internaciones (Metamap)",
labelIcon: "globe-alt",
contents: {
a!columnsLayout(
columns: {
a!columnLayout(
contents: {
a!textField(
label: "Score",
labelPosition: "ABOVE",
value: if(
a!isNullOrEmpty(local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.relationships.{14a9cb32-9e4d-45cd-95ed-06d4efb6fcf1}taoMatchMetamap']),
"Sin Coincidencias",
local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.relationships.{14a9cb32-9e4d-45cd-95ed-06d4efb6fcf1}taoMatchMetamap.fields.{7c79fa72-d535-405a-b4a8-1916c1e18d9b}score']
),
refreshAfter: "UNFOCUS",
readOnly: true,
validations: {}
),
a!richTextDisplayField(
label: "Link",
value: a!richTextItem(
text: if(
a!isNullOrEmpty(local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.relationships.{14a9cb32-9e4d-45cd-95ed-06d4efb6fcf1}taoMatchMetamap']),
"Sin Coincidencias",
local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.relationships.{14a9cb32-9e4d-45cd-95ed-06d4efb6fcf1}taoMatchMetamap.fields.{8ac38eb5-2b14-4a03-aca4-f218deaf4ff8}link']
),
link: if(
a!isNullOrEmpty(local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.relationships.{14a9cb32-9e4d-45cd-95ed-06d4efb6fcf1}taoMatchMetamap.fields.{8ac38eb5-2b14-4a03-aca4-f218deaf4ff8}link']),
"",
a!safeLink(
uri: local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.relationships.{14a9cb32-9e4d-45cd-95ed-06d4efb6fcf1}taoMatchMetamap.fields.{8ac38eb5-2b14-4a03-aca4-f218deaf4ff8}link']
)
)
)
)
}
),
a!columnLayout(
contents: {
a!textField(
label: "Nombre y apellido",
labelPosition: "ABOVE",
value: if(
a!isNullOrEmpty(local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.relationships.{14a9cb32-9e4d-45cd-95ed-06d4efb6fcf1}taoMatchMetamap']),
"Sin Coincidencias",
local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.relationships.{14a9cb32-9e4d-45cd-95ed-06d4efb6fcf1}taoMatchMetamap.fields.{f701fc8a-477e-465a-a206-4c32dd9a1e1c}fullName']
),
refreshAfter: "UNFOCUS",
readOnly: true,
validations: {}
),
a!richTextDisplayField(
label: "Listas con coincidencias",
value: a!richTextItem(
text: a!forEach(
items: local!totalLists,
expression: fv!item & chr(10)
)
)
)
}
)
}
)
}
)
},
style: "STANDARD",
marginBelow: "STANDARD",
height: "AUTO"
),
rule!COECO_CardBackground(
contents: {
a!sectionLayout(
label: "Visor Judicial",
labelIcon: "search",
contents: {
a!columnsLayout(
columns: {
a!columnLayout(
contents: {
a!textField(
label: "Indicador de coincidencias",
labelPosition: "ABOVE",
value: a!defaultValue(
local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{e0052b44-e50c-4811-ae5f-0bb7bf8fd44e}maxRiskPoints'],
0
) & "% ",
refreshAfter: "UNFOCUS",
readOnly: true,
validations: {}
),
a!textField(
label: "PaÃ%ADs de búsqueda",
labelPosition: "ABOVE",
value: if(
a!isNullOrEmpty(local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.relationships.{ef01a105-ba7f-494b-a438-e9aa7d5400b4}client.fields.{f9a2b654-4368-4ce1-95dc-1d2d1b4f4cc0}ateneaNacionalityCountryId']),
"Sin Coincidencias",
index(
rule!COECO_QRY_ATENEA_GetCountry(
alphaCode3: local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.relationships.{ef01a105-ba7f-494b-a438-e9aa7d5400b4}client.fields.{f9a2b654-4368-4ce1-95dc-1d2d1b4f4cc0}ateneaNacionalityCountryId']
),
'recordType!{b33fb39d-b93e-453e-a8d8-523856dca4da}COECO ATENEA Country.fields.{bfae316c-a590-41b4-b29a-9e61175c1687}description',
null()
)
),
refreshAfter: "UNFOCUS",
readOnly: true,
validations: {}
),
a!textField(
label: "Verificación en listas de riesgos 413 de América Latina",
labelPosition: "ABOVE",
value: rule!TTC_GetViewerFlagLabel(
flag: local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{f7a8d026-9cf7-4f9a-8fbe-3405d83126e3}isV413']
),
refreshAfter: "UNFOCUS",
readOnly: true,
validations: {}
),
a!textField(
label: "Identificación de PEPS",
labelPosition: "ABOVE",
value: rule!TTC_GetViewerFlagLabel(
flag: local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{bc5c0f24-5c5c-4e07-8120-3e62ca4c4176}isIDPEP']
),
refreshAfter: "UNFOCUS",
readOnly: true,
validations: {}
),
a!richTextDisplayField(
label: "Link",
value: a!richTextItem(
text: if(
a!isNullOrEmpty(local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{754020c5-ce73-4644-adcb-ddcf7c93d57f}linkReport']),
"Sin Coincidencias",
local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{754020c5-ce73-4644-adcb-ddcf7c93d57f}linkReport']
),
link: if(
a!isNullOrEmpty(local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{754020c5-ce73-4644-adcb-ddcf7c93d57f}linkReport']),
"",
a!safeLink(
uri: local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{754020c5-ce73-4644-adcb-ddcf7c93d57f}linkReport']
)
)
)
)
}
),
a!columnLayout(
contents: {
a!textField(
label: "Nombre y apellido",
labelPosition: "ABOVE",
value: if(
a!isNullOrEmpty(local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.relationships.{14a9cb32-9e4d-45cd-95ed-06d4efb6fcf1}taoMatchMetamap']),
"Sin coincidencias",
local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.relationships.{14a9cb32-9e4d-45cd-95ed-06d4efb6fcf1}taoMatchMetamap.fields.{f701fc8a-477e-465a-a206-4c32dd9a1e1c}fullName']
),
refreshAfter: "UNFOCUS",
readOnly: true,
validations: {}
),
a!textField(
label: "Verificación en 350 listas de sanciones en el mundo",
labelPosition: "ABOVE",
value: rule!TTC_GetViewerFlagLabel(
flag: local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{9c8fabc3-31de-46d2-8a01-42d9ac121eef}isV350']
),
refreshAfter: "UNFOCUS",
readOnly: true,
validations: {}
),
a!textField(
label: "Registros criminales",
labelPosition: "ABOVE",
value: rule!TTC_GetViewerFlagLabel(
flag: local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{d19211cc-bbc7-4d77-afbf-f22ed95d18a3}isRCR']
),
refreshAfter: "UNFOCUS",
readOnly: true,
validations: {}
),
a!textField(
label: "Noticias publicadas en medios de comunicación",
labelPosition: "ABOVE",
value: rule!TTC_GetViewerFlagLabel(
flag: local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{afd9b93f-789c-4718-b54a-8da1def41a4d}isNPEM']
),
refreshAfter: "UNFOCUS",
readOnly: true,
validations: {}
)
}
)
}
)
}
)
},
style: "STANDARD",
marginBelow: "STANDARD",
height: "AUTO"
),
rule!COECO_CardBackground(
contents: {
a!sectionLayout(
label: "Comentarios",
labelIcon: "comments",
contents: {
a!columnsLayout(
columns: {
a!columnLayout(
contents: {
a!cardLayout(
contents: {
a!paragraphField(
label: "",
placeholder: "Ingrese un comentario relacionado a la solicitud",
value: local!newComment,
saveInto: { local!newComment }
),
a!buttonArrayLayout(
buttons: {
a!buttonWidget(
label: "Agregar Comentario",
icon: "plus",
iconPosition: "START",
value: {
'recordType!{8d75091e-ee98-49ff-a678-074da0dc9a70}TTC Comment'(
'recordType!{8d75091e-ee98-49ff-a678-074da0dc9a70}TTC Comment.fields.{4851abf1-7604-47d2-84e7-1d54a7979eb6}commentBy': loggedInUser(),
'recordType!{8d75091e-ee98-49ff-a678-074da0dc9a70}TTC Comment.fields.{8d0a39a1-c5c0-45f4-b4e3-d8f660623cf7}commentOn': now(),
'recordType!{8d75091e-ee98-49ff-a678-074da0dc9a70}TTC Comment.fields.{f879e8ef-ad91-40ad-ad88-9911d829b3be}value': local!newComment
)
},
saveInto: {
a!save(
ri!recordRequest['recordType!{f3693eb2-ffb2-4407-814e-681b44ba8ef5}TTC Request.relationships.{0ed080cf-a343-46ec-ab5f-47dc644d7602}requestComment'],
append(
ri!recordRequest['recordType!{f3693eb2-ffb2-4407-814e-681b44ba8ef5}TTC Request.relationships.{0ed080cf-a343-46ec-ab5f-47dc644d7602}requestComment'],
save!value
)
),
a!save(local!newComment, null())
},
style: "SOLID",
color: "ACCENT",
disabled: or(
ri!readOnly,
a!isNullOrEmpty(local!newComment)
)
)
},
align: "START"
)
},
height: "AUTO",
style: "STANDARD",
marginBelow: "STANDARD"
)
}
),
a!columnLayout(
contents: {
a!cardLayout(
contents: {
if(
a!isNullOrEmpty(
ri!recordRequest['recordType!{f3693eb2-ffb2-4407-814e-681b44ba8ef5}TTC Request.relationships.{0ed080cf-a343-46ec-ab5f-47dc644d7602}requestComment']
),
"",
a!forEach(
items: ri!recordRequest['recordType!{f3693eb2-ffb2-4407-814e-681b44ba8ef5}TTC Request.relationships.{0ed080cf-a343-46ec-ab5f-47dc644d7602}requestComment'],
expression: a!sectionLayout(
contents: {
a!sideBySideLayout(
items: {
a!sideBySideItem(
item: a!stampField(
labelPosition: "COLLAPSED",
text: if(
a!isNullOrEmpty(
ri!recordRequest['recordType!{f3693eb2-ffb2-4407-814e-681b44ba8ef5}TTC Request.relationships.{0ed080cf-a343-46ec-ab5f-47dc644d7602}requestComment.fields.{4851abf1-7604-47d2-84e7-1d54a7979eb6}commentBy']
),
"N/A",
initials(
user(
fv!item['recordType!{8d75091e-ee98-49ff-a678-074da0dc9a70}TTC Comment.fields.{4851abf1-7604-47d2-84e7-1d54a7979eb6}commentBy'],
"firstName"
) & " " & user(
fv!item['recordType!{8d75091e-ee98-49ff-a678-074da0dc9a70}TTC Comment.fields.{4851abf1-7604-47d2-84e7-1d54a7979eb6}commentBy'],
"lastName"
)
)
),
backgroundColor: "SECONDARY",
size: "SMALL"
),
width: "MINIMIZE"
),
a!sideBySideItem(
item: a!richTextDisplayField(
labelPosition: "COLLAPSED",
value: {
a!richTextItem(
text: user(
fv!item['recordType!{8d75091e-ee98-49ff-a678-074da0dc9a70}TTC Comment.fields.{4851abf1-7604-47d2-84e7-1d54a7979eb6}commentBy'],
"firstName"
) & " " & user(
fv!item['recordType!{8d75091e-ee98-49ff-a678-074da0dc9a70}TTC Comment.fields.{4851abf1-7604-47d2-84e7-1d54a7979eb6}commentBy'],
"lastName"
),
link: a!userRecordLink(),
linkStyle: "STANDALONE",
style: "STRONG"
),
char(10),
a!richTextItem(
text: fv!item['recordType!{8d75091e-ee98-49ff-a678-074da0dc9a70}TTC Comment.fields.{8d0a39a1-c5c0-45f4-b4e3-d8f660623cf7}commentOn'],
color: "SECONDARY"
)
}
)
)
},
alignVertical: "MIDDLE"
),
a!textField(
labelPosition: "COLLAPSED",
value: fv!item['recordType!{8d75091e-ee98-49ff-a678-074da0dc9a70}TTC Comment.fields.{f879e8ef-ad91-40ad-ad88-9911d829b3be}value'],
saveInto: {
fv!item['recordType!{8d75091e-ee98-49ff-a678-074da0dc9a70}TTC Comment.fields.{f879e8ef-ad91-40ad-ad88-9911d829b3be}value']
},
readOnly: true()
)
}
)
)
)
},
height: "AUTO",
showWhen: a!isNotNullOrEmpty(
ri!recordRequest['recordType!{f3693eb2-ffb2-4407-814e-681b44ba8ef5}TTC Request.relationships.{0ed080cf-a343-46ec-ab5f-47dc644d7602}requestComment']
),
style: "STANDARD",
marginBelow: "STANDARD"
)
}
)
}
)
}
)
}
)
}
),
a!columnLayout(
contents: {
rule!COECO_CardBackground(
contents: {
a!sectionLayout(
label: "Listas Internas de Alertas de Cumplimiento",
labelIcon: "building",
contents: {
a!columnsLayout(
columns: {
a!columnLayout(
contents: {
rule!TTC_ROV_NaturalPerson(
ids: rule!COECO_SplitValue(
value: local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{e615640a-26b8-4c02-8f79-94452548b880}idNatural']
),
showWhen: a!isNotNullOrEmpty(local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{e615640a-26b8-4c02-8f79-94452548b880}idNatural'])
),
rule!TTC_ROV_UAF(
ids: rule!COECO_SplitValue(
value: local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{86e922cd-da4e-4942-86b7-44df8353a783}idMentioned']
),
showWhen: a!isNotNullOrEmpty(local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{86e922cd-da4e-4942-86b7-44df8353a783}idMentioned'])
),
rule!TTC_ROV_ComplianceRequest(
ids: rule!COECO_SplitValue(
value: local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{0610dc1b-b231-4bc0-8cdd-61d76d0ef058}idCompliance']
),
showWhen: a!isNotNullOrEmpty(local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{0610dc1b-b231-4bc0-8cdd-61d76d0ef058}idCompliance'])
),
rule!TTC_ROV_Pep(
ids: rule!COECO_SplitValue(
value: local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{2c5e283d-bb68-4b96-9184-ba4295b0e9c3}idPEP']
),
showWhen: a!isNotNullOrEmpty(local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{2c5e283d-bb68-4b96-9184-ba4295b0e9c3}idPEP'])
),
rule!TTC_ROV_News(
ids: rule!COECO_SplitValue(
value: local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{c3133f04-707e-4fa4-a985-56e56327714b}idNews']
),
showWhen:a!isNotNullOrEmpty(local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}TTC Verification.fields.{c3133f04-707e-4fa4-a985-56e56327714b}idNews'])
)
},
width: ""
)
}
)
}
)
},
style: "STANDARD",
marginBelow: "STANDARD",
height: "AUTO"
)
}
)
}
)
}
)