Related list copy

[sip]

Hello all ,

I have two tables Demand and Project where the Demand table is the parent table and the project is the child table of demand .

In the demand table ,there are two related list which are Stakeholders and Decision tabs .

Now the requirement is that I want the same two related list on my project table as it is in demand and Carry over any information from theses tabs into the Project when created.

Can anyone help me with how to proceed with this .

Any suggestions would be welcome 🙂 

[sip]

Hello Jaspal ,

Thanks again .

Now if I am using this code for all the projects ,if I see in the decision tab all the decisions are coming but ideally only those decisions should come which are in demand form

[Jaspal Singh]

Check below once.

(function refineQuery(current, parent) {

	// Add your code here, such as current.addQuery(field, value);
var d=new GlideRecord('dmn_demand');
	d.addQuery('project',parent.sys_id);
	d.query();
	while(d.next())
		{
			var dmnid=d.sys_id;
                        //gs.log('dmnd id is ',dmnid);

		}
	current.addQuery('parent',dmnid);
	
})(current, parent);

Thanks,

Jaspal Singh

Hit Helpful or Correct on the impact of response.

[sip]

It works .Thanks 

[sip]

Hello Jaspal ,

Can you tell me why is this the difference between demand stakeholders records and project stakeholders records.

I have attached the screenshot 

Actually I was trying to change the query frok table for stakeholder relationship I created from demand stakeholder to stakeholder register table .

so that the records other fields would be same but then it was showing me all those records from the stakeholder register table in project form .

Can you advice?

[Jaspal Singh · Accepted solution]

There isn't any. Its just the columns that are being displayed in list view.

The Stakeholder for Demand has additional () part which I guess is the portfolio value while the one in Project has normal User name displayed.

You can check for the list layout once & then get it compared once for better understanding.

Thanks,

Jaspal Singh

Hit Helpful or Correct on the impact of response.