Filters on a Boolean Field don't work in Pages German (DEA)

Troubles_In_ParadiseTroubles_In_Paradise Member Posts: 588
edited 2014-04-23 in NAV Three Tier
Hi guys,

I've one terrible issue on a NAV 2009 R2 RTC Austrian db.
I explain...
Create one simple page (no matters type):
in this example a list: ('*' to indicate indentation)

Container	ContentArea	
*Group	Repeater	
**Field	"No."
**Field	Name
**Field	"Only Distributive"
("Only distributive" is a custom Boolean field)
than put the following code:
OnOpenPage
SETRANGE("Only Distributive",TRUE);
Now we can run the page. If RTC is in english filter is applied (as expected) but, if RTC is in German (DEA) filter isn't applied (see attachments).
:shock: What the hell???

Have you ever see something like this?
Build: 33137

thanks in advance.
~Rik~
It works as expected... More or Less...

Answers

  • Troubles_In_ParadiseTroubles_In_Paradise Member Posts: 588
    Solved. There was something wrong in language folders installed on the NAV Server.
    ~Rik~
    It works as expected... More or Less...
  • MauddibMauddib Member Posts: 269
    I am having an identical issue to this myself now.

    It is not only when you use SETRANGE - but also happens if you set the filter when calling a Page from the Role Centre. Any boolean filters set simply disappear.

    The "fix" above is a little vague. Does anyone know what the "something" that was wrong is and how to fix it?
  • Troubles_In_ParadiseTroubles_In_Paradise Member Posts: 588
    Mauddib wrote:
    I am having an identical issue to this myself now.

    It is not only when you use SETRANGE - but also happens if you set the filter when calling a Page from the Role Centre. Any boolean filters set simply disappear.

    The "fix" above is a little vague. Does anyone know what the "something" that was wrong is and how to fix it?

    Probably some corrupted files in the language folders on NST.
    We copied folders from the installation DVD, overwriting existing and it worked.
    ~Rik~
    It works as expected... More or Less...
  • MauddibMauddib Member Posts: 269
    Exactly what I have done, with the difference being that it has not worked :) Damn :)
  • Troubles_In_ParadiseTroubles_In_Paradise Member Posts: 588
    Have you already restared the service?
    ~Rik~
    It works as expected... More or Less...
  • MauddibMauddib Member Posts: 269
    Yeah I have restarted the service too.

    Downloaded the language pack from mibuso also and installed the folders that way too. Neither has helped.

    It is a mystery at present.
  • MauddibMauddib Member Posts: 269
    Ok copying the folders did not work and a straight install of the language module did not work.

    However if anyone else has this issue in the future... this DID work....

    1) Stop your service.
    2) Manually DELETE the DEU ENU and DE-de folders from your Database Middle Tier installation folder.
    3) Then run the language module installation program.
    4) Restart your service.

    Having done this the problem resolved itself. Of course this does not explain what the problem was, or what fixed it, but at least it works.

    Thanks for fast replies.
Sign In or Register to comment.