Agrego las lineas de las consultas.

[mecon/samurai.git] / lib / SAMURAI / Perfil / consultas.ini

diff --git a/lib/SAMURAI/Perfil/consultas.ini b/lib/SAMURAI/Perfil/consultas.ini
index 7e28e3a44a236c00d2a9acc0cfe75dc792882918..9704a1136f53c8f3b2a95aa16460e3b40f5931ce 100644 (file)
--- a/lib/SAMURAI/Perfil/consultas.ini
+++ b/lib/SAMURAI/Perfil/consultas.ini
@@ -8,6 +8,8 @@ obtener_id_perfiles    = " SELECT ps.id_perfil FROM samurai.perfil_sist as ps, s
 obtener_id_perfiles3   = " AND ps.id_sistema = ? "
 obtener_id_perfiles2   = " AND p.desc_perfil like '%##FILTRO##%'"
 obtener_id_perfiles4   = " ORDER BY p.desc_perfil" 
 obtener_id_perfiles3   = " AND ps.id_sistema = ? "
 obtener_id_perfiles2   = " AND p.desc_perfil like '%##FILTRO##%'"
 obtener_id_perfiles4   = " ORDER BY p.desc_perfil" 

+obtener_id_perfiles5   = " SELECT p.id_perfil FROM samurai.perfil as p "
+obtener_id_perfiles6   = " WHERE p.desc_perfil like '%##FILTRO##%'"

 borrar_perfil          = " DELETE FROM samurai.perfil as p "
 obtener_permisos       = " SELECT id_permiso, observaciones FROM samurai.perm_perfil_sist WHERE id_perfil = ? AND id_sistema = ?"
 
 borrar_perfil          = " DELETE FROM samurai.perfil as p "
 obtener_permisos       = " SELECT id_permiso, observaciones FROM samurai.perm_perfil_sist WHERE id_perfil = ? AND id_sistema = ?"