Search reference field with integer column

[nicofcanlas]

Hi All,

I have a requirement to make the vendor id field searchable in the reference field so I use the variable attributes

ref_auto_completer=AJAXTableCompleter,ref_ac_columns_search=true,ref_ac_columns=name;u_vendor_id

but for some reason this doesn't work on the vendor id, I tried it on different fields and its working fine. The thing I found out is that its not working on the field with integer data type.

Does anyone has an idea on how to make integer searchable ?

[J Siva · Accepted solution]

Hi @nicofcanlas 
I don't think this is feasible. However, as a workaround, you can create a custom string-type field to store the integer value and use that custom field in the reference qualifier.
Regards,
Siva

[Ankur Bawiskar · Accepted solution]

@nicofcanlas 

I remember few years ago similar question was asked and I believe ref_ac_columns_search doesn't work well with Integer field and it's a platform limitation

Please inform this to your customer.or make that field type as String but remember for this it might have data impact as you are changing field type

If my response helped please mark it correct and close the thread so that it benefits future readers.

[J Siva · Accepted solution]

Hi @nicofcanlas 
I don't think this is feasible. However, as a workaround, you can create a custom string-type field to store the integer value and use that custom field in the reference qualifier.
Regards,
Siva

[M_Taimoor Jawai]

1) Can you change the type to string, or will there be other issues because of that?

Regards,

Taimoor

[nicofcanlas]

there would be a bigger impact for that so no I can't change the data type

[Ankur Bawiskar · Accepted solution]

@nicofcanlas 

I remember few years ago similar question was asked and I believe ref_ac_columns_search doesn't work well with Integer field and it's a platform limitation

Please inform this to your customer.or make that field type as String but remember for this it might have data impact as you are changing field type

If my response helped please mark it correct and close the thread so that it benefits future readers.