Circular parent/child relationship

ericeger · ‎05-26-2015

Hi everyone,

I'm working on creating an organization table that will have a reference to parent organizations. My concern is that when I create or change an organization, it should not be able to find a parent organization where the parent organization is already a child organization. For example, Company 1(child) has a parent of Company 2. If I go back to Company 2 and select the Parent Organization reference field, I don't want to see Company 1 in that list because its already a child of Company 2.

I was looking around the reference qualifiers and didn't see anything that could help me. Any help in the right direction would be great, thanks!

Ahmed Drar · ‎05-27-2015

your code should look like that

var CompanyList = Class.create(); CompanyList.prototype = Object.extendsObject(AbstractAjaxProcessor, {

getCompanyList: function(CurrSysID)

{

var CompanyList= "";

var gr = new GlideRecord("x_mpaii_snap_trace_organizations");

gr.addEncodedQuery("sys_id!=" + CurrSysID + "^parent_organization!=" + CurrSysID);

gr.query();

while(gr.next())

{

CompanyList += gr.sys_id + ",";

}

return "sys_idIN" + CompanyList;

},

type: 'CompanyList' });

test out this code and let me know whether it works or no

View solution in original post

ericeger · ‎05-27-2015

I had to adjust the AbstractAjaxProcessor to be global for some reason, but it works very well! I'll have to add something to the query so that an entry that doesn't have a parent organization will appear on my list. Thanks a lot Ahmed!

NYoks1 · ‎05-27-2015

Try placing semi-colon at the end of line 11.

ericeger · ‎05-27-2015

I did fix that, but thank you, good call!