Filter records on list page based on related table

EvR · 2016-02-04

Hi all,

Imagine this situation.
- A list based on the Sales Line table.
- On opening the list I want to filter the records shown based on the Status of the Item that is related to the Sales Line.

So I cannot filter in the SourceTableView because it displays the Sales Line and not the Item table.
How would I go about doing this the correct way?

Gr,
Erik

vaprog · 2016-02-04

Hi Erik,

If it is possible, it is best to use a FlowField in the Sales Line table.

If this is not possible, you might consider using a page based on a temporary sales line table, which you populate according to your filter condition.

And finally, you can filter the real table using code by implementing OnFindRecord and OnNextRecord triggers.

vaprog · 2016-02-04

Hi Erik,

If it is possible, it is best to use a FlowField in the Sales Line table.

If this is not possible, you might consider using a page based on a temporary sales line table, which you populate according to your filter condition.

And finally, you can filter the real table using code by implementing OnFindRecord and OnNextRecord triggers.

EvR · 2016-02-05

Thanks. I was hoping to avoid using flowfields.
I guess a temp table is the most elegant without fetching unused records from the database.

If only you could map a query to a page directly....

m_berger · 2016-02-05

Another way, without using flowfields, is using a OnFindRecord, OnNextRecord construction. Examples can be found in pages 9311, 9312 and many others.

[edit]Really should read the comments better, it had already been said

Filter records on list page based on related table

Best Answer

Answers

Categories