Hi Adil,
I have implemented in my local system and everything is working fine.
Please find the details of the implementation -
The table definition as follows - Parent field should have an attribute tree_picker = true
The Full Name column should be calculated and code should be like this -
FYI, the code below -
(function() {
var resultName = current.u_name;
var parentId = current.u_parent;
if (!gs.nil(parentId)) {
var grParent = new GlideRecord('u_location_sri'); //write your table here
grParent.addQuery('sys_id', parentId);
grParent.query();
if (grParent.next()) {
resultName = grParent.u_full_name +"/"+current.u_name;
}
}
return resultName;
})()
I have inserted few records to test the functionality and everything is working fine -
I think your issue is resolve, hopefully
Mark if it is correct or helpful.
Tomorrow, I will try to give you the details of creating the table without column name starting with 'u_'
Thanks for the answer
the solution you have suggested is not what i want, in your case there is an autocompleter and the field is not a tree picker, so it suggest just columns names in when you search.
what i want is to get the full name (parent1/parent2/parent3/son) when clicking the son in the tree.
for example: for the field location, we can choose the location as a tree:
if i click "401 Crestwood Blvd, Birmingham AL" i get this into the field:
but i can configure my form to get the full name of the location, i mean all parent of that location like this:
in servicenow this option is available for the location field, the location field by default has tree picker as true in its attributes.
So the question is how i can do that for my own field , i want to add a field and configure its tree picker attribute as true, and get the full name
Thank you
Thanks for explaining in detail, I think you have to follow an heirarchy in constructing the new table.
In the new table, there should be a parent field which refer to its own self, like in Location table -
In the new table, enter a top record, for example
- Americas,
- then North Americas (Americas will be parent for this record)
- then California (North Americs will be parent...) etc.
And when you refer this new table anywhere, please make tree_picker = true. I think this will list the new table's records in heirarchial way -
Hope this helps -
There is parent field which is reference to location table itself.
Mark if it is helpful or correct, feedback is appreciated
