How to make multiple field references

[Arthur Sanchez]

The Area field has the options:

ti and seg: IT in the field system: APP, BRM, CAPTA, GPP

SEG in the system field: SMS, IMS, ACS

Now the problem is, I need to reference it multiple times, so when the Area field is selected the following are presented in the Service Type field:

TI

1. Configuration
2. Maintenance
3. Customization
4. Installation
5. Consulting
6. Backup and Recovery
7. Training
8. Request

SEG

1. Configuration
2. Maintenance
3. Backup and Recovery
4. Training
5. Request
6. Incident

some fields are repeated and so I am unable to reference them, the first reference I did this way

[-O-]

You can use dictionary attribute choice_script - which is kinda' like a reference qualifier for choice lists.

I don't call it an equivalent because in a reference qualifier one has access to the whole current record, but in a choice script one has access only to global variable dependent_value.

That said here's how you can do it:

1. Make dependent_value a list (of dependent choices, of course):
   
2. Modify script include global.Incident by including following functions - there might already be stuff in there, in which case you can't just replace the contents, you need to mix in the new parts:
   

   var Incident = Class.create();
   
   Incident.prototype = Object.extendsObject(IncidentSNC, {
   
   	'initialize': function (incidentGr) {
   		IncidentSNC.prototype.initialize.call(this, incidentGr);
   
   		this._u_dependentValue = typeof dependent_value == 'undefined' ? '' : dependent_value;
   		this._u_sessionLanguage = gs.getSession().getLanguage();
   	},
   
   	'u_getSericeTypesForArea': function () {
   		return this._u_getEmptyList() || this._u_getLoadedList();
   	},
   
   	'type': 'Incident',
   
   	'_u_addRecordToChoice': function (glideChoiceList, record) {
   		glideChoiceList.add(record.value, record.label);
   		return glideChoiceList;
   	},
   
   	'_u_getEmptyList': function () {
   		if (this._u_dependentValue == '')
   			return new GlideChoiceList();
   	},
   
   	'_u_getLoadedList': function () {
   		return new GlideQuery('sys_choice')
   			.where('name', 'incident')
   			.where('element', 'u_service_type')
   			.where('language', this._u_sessionLanguage)
   			.where('inactive', false)
   			.where('dependent_value', 'CONTAINS', this._u_dependentValue)
   			.limit(999)
   			.orderBy('sequence')
   			.select(['label', 'value'])
   			.reduce(this._u_addRecordToChoice, new GlideChoiceList());
   	},
   
   });​

   Note that as is, this will show no choices in lists!
   If you want all choices to be shown when no dependency is selected (e.g. in lists) you need to modify function u_getSericeTypesForArea to be:

   	'u_getSericeTypesForArea': function () {
   		return this._u_getLoadedList();
   	},

   Also I'm assuming you will have the list defined for all available languages.
   If you don't do that and only defined the list for language code en, you need to modify the query to filter language not to the session language, but to code en.
   I'm also assuming the name of the field is u_service_type; if this is not the case, adjust accordingly.
   Another assumption is that the list is defined for table incident; if this is not the case, adjust accordingly.

3. Add the dictionary attribute to field "Service type":

    or, in text:

   choice_script=new global.Incident().u_getSericeTypesForArea()

I suppose that's about it.

Here's how it looks at my end with a prototype I have created:

• when no area is selected:
• when SEG is selected:
• when TI is selected:

[Arthur Sanchez]

Bro, it seems like your idea works, the problem is that I don't understand how to make it work

my service type:

my table is: x_1316384_tickets_tickets
I already put the values of dependent fields in my service type, now what?

I didn't understand what you did and how you did it

My application looks like this:

[-O-]

You need to add the attribute (into field Attribute).

[Arthur Sanchez]

Dude give me a step by step guide on how to do this, I don't even know where to put this script and how to call it