Finance | Project Operations, Human Resources, ...

Data not getting filtered even after adding fixed field relation

(1) Share

Report

Posted on by spidey1010

145

Hi,

We wanted to have a lookup for a field. The lookup is coming fine but when i want to filter it using field fixed relation, its not working. Can you please suggest what can be wrong . Already tried rebuild, build models.

All responses (11)

Answers (0)

Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Data not getting filtered even after adding fixed field relation

For some reason the field fixed is not working on same table. Recently we tried for one of our requirement.

In this case only way is to with lookup method or event.
Layan Jwei 7,824 Super User 2025 Season 1 on at

Like (0)

Report

Data not getting filtered even after adding fixed field relation

Hi,

Is your question answered? If yes, then please verify the answers that helped
Layan Jwei 7,824 Super User 2025 Season 1 on at

Like (2)

Report

Data not getting filtered even after adding fixed field relation

Hi,

Your screenshot shows that you added relation between the same table

PricrDiscGroup.Field == PriceDiscGroup.GroupId?

Are you sure this is correct? As maybe field fixed doesn't work properly if it's the same table.

You can try and create a new table and add the same relation just to test and confirm if the issue is because you used the same table or not

If the same table was the issue, then you can simply override the lookup of the field
spidey1010 145 on at

Like (1)

Report

Data not getting filtered even after adding fixed field relation

Hi Martin,

This field is newly created . It has to show values of field X present in the same table . Like suppose we have X,Y,Z fields in table and I want lookup of Y to show the values of X with Z (modules )having Cust as value. Hope I am able to explain.
Martin Dráb 233,441 Most Valuable Professional on at

Like (1)

Report

Data not getting filtered even after adding fixed field relation

The relation isn't the only thing you should take into account. For example, there may be an explicitly implemented lookup() method, overriding the default lookup logic (based on a data entity).

Unfortunately, you told us very little about your particular situation, therefore giving you a specific answer is difficult.
spidey1010 145 on at

Like (1)

Report

Data not getting filtered even after adding fixed field relation

Then why it does work for other tables and not here? Am i missing something ?
Suggested answer

Mohamed Amine Mahmoudi 22,998 Super User 2025 Season 1 on at

Like (1)

Report

Data not getting filtered even after adding fixed field relation

Hi,

the answer is simple the relationship is not a filter since we have the data in the table we can display it !

Best regards,

Mohamed Amine MAHMOUDI
spidey1010 145 on at

Like (1)

Report

Data not getting filtered even after adding fixed field relation

Okay I will, but any reason why the data is not getting filtered?
Suggested answer

Mohamed Amine Mahmoudi 22,998 Super User 2025 Season 1 on at

Like (1)

Report

Data not getting filtered even after adding fixed field relation

Hi,

I think you must use a lookup method instead relation in table on your form.

Best regards,

Mohamed Amine MAHMOUDI
spidey1010 145 on at

Like (1)

Report

Data not getting filtered even after adding fixed field relation

HI Amin,

So if i add the relation of pricegroup.altPriceGroupId == PriceDiscGroup.GroupId, the lookup comes with all the values . But now i want to filter tha data having module value as cust. I added it in the relation , but its not working. Still I am getting all the values.