Skip to main content

Notifications

Announcements

Forum Structure Changes Coming Soon!
Give Back to the Community this Month
News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Data not getting filte...
Finance forum
Suggested answer

Data not getting filtered even after adding fixed field relation

(1) ShareShare
ReportReport
Posted on by spidey1010 99
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.
 
  • Layan Jwei Profile Picture
    Layan Jwei 7,150 Super User 2024 Season 2 on at
    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 Profile Picture
    Layan Jwei 7,150 Super User 2024 Season 2 on at
    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 Profile Picture
    spidey1010 99 on at
    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 Profile Picture
    Martin Dráb 229,129 Most Valuable Professional on at
    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 Profile Picture
    spidey1010 99 on at
    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 Profile Picture
    Mohamed Amine Mahmoudi 9,413 Super User 2024 Season 2 on at
    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 Profile Picture
    spidey1010 99 on at
    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 Profile Picture
    Mohamed Amine Mahmoudi 9,413 Super User 2024 Season 2 on at
    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 Profile Picture
    spidey1010 99 on at
    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.
  • Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 9,413 Super User 2024 Season 2 on at
    Data not getting filtered even after adding fixed field relation
    Hi,
     
    can you please share with us more details ?
     
    Best regards,
    Mohamed Amin Mahmoudi

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Forum Structure Changes Coming Soon!
Give Back to the Community this Month

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Replay: Dynamics 365 Community Call ERP Edition | October 9, 2024

Another great gathering of our Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans