Database SQL Operation: DatastoreSchema.searchAllSchemas
Description: | Reads all data store schema objects. This method also returns the schema display name. |
Sterotype: | nsmulti |
SELECT
s.schemaName,
CASE
WHEN t.localizedText IS NULL
THEN s.schemaName
ELSE t.localizedText
END AS schemaDisplayName,
s.schemaText,
s.schemaType
INTO
:schemaName,
:schemaDisplayName,
:schemaText,
:schemaType
FROM
DataStoreSchema s LEFT OUTER JOIN DataStoreSchemaTranslation t
ON t.schemaName = s.schemaName
AND t.type = :type
AND t.localeIdentifier = :localeIdentifier
ORDER BY schemaDisplayName ASC
|