Database View - Related List/Relationships

[Monique7]

Hello Community,

I created a database view and related list/relationship that queries from this table. Everything functions as expected, however I'm unable to query to show only the related records in the related list. Are we able to do this for database view queries?

[Anurag Tripathi · Accepted solution]

Hi,

Double check the column names you are using(con_number) to make sure it is not u_con_number on either of the tables.

PS. here current refers to the 'from table' and parent is 'applies to table'

-Anurag

[Monique7]

Hi Anurag,

I updated the relationship record to the below script and it works perfectly. 

current.addQuery("con_number", parent.number);

Thank you so much for catching this!