Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Fill from a structured array

Highlighted
Jacob Heubner
Honored Contributor

Fill from a structured array

I've got a table, itascaapprovingmgr, with the following fields:
director, character, no duplicates
director.name, character
approving.managers, structure
manager.id, array
manager.id, character
manager.name, array
manager.name, character
sysmodtime
sysmoduser

In the Change ticket, I'm trying to make a link that will go to the itascaapprovingmgr table, display a list of manager.ids and manager.names based on a query on the director, and will pull back the manager.id the user selects and fill it in the coordinator field on the Change ticket.

I'm having problems in the link expression doing this. I can't find any documentation or examples on how to pull one item back from a structured array and fill it in a character field.

Any help would be appreciated.
4 REPLIES
Jacob Heubner
Honored Contributor

Re: Fill from a structured array

closed
Robin_85
Occasional Visitor

Re: Fill from a structured array

Same problem... any solution Jacob...
The more I learn SC the more I learn I dnt know...
Jacob Heubner
Honored Contributor

Re: Fill from a structured array

Robin -
What I ended up doing was changing my table.
Instead of a structured array, I mad a new table with the elements in the array as values; kind of like the subcategory, problemtype and producttype tables in the system.
Robin_85
Occasional Visitor

Re: Fill from a structured array

Thanks, Same thing I did... :)
The more I learn SC the more I learn I dnt know...
//Add this to "OnDomLoad" event