{"id":670,"date":"2026-04-30T09:53:19","date_gmt":"2026-04-30T12:53:19","guid":{"rendered":"https:\/\/wiki.gobiernoriocuarto.gob.ar\/?p=670"},"modified":"2026-04-30T09:53:19","modified_gmt":"2026-04-30T12:53:19","slug":"filtro-case-insensitive-en-permisos-gam-genexus","status":"publish","type":"post","link":"https:\/\/wiki.gobiernoriocuarto.gob.ar\/?p=670","title":{"rendered":"Filtro Case-Insensitive en Permisos GAM (GeneXus)"},"content":{"rendered":"

\ud83d\udcc4 Filtro Case-Insensitive en Permisos GAM (GeneXus)<\/h1>\n

\ud83d\udd39 Contexto<\/h2>\n

En el Web Panel de administraci\u00f3n de permisos (GAM), se requiere filtrar los permisos por nombre desde la grilla.<\/p>\n

Por defecto, el m\u00e9todo:<\/p>\n

&GAMRole.GetPermissions(&RolePermissionFilter, &Errors)<\/code><\/pre>\n
utiliza:<\/p>\n
&RolePermissionFilter.Name<\/code><\/pre>\n
Este filtro es case-sensitive<\/strong>, es decir:<\/p>\n
    \n
  • \n
    “Del” encuentra “Delete” \u2705<\/p>\n<\/li>\n
  • \n
    “del” NO encuentra “Delete” \u274c<\/p>\n<\/li>\n<\/ul>\n
    \n
    \n<\/div>\n
    \ud83d\udd39 Problema<\/h2>\n
    El filtrado por nombre utilizando:<\/p>\n
    &RolePermissionFilter.Name = \"%\" + &FilName.Trim() + \"%\"<\/code><\/pre>\n
    depende del motor interno de GAM, el cual distingue may\u00fasculas\/min\u00fasculas<\/strong>, generando resultados inconsistentes para el usuario.<\/p>\n
    \n
    \n<\/div>\n
    \ud83d\udd39 Soluci\u00f3n implementada<\/h2>\n
    1. Deshabilitar filtro por nombre en GAM<\/h3>\n
    Se evita el uso del filtro case-sensitive asignando:<\/p>\n
    &RolePermissionFilter.Name = \"\"<\/code><\/pre>\n
    De esta forma:<\/p>\n
      \n
    • \n
      GAM devuelve todos los permisos seg\u00fan los dem\u00e1s filtros<\/p>\n<\/li>\n
    • \n
      Se delega el filtrado por nombre a la l\u00f3gica de la aplicaci\u00f3n<\/p>\n<\/li>\n<\/ul>\n
      \n
      \n<\/div>\n
      2. Aplicar filtro manual case-insensitive<\/h3>\n
      Dentro del For<\/code>, se implementa un filtro utilizando Upper()<\/code> y like<\/code>:<\/p>\n
      For &Permission in &Permissions\r\n\r\n    if &FilName.IsEmpty() or\r\n       Upper(&Permission.Name) like \"%\" + Upper(&FilName.Trim()) + \"%\"\r\n\r\n        \/\/ carga de datos en la grilla\r\n        Grid.Load()\r\n        \r\n    endif\r\n\r\nEndFor<\/code><\/pre>\n
      \n
      \n<\/div>\n
      \ud83d\udd39 Funcionamiento<\/h2>\n
      El filtro transforma ambos valores a may\u00fasculas:<\/p>\n
      Upper(&Permission.Name)\r\nUpper(&FilName)<\/code><\/pre>\n
      Esto permite comparar.<\/p>\n
      \u2714 Ejemplos<\/h3>\n\n\n\n\n\n\n
      Input usuario<\/th>\nPermiso<\/th>\nResultado<\/th>\n<\/tr>\n
      del<\/td>\nDelete<\/td>\n\u2705<\/td>\n<\/tr>\n
      DEL<\/td>\nDelete<\/td>\n\u2705<\/td>\n<\/tr>\n
      Del<\/td>\nDelete<\/td>\n\u2705<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
      \n
      \n<\/div>\n","protected":false},"excerpt":{"rendered":"
      \ud83d\udcc4 Filtro Case-Insensitive en Permisos GAM (GeneXus) \ud83d\udd39 Contexto En el Web Panel de administraci\u00f3n de permisos (GAM), se requiere filtrar los permisos por nombre desde la grilla. Por defecto, el m\u00e9todo: &GAMRole.GetPermissions(&RolePermissionFilter, &Errors) utiliza: &RolePermissionFilter.Name Este filtro es case-sensitive, es decir: “Del” encuentra “Delete” \u2705 “del” NO encuentra “Delete” \u274c \ud83d\udd39 Problema El filtrado […]<\/p>\n","protected":false},"author":8,"featured_media":671,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-670","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-gx"],"_links":{"self":[{"href":"https:\/\/wiki.gobiernoriocuarto.gob.ar\/index.php?rest_route=\/wp\/v2\/posts\/670","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wiki.gobiernoriocuarto.gob.ar\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wiki.gobiernoriocuarto.gob.ar\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wiki.gobiernoriocuarto.gob.ar\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/wiki.gobiernoriocuarto.gob.ar\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=670"}],"version-history":[{"count":0,"href":"https:\/\/wiki.gobiernoriocuarto.gob.ar\/index.php?rest_route=\/wp\/v2\/posts\/670\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wiki.gobiernoriocuarto.gob.ar\/index.php?rest_route=\/wp\/v2\/media\/671"}],"wp:attachment":[{"href":"https:\/\/wiki.gobiernoriocuarto.gob.ar\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=670"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wiki.gobiernoriocuarto.gob.ar\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=670"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wiki.gobiernoriocuarto.gob.ar\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}