The CreatorCon Call for Content is officially open! Get started here.

Reference field AJAXTableCompleter options

carlos_monchuch
Giga Contributor

I have two questions with relation to the AJAXTableCompleter, and am hoping one of you special people will be able to help me out:

 

Background:   I have a reference variable on a Catalog item, that has the attributes:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=last_name;email;user_name,ref_ac_order_by=last_name,ref_ac_columns_search=true,ref_ac_display_value=false

 

1.   Can I show heading for the columns? (to make it clear, i may not use on this form, but this is something ive always been wondering, and may be helpful on tables where the data is not as obvious as the user data, i.e assets etc where a different number may be in three different columns, and its not obvious what is the asset ID, and what is the serial number etc, anyway, I digress a little on that)

 

2.   Can i display more than 15 records at a time, you know how it says showing 1 through 15 of 79 for example (at the top of the popup)

 

the reason i would like to display more, is i am allowing searching on all the columns, last name, first name, email, and username, so if someone starts typing a common last name, they wont see all the results, and thus may not be able to select the user they want.   This is for a process amending user details, then updating AD, payroll and other systems.

 

Cheers for any help in advance.

Carl

3 REPLIES 3

jacob_kimball
ServiceNow Employee
ServiceNow Employee

Carl,



I believe the answer to question #2 is yes.   If you modify the property glide.xmlhttp.max_choices you can control the number max entries that can be diplsyed.   I'm interested in the answer to question #1 as well.   I haven't found a way to do it yet but believe that it would be a great thing to have!


Nice one Jacob, that was very helpful, you have no idea how crazy that was driving me.


Cheers


Carl


No problem sir!   I've posted the other question internally as well.   I've been looking for an answer to that for a while now. I don't expect any quick answer given the holidays but will try and get some traction on it as best I can.