Menu Tree [message #443128] |
Fri, 12 February 2010 21:09 |
rkgoyal98
Messages: 39 Registered: October 2009
|
Member |
|
|
Hello,
I have a form in which menu tree is populated with this sql
SELECT 1, Level, MenuLabel, MenuName, MenuId
FROM MenuFile
CONNECT BY PRIOR MenuId = ParentId START WITH menuId = :moduleid||'0000'
The result is attached in the CSV file enclosed in sheet mrnufile1
As we can see in row 3 the item LPC has menuid BDME13.
In my view This item should be in ROW 19.
How can i change query do get the desired the result.
I have also tried another sql query.
select * from menufile where applicationid = 'BD' order by parentid,menuid
Result of this query is in 2nd Half of CSV file
Kindly help me to sort out this
Regards
-
Attachment: Menu.csv
(Size: 4.34KB, Downloaded 1058 times)
[Updated on: Fri, 12 February 2010 21:20] Report message to a moderator
|
|
|
Re: Menu Tree [message #443138 is a reply to message #443128] |
Sat, 13 February 2010 00:06 |
tamzidulamin
Messages: 132 Registered: October 2009 Location: Dhaka
|
Senior Member |
|
|
Dear,
Give me your menufile table script & some sample data with insert into command not csv file.
Regrads,
Tamzidul Amin.
|
|
|
|