Strange filter behaviour on Table Database

tfranzentfranzen Member Posts: 25
Hi,

I experience a strange behaviour of NAV 4.0 SP3 when using a filter on the virtual table Database.

What I want:
I want to give a message to the user when working in a test-database (The name of the database contains the word TEST in any form)

What I did:
In codeunit 1/LoginStart I declared a local record-variable with subtype Database (2000000048), put a filter on field "My Database" and made a FINDFIRST. I received the correct record and trigger the message. So far so good.

But now there comes the problem: when a "normal" user wants to switch the database and opens the OpenDatabase-Dialogue and makes a lookup to the existing databases only the one he has in access is shown and selectable, any other database is not.

Any ideas of solving this problem with this record are appreciated. In the meantime I use CONTEXTURL to get the database name.

Thanks
Thomas

Comments

  • matttraxmatttrax Member Posts: 2,309
    Have a look at the Session table. Filter on My Session = Yes. There is a field for the database name.

    I would, however, probably go with a different solution. Once that message is gone it is easy for the user to forget that they are in a test database. Constant visual aides, like a red background or big text that says TEST tend to help the user remember more.
  • kitikkitik Member Posts: 230
    Constant visual aides, like a red background or big text that says TEST tend to help the user remember more.

    How do you do that? Do you edit all forms on the db to add a TextBox with the message?

    Salut!
    Laura Nicolàs
    Author of the book Implementing Dynamics NAV 2013
    Cursos Dynamics NAV (spanish) : http://clipdynamics.com/ - A new lesson released every day.
  • DenSterDenSter Member Posts: 8,307
    I've found that adding the word 'TEST' to all of the menus is an effective way to do this. It takes just a couple of minutes to do it, with no development or testing
  • kitikkitik Member Posts: 230
    This change affects all companies in the database?
    Can you change the menu name for just one company? Is yes how?

    Salut!
    Laura Nicolàs
    Author of the book Implementing Dynamics NAV 2013
    Cursos Dynamics NAV (spanish) : http://clipdynamics.com/ - A new lesson released every day.
  • DenSterDenSter Member Posts: 8,307
    It affects the whole database, all companies. As far as I know there is no way to dynamically add the company name to the menus like that.
Sign In or Register to comment.