Adding multiple reference columns to a reference field on a UI Page

[jr1287]

How can I add multiple reference columns to a reference field on a UI Page?

For example, I'd like all user's names to populate with their associated company/id

I've tried adding attributes to the sys_user table, and that works wonderfully for typical user reference fields, but I'm having trouble when it's a UI Page. 

Any help would be appreciated!

[James Chun]

Hi @jr1287,

Have you tried adding columns attribute?

e.g.

 <g:ui_reference columns="company;employee_number" name="user" id="user" table="sys_user" completer="AJAXTableCompleter"/>

Cheers

[swathisarang98]

Hi @jr1287 ,

If you have used g_ui_reference jelly tag please send the code of entire page so that i could help you ?

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang

[jr1287]

I found a solution to the issue without using g.ui_reference, for anyone who needs it in the future.

transport: function (params) {
							var retrieveURL = 'api/now/table/' + employeeTableName + '?sysparm_query=' + employeeDisplayField + 'CONTAINS' + params.data.q + '&sysparm_fields=' + employeeDisplayField + ',' + employeeIdField + ',' + employeeNumberField + ',' + employeeCompanyField;
							return $http.get(retrieveURL).then(function (response) {
								params.success.apply(this, [response]);
							});
						},
						results: function (response, page) {
							var pageSize = 20;
							var responseResult = response.data.result;
							var total = responseResult.length;
							var results = [];

							// Add items to result set
							for (var i = 0; i < responseResult.length; i++) {
								var item = responseResult[i];
								results.push({
									id: item[employeeIdField], 
									text: item[employeeDisplayField] + ' / ' + item[employeeNumberField]  + ' / ' + item[employeeCompanyField],
									employee_number: item[employeeNumberField],
									employee_company: item[employeeCompanyField],
								});
							}