Miceiw
Posts: 4
|
Posted: 01/02/2011, 8:32 PM |
|
Hi
Anyone here has sample of database structure for dynamic menu
Thanks
_________________
miceiw |
|
|
AlDo
Posts: 3
|
Posted: 01/03/2011, 2:41 PM |
|
Hi,
this is one of mine.
CREATE TABLE "DBA"."T_mnu" (
"mnu_id" INTEGER NOT NULL DEFAULT AUTOINCREMENT,
"mnu_id_par" INTEGER NULL,
"mnu_des" VARCHAR(255) NULL,
"mnu_url" VARCHAR(255) NULL,
"mnu_tgt" CHAR(60) NULL,
"mnu_clr" CHAR(60) NULL,
"mnu_ttp" VARCHAR(255) NULL,
"mnu_grp" VARCHAR(255) NULL,
"mnu_srt" INTEGER NULL,
"mnu_sta" TINYINT NULL,
CONSTRAINT "PK_T_mnu" PRIMARY KEY ( "mnu_id" )
)
mnu_id = record id
mnu_id_par = parent id; so you can define infinite levels
mnu_des = description
mnu_url = the url the menu item must point to
mnu_tgt = target (e.g. _blank, _self, ...)
mnu_clr = color (optional)
mnu_ttp = tooltip (optional)
mnu_grp = group ids that can see the menu item, comma separated (optional)
mnu_srt = sort order, I usually use: ORDER BY mnu_srt,mnu_des (optional)
mnu_sta = status (e.g. 0=disable, 1=enabled, 2=enabled if ...) (optional)
I hope this helps.
Regards,
aldo
|
|
|
Miceiw
Posts: 4
|
Posted: 01/03/2011, 6:15 PM |
|
Thanks I gonna try that
_________________
miceiw |
|
|
ecsMike
Posts: 40
|
Posted: 08/22/2011, 5:01 AM |
|
While I have used CC for some time, I have never had the need to build a Dynamic Menu. I now need to do so for a project I am working on.
I would be very appreciative if you would explain how - in some detail - you filter the menu using the comma-separated values in mnu-grp.
I know how to filter the query for the menu but cannot figure out where to do it, and how to use the comma separated values.
Thank you . . . Mike
|
|
|
|