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ís 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" ) } ) } ) } )
Discussion posts and replies are publicly visible
x_XRiperX_x Can you try replacing local!lists with below code and try.
local!lists: if( a!isNullOrEmpty(local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}.relationships.{14a9cb32-9e4d-45cd-95ed-06d4efb6fcf1}.fields.{88560bbd-34c6-41c1-a4b8-46296bedb7cf}']), "", a!forEach( items: split(local!dataVerification['recordType!{dfadd5c5-0649-4812-a479-8214f3ae8fbe}.relationships.{14a9cb32-9e4d-45cd-95ed-06d4efb6fcf1}.fields.{88560bbd-34c6-41c1-a4b8-46296bedb7cf}'], ";"), expression: trim(fv!item) ) )