Candidaturas > noticias >
DATEDIFF(dy,CONVERT(smalldatetime,'25/06/2022 00:00:00',103),PAGINA.PAGINA_DATA_PUBLICACAO)<=0(DATEDIFF(dy,CONVERT(smalldatetime,'25/06/2022 00:00:00',103),PAGINA.PAGINA_DATA_ARQUIVO)>=0 OR PAGINA.PAGINA_DATA_ARQUIVO IS NULL)PAGINA.PAGINA_ACTIVO=1PAGINA.PAGINA_NOME_INTERNO = 'candidatura_initial'361Candidatura
<img src="/mgallery/default.asp?obj=3499" title="Apresentação dos Cursos" border="0" />NullNullNullNull15/04/2016 17:30:17Null15/04/2016 17:30:171PortuguêsNull1NullNullcandidatura_initialNullPAGINAPáginas do siteNull0Conteúdos de uma página119db.default.table.conPAGINAPáginas do siteNull0Conteúdos de uma página100000000Erro ao obter registos... Informação adicional : SQL=SELECT
WBFIELD_ID as ignore_xml_out_WBFIELD_ID,
WBFIELD_NAME as name,
WBFIELD_LABEL as label,
(case when WBFIELD_HELP IS NULL
then 0
else 1
end) as has_help,
WBFIELD_TIP AS tooltip,
(SELECT WBFIELD_NAME FROM WBFIELD AS WBF WHERE WBF.WBFIELD_ID=WBFIELD.WBFIELD_RELATED_FIELD_ID) AS source_field,
(SELECT WBTABLE_NAME FROM WBFIELD AS WBF,WBTABLE AS WBT WHERE WBT.WBTABLE_ID=WBF.WBFIELD_TABLE_ID AND WBF.WBFIELD_ID=WBFIELD.WBFIELD_RELATED_FIELD_ID) AS source_table,
(SELECT WBTABLE_CONSETTING FROM WBFIELD AS WBF,WBTABLE AS WBT WHERE WBT.WBTABLE_ID=WBF.WBFIELD_TABLE_ID AND WBF.WBFIELD_ID=WBFIELD.WBFIELD_RELATED_FIELD_ID) AS source_dbkey,
(SELECT WBFIELDTYPE_TEMPLATENAME
FROM WBFIELDTYPE WHERE
WBFIELDTYPE_ID=WBFIELD_FIELDTYPE_ID) as template,
(
case when
(
(SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID)
FROM WBCON_ROLE_FIELD
WHERE
WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID
AND
WBCON_ROLE_FIELD_ROLE_ID IN (17)
AND
WBCON_ROLE_FIELD_EDIT=1)>0
AND
(
(SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID)
FROM WBCON_ROLE_TABLE
WHERE
WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID
AND
WBCON_ROLE_TABLE_ROLE_ID IN (17)
)=0
OR
(SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID)
FROM WBCON_ROLE_TABLE
WHERE
WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID
AND
WBCON_ROLE_TABLE_ROLE_ID IN (17)
AND
WBCON_ROLE_TABLE_PERM_EDIT=1)>0
)
)
OR
(
(SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID)
FROM WBCON_ROLE_FIELD
WHERE
WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID
AND
WBCON_ROLE_FIELD_ROLE_ID IN (17)
)=0
AND
(SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID)
FROM WBCON_ROLE_TABLE
WHERE
WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID
AND
WBCON_ROLE_TABLE_ROLE_ID IN (17)
AND
WBCON_ROLE_TABLE_PERM_EDIT=1)>0
)
then 1
else 0
end
) AS for_edit,
(case when
(
(SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID)
FROM WBCON_ROLE_FIELD
WHERE
WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID
AND
WBCON_ROLE_FIELD_ROLE_ID IN (17)
AND
WBCON_ROLE_FIELD_ADD=1)>0
AND
(
(SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID)
FROM WBCON_ROLE_TABLE
WHERE
WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID
AND
WBCON_ROLE_TABLE_ROLE_ID IN (17)
)=0
OR
(SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID)
FROM WBCON_ROLE_TABLE
WHERE
WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID
AND
WBCON_ROLE_TABLE_ROLE_ID IN (17)
AND
WBCON_ROLE_TABLE_PERM_ADD=1)>0
)
)
OR
(
(SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID)
FROM WBCON_ROLE_FIELD
WHERE
WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID
AND
WBCON_ROLE_FIELD_ROLE_ID IN (17)
)=0
AND
(SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID)
FROM WBCON_ROLE_TABLE
WHERE
WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID
AND
WBCON_ROLE_TABLE_ROLE_ID IN (17)
AND
WBCON_ROLE_TABLE_PERM_ADD=1)>0
)
then 1
else 0
end
) AS for_add,
(case when
(
(SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID)
FROM WBCON_ROLE_FIELD
WHERE
WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID
AND
WBCON_ROLE_FIELD_ROLE_ID IN (17)
AND
WBCON_ROLE_FIELD_VIEW=1)>0
AND
(
(SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID)
FROM WBCON_ROLE_TABLE
WHERE
WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID
AND
WBCON_ROLE_TABLE_ROLE_ID IN (17)
)=0
OR
(SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID)
FROM WBCON_ROLE_TABLE
WHERE
WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID
AND
WBCON_ROLE_TABLE_ROLE_ID IN (17)
AND
WBCON_ROLE_TABLE_PERM_VIEW=1)>0
)
)
OR
(
(SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID)
FROM WBCON_ROLE_FIELD
WHERE
WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID
AND
WBCON_ROLE_FIELD_ROLE_ID IN (17)
)=0
AND
(SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID)
FROM WBCON_ROLE_TABLE
WHERE
WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID
AND
WBCON_ROLE_TABLE_ROLE_ID IN (17)
AND
WBCON_ROLE_TABLE_PERM_VIEW=1)>0
)
then 1
else 0
end
) AS for_view,
(case when
(
(SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID)
FROM WBCON_ROLE_FIELD
WHERE
WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID
AND
WBCON_ROLE_FIELD_ROLE_ID IN (17)
AND
WBCON_ROLE_FIELD_SEARCH=1)>0
AND
(
(SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID)
FROM WBCON_ROLE_TABLE
WHERE
WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID
AND
WBCON_ROLE_TABLE_ROLE_ID IN (17)
)=0
OR
(SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID)
FROM WBCON_ROLE_TABLE
WHERE
WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID
AND
WBCON_ROLE_TABLE_ROLE_ID IN (17)
AND
WBCON_ROLE_TABLE_PERM_SEARCH=1)>0
)
)
OR
(
(SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID)
FROM WBCON_ROLE_FIELD
WHERE
WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID
AND
WBCON_ROLE_FIELD_ROLE_ID IN (17)
)=0
AND
(SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID)
FROM WBCON_ROLE_TABLE
WHERE
WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID
AND
WBCON_ROLE_TABLE_ROLE_ID IN (17)
AND
WBCON_ROLE_TABLE_PERM_SEARCH=1)>0
)
then 1
else 0
end
) AS for_search,
(case when
(
(SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID)
FROM WBCON_ROLE_FIELD
WHERE
WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID
AND
WBCON_ROLE_FIELD_ROLE_ID IN (17)
AND
WBCON_ROLE_FIELD_LST=1)>0
AND
(
(SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID)
FROM WBCON_ROLE_TABLE
WHERE
WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID
AND
WBCON_ROLE_TABLE_ROLE_ID IN (17)
)=0
OR
(SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID)
FROM WBCON_ROLE_TABLE
WHERE
WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID
AND
WBCON_ROLE_TABLE_ROLE_ID IN (17)
AND
WBCON_ROLE_TABLE_PERM_LST=1)>0
)
)
OR
(
(SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID)
FROM WBCON_ROLE_FIELD
WHERE
WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID
AND
WBCON_ROLE_FIELD_ROLE_ID IN (17)
)=0
AND
(SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID)
FROM WBCON_ROLE_TABLE
WHERE
WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID
AND
WBCON_ROLE_TABLE_ROLE_ID IN (17)
AND
WBCON_ROLE_TABLE_PERM_LST=1)>0
)
then 1
else 0
end
) AS for_list,
WBFIELD_LISTABLE as listable,
WBFIELD_EDITABLE as editable,
WBFIELD_ADDABLE as addable,
WBFIELD_VIEWABLE as viewable,
WBFIELD_SEARCHABLE as searchable,
WBFIELD_ORDERING as ordering,
WBFIELD_IS_ID as is_ID,
(case when WBFIELD_SIZE IS NULL
then -1
else WBFIELD_SIZE
end) as size,
WBFIELD_WIZARD_PAGENUM as wizard_page
FROM WBFIELD
WHERE WBFIELD_TABLE_ID=119
AND (WBFIELD_ACTIVE=1 OR WBFIELD_IS_ID=1)
ORDER BY WBFIELD_WIZARD_PAGENUM ASC, WBFIELD_ORDER ASCType mismatch