Query Application Logic

Until Application Logic gets its own query base (🔐 requires login), you can query your hard and soft fails with custom SQL:

SELECT f.[alias]
    ,f.[name]
    ,f.[fullpath]
    ,f.[tooltip]
    ,lr.[id]
    ,lr.[type]
    ,lr.[section]
    ,lr.[name]
    ,lr.[warning]
    ,lr.[sql]
    ,lr.[parent]
    ,lr.[active]
    ,lr.[base]
    --,lr.*
FROM [lookup.requirement] lr
LEFT JOIN [folder.item] fi
    ON fi.[item_id] = lr.[id]
LEFT JOIN [folder] f
    ON f.[id] = fi.[folder_id]
WHERE lr.[type] <> 'prompt'

To see all columns, uncomment lr.*, but be aware that the Slate query tool may throw the following error because of excessively long XML in the [query] column. Direct SQL does not have this limitation.

Row size is limited to 64KB.