If you're SQL backend, do an update query, setting all menu table rows that you don't want to appear to menu.checkbox01 = 1.
Then in your query exclude all menu items where checkbox01 = 1.
Then in your query exclude all menu items where checkbox01 = 1.
On Wed, 10/17/12, Vic Drecchio <vic.drecchio@...> wrote:
From: Vic Drecchio <vic.drecchio@...>
Subject: RE: [Vantage] Licenced modules
To: vantage@yahoogroups.com
Date: Wednesday, October 17, 2012, 12:21 PM
Â
I've searched deep in the db for that before and never could find an answer.
Let me know if you do. I just ended up manually excluding them. I know I
don't have the Payroll module, so MenuID not like 'PRM%'
Good luck.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
nbuckman@...
Sent: Tuesday, October 16, 2012 6:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Licenced modules
Hello,
I am writing a BAQ for user security and I want to exclude from the report
menu list modules that we have not licenced. Can anyone guide me to the
field or table that governs that?
- Neil
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5336 - Release Date: 10/16/12
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5336 - Release Date: 10/16/12
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]