This repository has been archived on 2023-08-11. You can view files and clone it, but cannot push or open issues or pull requests.
unireftest/sql/caption.sql
2017-02-03 21:49:53 +03:00

15 lines
No EOL
557 B
SQL

SELECT
BO_CLASSES.NAMECLASS AS NAMECLASS,
BO_CLASSES.NAMETABLE AS NAMETABLE,
BO_CLASSES.FGUID AS CLS_FGUID,
BO_ATTR_CLASSES.NAMEATTR AS NAMEATTR,
BO_ATTR_CLASSES.NAMEFIELD AS NAMEFIELD,
BO_ATTR_CLASSES.NAMESCREEN AS NAMESCREEN
FROM BO_ATTR_CLASSES
LEFT OUTER JOIN BO_CLASSES
ON BO_CLASSES.GUID = BO_ATTR_CLASSES.FGUID
INNER JOIN BO_ATTR_CLASSES AS t3
ON t3.NAMEFIELD = 'GUID' AND t3.FGUID = BO_CLASSES.GUID
AND not t3.NAMEFIELD is NULL
WHERE substring(BO_ATTR_CLASSES.ARRAYMDATA, 3,1) = '1'
ORDER BY CLS_FGUID, NAMETABLE