Problem about set table filter on flowfield

mootoon

I want set table filter Date <WORKDATE. How to solve this problem?

kriki

You mean you want the total of the flowfield filtered by date?

In code:

SETFILTER("Date Filter",'<%1',WORKDATE);

as a user:
hit Shift+F7 and in the data-filter field, put <4/5/2006

mootoon

No I mean in table filter you must lookup and choose field you want to filter and what type you want to filter such as field , filter , const and then
choose condition.

sgg

I do not think you can do that.
what you can do is what Kriki suggested.

Add that to your form that displays the Data of the
OnAfterGetRecord Trigger of the form.
i.e

OnAfterGetRecord()
SETFILTER("Date Filter",'<%1',WORKDATE);
CALCFIELDS(YourFlowField);


That should solve the problem.
But not at Design Level.

kriki

sgg wrote:

I do not think you can do that.
what you can do is what Kriki suggested.

Add that to your form that displays the Data of the
OnAfterGetRecord Trigger of the form.
i.e

OnAfterGetRecord()
SETFILTER("Date Filter",'<%1',WORKDATE);
CALCFIELDS(YourFlowField);


That should solve the problem.
But not at Design Level.

It is not possible. This is the best way to do it.