Additional filter on the listpage

(1) Share

Report

Posted on by CU07041903-0

I tried adding Coc for initializeQuery of listpage interaction class to add more filters but there are no expected results. Am I Missing something

Code Details are in the image

Categories:

Dynamics 365 Finance

Screenshot_2025-0...

I have the same question (0)

All responses (10)

Answers (0)

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Please tell us more about the problem.

Also, why didn't you share the code as text? Did you run into a problem with the forum?

Are you aware of the Insert Code Snippet button? (It's the second one from the right. It has no icon displayed; it looks the same for me.)

Was this reply helpful? Yes No
Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (0)

Report

Hi @CU07041903-0,

Can you please share with us your code x++ ?

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
CU07041903-0 54 on at

Like (0)

Report

I didn't find the icon.And I tried pasting the code directly as text but the category field was not showing the drop-down and post was disabled.So after multiple attempts I added a screenshot

Was this reply helpful? Yes No
Navneeth Nagrajan 2,407 Super User 2025 Season 2 on at

Like (0)

Report

Hi CU07041903-0,

A few questions:

1. Are you looking to apply filters through the PurchReqTableListPageInteraction class?

2. Are you extending the PurchReqTableListPageInteraction class?

Let us know the full scenario. It will be easier to answer the question.

A few suggstions based on assumptions:

If you are looking to extend the PurchReqTableListPageInteraction class then your filter should be like this. Assuming you are extending the PurchReqTableListPageInteraction class.

public void initializeQuery(Query _query)
{
var qbds = _query.dataSourceTable(tableNum(PurchReqTable)).addDataSource(tableNum(PurchReqLine));
qbds.relations(true);
qbds.joinMode(JoinMode::InnerJoin);
qbds.addRange(fieldNum(PurchReqLine,field1)).value('abc');

next initializeQuery(_query);
}

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

You could have saved time trying to locate the icon - I already told you that the button didn't have any. I saw it in your screenshot. Here it is:

Was this reply helpful? Yes No
CU07041903-0 54 on at

Like (0)

Report
Public void initializeQuery(Query _query) { QueryBuildDatasource qbds = _query.dataSourcetable(tablenum(PurchReqLine)); QueryBuildRange range = qbds.addRange(fieldnum(PurchReqLine,Field1)); range.value('abc'); next initializeQuery(_query); }

Was this reply helpful? Yes No
CU07041903-0 54 on at

Like (0)

Report

It is PurchReqCreatePurchListPage. I also want to understand if initializeQuery is the only place where this change can be done?

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (1)

Report

initializeQuery() is the right method for initializing the query.

For reference, you seem to be talking about PurchReqCreatePurchListInteraction class.

Was this reply helpful? Yes No
CU07041903-0 54 on at

Like (0)

Report

The posted code is not having any impact.There is no filtering based of field1 value abc provided.can I know what went wrong in that

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (1)

Report

First of all, please verify whether you extended PurchReqCreatePurchListInteraction class or you're talking about something else.

Then tell us what you found when you debugged your code. Does it get called at all? Do you see the expected query string after your code? What query string do you see in GUI then?

Was this reply helpful? Yes No