SeeAllForms

From SMTX Wiki
Revision as of 11:47, 19 December 2016 by Smtxwiki (talk | contribs) (Created page with "We created this query for Proximus, it also holds a fixed entry 'Report an issue' this is the query (created by Bart) : SELECT "Form_Id" "Id", "InternalLabel", "Title" "Titl...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

We created this query for Proximus, it also holds a fixed entry 'Report an issue'

this is the query (created by Bart) :

SELECT "Form_Id" "Id", "InternalLabel", "Title" "TitleEng" FROM "FormLanguage", "Form" WHERE "FormLanguage"."Form_Id"="Form"."Id" AND "FormLanguage"."Language_Id"=1 UNION SELECT 0 "Id", N "InternalLabel", N'Report an issue' "TitleEng" FROM dual