Menu Tree Structure Dump

Thanks for the suggestions - will give it a try.  :)
BAQ?


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Tue, Oct 28, 2014 at 12:10 PM, fite2be@... [vantage] <vantage@yahoogroups.com> wrote:

Â
<div>
  
  
  <p>Does anyone know if you can / how to export/dump the Epicor menu tree structure?  I&#39;m trying to avoid typing the entire thing by hand for a document.<br><br>Thanks in advance!<br>Renee<br>EMT International, Inc.<br></p><p><span><br></span></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>

 

SELECT

M.MENUID, M.MENUDESC, M.PARENTMENUID, X.MENUDESC AS 'PARENT_MENU_DESC',

M.PROGRAM, M.SECCODE, S.SECURITYMGR, S.ENTRYLIST, S.NOENTRYLIST, S.DESCRIPTION

FROM PUB.MENU M

INNER JOIN PUB.SECURITY S ON S.SECCODE = M.SECCODE

INNER JOIN PUB.MENU X ON M.PARENTMENUID = X.MENUID

WHERE M.OPTIONTYPE = 'I'

order by m.seccode

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, October 28, 2014 12:13 PM
To: Vantage
Subject: Re: [Vantage] Menu Tree Structure Dump

 

 

BAQ?



Jose C Gomez

Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?

 

On Tue, Oct 28, 2014 at 12:10 PM, fite2be@... [vantage] <vantage@yahoogroups.com> wrote:

 

Does anyone know if you can / how to export/dump the Epicor menu tree structure?  I'm trying to avoid typing the entire thing by hand for a document.

Thanks in advance!
Renee
EMT International, Inc.