SeeAllForms: Difference between revisions

From SMTX Wiki
Jump to navigation Jump to search
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..."
 
m 1 revision imported
 
(No difference)

Latest revision as of 21:44, 25 May 2020

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