In the new related list tab the record created for one demand showing same record in all demands.

Mansi roy · ‎10-03-2024

Hello ALl,

I have created one new related list tab.I have added to demand related list.

For this i have created one new table and created the columns as required.

When i am creating any new record from this related tab it is showing in all records. But it should visible only for that record.

the Below one is relationship.

the record created for one demand is showing in all demand records.

Can anyone please help me why this is happening.

Regards,

Mansi

Animesh Das2 · ‎10-03-2024

Hi @Mansi roy ,

Firstly, you must have a reference field on Efforts table referencing Demand table record. Then in the relationship record that you created, please put this below line of code in the 'Query with' field,

current.addQuery('sys_id', parent.<reference field name from 'u_efforts' table>);

replace this <reference field name from 'u_efforts' table> with actual field name from 'u_efforts' table in the line of code mentioned above.

Since there is no condition you put in the 'Query with' field, the relationship was messed up.

If this address your question, please mark this response correct by clicking on Accept as Solution and/or Kudos.

You may mark this helpful as well if it helps you.

Thanks,

Animesh Das

View solution in original post

Mansi roy · ‎10-03-2024

Hello @Animesh Das2 ,

I am able to select demand.

Animesh Das2 · ‎10-03-2024

Ok then put other fields and save this record. After that, check this demand record(TESTDemand1) and check under Efforts tab if you can see this demand there.

Also please share the SS of the 'Relationship' record and the reference qualification tab of the 'u_number' field.

Mansi roy · ‎10-03-2024

Hi @Animesh Das2 ,

If I am putting sys_id it is becoming blank for all demand record. Nothing is showing.

Animesh Das2 · ‎10-03-2024

Can you please share SS of the relationship record? Also a SS of the reference field(Number) that is created on Efforts table by clicking 'show Number' after right click on Number field.

Otherwise hard to know what is happening exactly.

Mansi roy · ‎10-03-2024

Hi @Animesh Das2,