How to relate a custom Related Links table to its record?

[alexg_]

Hi,

I'm sorry for such an easy question, but my head seems to switch off after vacation..

What I have:

Env: Jakarta
1 Custom Table with Custom fields
This table has been added to the Relationships to Change Request
So I added this table to the CR as Related Link and all good, except:

The form is displayed on each CR and showing the complete set of data inside, so no relation to the current CR has been defined. 

What I need are 2 things:

1. Data stored within that table should have the direct relation to the Change Request 
2. Inside the CR it should be possible to view the data on that table, but only related to its parent Change Request.

I will attach the pic from what I want:

[punith3 · Accepted solution]

Hi alex,

Create a new reference field on the Fsb table called parent change  and the field should refer the change table, now in the relationship in the query with section add the code:

current.addQuery("parent_change", parent.sys_id);

or 

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

Now in the fsb table if you select a change in the parent_change field it will display in the associated change request under the Fsb related lists.

[alexg_]

Thanks Punith,

But this is like a workaround. I need that "Parent Change" field to be automatically filled in with the appropriate change number.

So when I add the new record to the table by pressing the "New" button in Related List "FSB" it shall open my table, and the number needs to be there already.. More than that, when I come back to the Change Request - only associated FSB records shall be displayed for a specific Change Request. For some reason, adding:

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

Didn't work for that part.. Change Request is still showing all the records. My guess that I can build a filter now where it says that "Parent Change" is same as "parent.number" (or something similar), but I cannot find the "Number" in my filters (on the screen below you can even see that the attached entries have different Parent Change number, however what I am trying to achieve - that it shall show only ones which have a relation to the current change...):

[alexg_]

Thanks Punith,

I figured it out. My bad was that I messed around with Relationship tables:

Once i swap them - it all worked. Simple as that 🙂