project QadFinancials > class BMfgMenu > business logic query MenuDetailForMenuFolders
Description
This query returns all menu folders available in the menu table (mnd_det). The caller has to filter out the root level for CHUI or AppShell.
Language is a mandatory parameter !
Parameters
query condition
each mnd_det where
mnd_det.mnd_exec >= '0' and
mnd_det.mnd_exec < 'B'
each mnt_det (outer-join) where
mnt_det.mnt_nbr = mnd_det.mnd_nbr AND
mnt_det.mnt_select = mnd_det.mnd_select AND
mnt_det.mnt_lang = icLngCode
query resultset tqMenuDetailForMenuFolders
| field name | data type | db field | description |
|---|
| tiLevel | integer | calculated | |
| tcmnd_nbr | character | mnd_det.mnd_nbr | Menu |
| timnd_select | integer | mnd_det.mnd_select | Selection |
| tcmnd_exec | character | mnd_det.mnd_exec | Execution File |
| tcmnd_uri | character | mnd_det.mnd_uri | Uniform Resource Identifier |
| tcmnt_label | character | mnt_det.mnt_label | Selection Label |
| tcmnd_label | character | mnd_det.mnd_label | Selection Label |
| tcmnt_lang | character | mnt_det.mnt_lang | Language |
| tcmnd_name | character | mnd_det.mnd_name | Name |
Internal usage
QadFinancials