Finance | Project Operations, Human Resources, ...

Data not getting filtered even after adding fixed field relation

(1) Share

Report

Posted on by spidey1010

203

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.

I have the same question (0)

All responses (11)

Answers (0)

Sort by

Mohamed Amine Mahmoudi 26,803 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

can you please share with us more details ?

Best regards,

Mohamed Amin Mahmoudi

Was this reply helpful? Yes No
spidey1010 203 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,803 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

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

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
spidey1010 203 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,803 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
spidey1010 203 on at

Like (1)

Report
Copy link

Link copied!

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

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

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
spidey1010 203 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Is your question answered? If yes, then please verify the answers that helped

Was this reply helpful? Yes No