Database SQL Operation: DatastoreSchema.searchBySchemaType
Description: | Searches for schemas with the specified type. The search is a wildcard search and is case insensitive. The schema text is not returned. |
Sterotype: | nsmulti |
SELECT
s.schemaName,
CASE
WHEN t.localizedText IS NULL
THEN s.schemaName
ELSE t.localizedText
END AS schemaDisplayName,
s.schemaType
INTO
:schemaName,
:schemaDisplayName,
:schemaType
FROM
DataStoreSchema s LEFT OUTER JOIN DataStoreSchemaTranslation t
ON t.schemaName = s.schemaName
AND t.type = :type
AND t.localeIdentifier = :localeIdentifier
WHERE
UPPER(s.schemaType) LIKE :schemaType
ORDER BY schemaDisplayName ASC
|