Manage OnFindRecord Trigger of a Factbox

Troubles_In_Paradise · 2011-06-21

Hi guys!
Working with: NAV 2009 R2
Refering to this post: viewtopic.php?f=32&t=47131
I created a simple list page and a factbox (both based on the customer table, linked via SubformLink -> "No."=Field("No.")).
In the previous post, jreynolds (last but one replay) said that, when a record in the repeater of the main page is selected, the OnFindRecord trigger of the factbox is fired. He's right!
He suggests to program this trigger in order to show what you want in the factbox, but if I insert some code in it, the factbox doesn't show anything!
the following is the code I inserted in the factbox:

OnFindRecord(Which : Text[1024]) : Boolean
FILTERGROUP(4);
message(getfilter("No."));
FILTERGROUP(0);

Now I took a look to OnLineHelp in order to understand what this trigger does (I never used it), but I really can't get how to use it!

Overrides the default form behavior and enables you to specify which record you want to display when the form opens. 
[Ok]:= OnFindRecord(Which)

My question is how can I specify the record to show in this factbox (if it's possible, because I'm not sure I understood correctly the meaning of this trigger) through OnFindRecord trigger?
Thx all in advance!

mohana_cse06 · 2011-06-21

Did you try with

EXIT(FIND(Which));

Troubles_In_Paradise · 2011-06-21

mohana_cse06 wrote:
Did you try with
EXIT(FIND(Which));

Thx Mohana, with this it shows me information in the factbox.

Troubles_In_Paradise · 2011-06-21

can we change the record shown in the factbox?
for example: if I select the record with id 1000 I would the factbox to show information of the record 2000.
is it possible?

mohana_cse06 · 2011-06-21

Never tried that kind of logic

you can try

SETRANGE("No.",'2000');
EXIT(FIND(Which));

Troubles_In_Paradise · 2011-06-21

mohana_cse06 wrote:
Never tried that kind of logic

you can try
SETRANGE("No.",'2000');
EXIT(FIND(Which));

Damn! It doesn't work.

mohana_cse06 · 2011-06-21

can you show the code you tried..

Troubles_In_Paradise · 2011-06-21

mohana_cse06 wrote:

can you show the code you tried..

FILTERGROUP(4);
IF GETFILTER("No.") = '2000' THEN BEGIN
  SETRANGE("No.",'1000');
  EXIT(FIND(Which));
END;
FILTERGROUP(0);

mohana_cse06 · 2011-06-21

is your code going inside the IF loop?

can you simply try with

SETRANGE("No.",'2000');
EXIT(FIND(Which));

from other customer like 1000 or 3000..

Troubles_In_Paradise · 2011-06-21

mohana_cse06 wrote:
is your code going inside the IF loop?

can you simply try with
SETRANGE("No.",'2000');
EXIT(FIND(Which));
from other customer like 1000 or 3000..

you're right, now works!
the last thingh I'd like to try is to change values shown in factbox if the sourceExpr of fields aren't fields of a record variable but variable like string code etc...

Troubles_In_Paradise · 2011-06-21

Stupid test but it works!
end of tests... now I try in a real project.

FILTERGROUP(4);
IF GETFILTER("No.") = '20000' THEN BEGIN
  SETRANGE("No.",'10000');
  EXIT(FIND(which));
  currpage.update;
END;
FILTERGROUP(0);

thx mohana for helping me!

mohana_cse06 · 2011-06-21

Welcome..

Manage OnFindRecord Trigger of a Factbox

Answers

Categories