Using a tree picker on an extended "Location" table

[rickyh]

I've extended the location table, and I am using the extended location table on another custom table. The Tree Picker attribute doesn't seem to work on the "Location" field on the custom table. I'm assuming because the "Parent" field on the extended location table is inherited from the cmn_location field which is pointing to itself "cmn_location". If I were to change the original parent field on the original location table, then the tree picker works on my custom table; but no longer works anywhere else in the system. I tried adding a custom field "u_parent" to my extended location table that points to itself; but that doesn't seem to work.

Am I missing something very simple?

[Kalaiarasan Pus]

I don't understand the question fully but you seem to be trying to change some attribute.

Have you tried dictionary override?

http://wiki.servicenow.com/index.php?title=Dictionary_Overrides

[Goran WitchDoc]

Treepicker works only if you got records that is parent to a record in the same table. For example records in sys_user_group have records that have a parent field that is referenced to the same table(sys_user_group). That is why treepicker works there. and like you said, your parent is not referenced to your custom table and that is why is isn't working.

Sadly I would see treepicker be a bit more agile, but it isn't right now.

//Göran