Forum Discussion

Don_Jackson's avatar
Don_Jackson
Ideator II
3 years ago

Query Definitions - Removing duplicate rows / returning a single relationship row

Hello all. I am adding more information to the 'BOM Structure' tgv query and could use some help in removing duplicate rows. Although I know various ways of handling this in SQL, I have not been able...
Don_Jackson's avatar
Don_Jackson
Ideator II
2 years ago

For us, this happens because someone has accidentally added a duplicate Part CAD relationship. We try to clean those up as we see them, but if the BOM Structure query happens to find a duplicate then we would always prefer that only one is returned. I have not yet found a solution.

taozai's avatar
taozai
Ideator II
2 years ago

Hello,relationship item has grid event "onInsettRow",you could filter repeat relationship in this event.  

  • Don_Jackson's avatar
    Don_Jackson
    Ideator II
    2 years ago

    Relationship grid events seem very useful, I'll look into them more. Thank you!