v_busqueda_general

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

seccion

varchar

null

orden_seccion

int

null

bigint

null

codigo

varchar

√

null

nombre

varchar

255

√

null

descripcion_busqueda

varchar

2147483647

√

null

api_url

varchar

√

null

orden

int

√

null

nombre_busqueda

varchar

4000

√

null

archivo

bigint

√

null

logo

varchar

255

√

null

categoria

varchar

√

null

Relationships

Close relationships within degrees of separation

View Definition

CREATE VIEW catalogos.v_busqueda_general AS
-- Dimensiones
SELECT 
    'Dimensiones' as seccion,
    1 as orden_seccion,
    dim_id as id,
    dim_codigo as codigo,
    dim_nombre as nombre,
    dim_contenido as descripcion_busqueda,
    '/v1/publico/dimensiones/' + CAST(dim_id AS VARCHAR(50)) as api_url,
    dim_orden as orden,
    dim_nombre_busqueda as nombre_busqueda,
    dim_archivo_fk as archivo,
    dim_logo as logo,
    null as categoria
FROM catalogos.ss_dimensiones d 
WHERE dim_habilitado = 1 and dim_publicado = 'ANONIMO'

UNION ALL

-- Indicadores
SELECT 
    'Indicadores' as seccion,
    2 as orden_seccion,    
    ind_id as id,
    ind_codigo as codigo,
    ind_nombre as nombre,
    ind_contenido as descripcion_busqueda,
    '/v1/publico/indicadores/' + CAST(ind_id AS VARCHAR(50)) as api_url,
    ind_orden as orden,
    ind_nombre_busqueda as nombre_busqueda,
    ind_archivo_fk as archivo,
    ind_logo as logo,
    null as categoria
FROM catalogos.ss_indicadores i
WHERE ind_habilitado = 1 and ind_publicado = 'ANONIMO'

UNION ALL

-- Recursos
SELECT 
    'Recursos' as seccion,
    3 as orden_seccion,    
    gei_id as id,
    NULL as codigo,
    gei_titulo as nombre,
    gei_contenido as descripcion_busqueda,
    '/v1/publico/informaciones/' + CAST(gei_id AS VARCHAR(50)) as api_url,
    gei_orden as orden,
    gei_titulo_busqueda as nombre_busqueda,
    gei_archivo_fk as archivo,
    gei_logo as logo,
    ss_codigo as categoria
FROM catalogos.ss_informaciones 
JOIN catalogos.ss_categorias_informacion ON gei_cai_id = ss_id
WHERE gei_habilitado = 1 and gei_publicado = 'ANONIMO'
and ss_codigo like 'MAS_RECURSOS%'

UNION ALL

-- Programas y servicios
SELECT 
    'Programas y servicios' as seccion,
    4 as orden_seccion,    
    gei_id as id,
    NULL as codigo,
    gei_titulo as nombre,
    gei_contenido as descripcion_busqueda,
    '/v1/publico/informaciones/' + CAST(gei_id AS VARCHAR(50)) as api_url,
    gei_orden as orden,
    gei_titulo_busqueda as nombre_busqueda,
    gei_archivo_fk as archivo,
    gei_logo as logo,
    ss_codigo as categoria
FROM catalogos.ss_informaciones 
JOIN catalogos.ss_categorias_informacion ON gei_cai_id = ss_id
WHERE gei_habilitado = 1 and gei_publicado = 'ANONIMO'
and ss_codigo like 'PYS%'

UNION ALL

-- Foros
SELECT 
    'Foros' as seccion,
    5 as orden_seccion,    
    gei_id as id,
    NULL as codigo,
    gei_titulo as nombre,
    gei_contenido as descripcion_busqueda,
    '/v1/publico/informaciones/' + CAST(gei_id AS VARCHAR(50)) as api_url,
    gei_orden as orden,
    gei_titulo_busqueda as nombre_busqueda,
    gei_archivo_fk as archivo,
    gei_logo as logo,
    ss_codigo as categoria
FROM catalogos.ss_informaciones 
JOIN catalogos.ss_categorias_informacion ON gei_cai_id = ss_id
WHERE gei_habilitado = 1 and gei_publicado = 'ANONIMO'
and ss_codigo like 'FORO%'

UNION ALL

-- Comentarios aprobados (también Foros)
SELECT 
    'Foros' as seccion,
    5 as orden_seccion,  
    com_id as id,
    null as codigo,
    com_alias_ciudadano as nombre,
    com_texto as descripcion_busqueda,
    '/v1/publico/comentarios/' + CAST(com_id AS VARCHAR(50)) as api_url,
    null as orden,
    com_texto as nombre_busqueda,
    null as archivo,
    null as logo,
    null as categoria
FROM catalogos.ss_comentarios 
WHERE com_aprobado = 1

UNION ALL

-- Enlaces
SELECT 
    'Enlaces' as seccion,
    7 as orden_seccion,    
    gei_id as id,
    NULL as codigo,
    gei_titulo as nombre,
    gei_contenido as descripcion_busqueda,
    '/v1/publico/informaciones/' + CAST(gei_id AS VARCHAR(50)) as api_url,
    gei_orden as orden,
    gei_titulo_busqueda as nombre_busqueda,
    gei_archivo_fk as archivo,
    gei_logo as logo,
    ss_codigo as categoria
FROM catalogos.ss_informaciones 
JOIN catalogos.ss_categorias_informacion ON gei_cai_id = ss_id
WHERE gei_habilitado = 1 and gei_publicado = 'ANONIMO'
and ss_codigo like 'ENLACE%'

UNION ALL

-- Documentos
SELECT 
    'Documentos' as seccion,
    8 as orden_seccion,    
    doc_id as id,
    doc_codigo as codigo,
    doc_nombre as nombre,
    NULL as descripcion_busqueda,
    '/v1/publico/documentos/' + CAST(doc_id AS VARCHAR(50)) as api_url,
    doc_orden as orden,
    doc_nombre_busqueda as nombre_busqueda,
    doc_archivo_fk as archivo,
    doc_logo as logo,
    null as categoria
FROM catalogos.ss_documentos 
WHERE doc_habilitado = 1;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views