Get pk from global typehead function that returns a string

[deezzub]

I have a valuelist with a global function for a typeahead field, that return the name of a customer, because I need the name to be stored in the dataprovider. After the customer is selected, I use a relation that is defined by customername to customername to update the other customer fields, like customerId etc., in my document. The problem is, if the customer name exists twice, the other fields could not be updated, if I select the other customer name in the typeahead field.

How can I get also the identifier for the customer record?

[Harjo]

Than you need a valuelist that shows names but returns some kind of ID. Than a relation back to you customers from ID to ID

[deezzub]

Harjo:
Than you need a valuelist that shows names but returns some kind of ID. Than a relation back to you customers from ID to ID

Hello Harjo, but I need the customer name in the dataprovider from the field where the typeahead valuelist method is attached. If I do your suggestion, then the id is returned to the dataprovider. That is what I want to avoid.

[deezzub]

I changed the customer name dataprovider to the customer id and return the customer id from the global valuelist method. In the valuelist I added a fallback valuelist from the table where I store the customer name and id. The valuelist is configured to show the customer in the field and return the customer id to the dataprovider.

This seems to work, except for the Servoy Framework find mode. If I want to search for a customer name, it does not find the desired records.

How can I bypass this?

[deezzub]

The observed the problem in the Servoy Framework function svy_sea_search. I have 2 fields on my form: fld_customer_number and fld_customer_name which both have the dataprovider anmand attached, which the customer id number. The field fld_customer_name has the above valuelist with fallbackvaluelist attached, so it displays the customer name.

Field customer number with dataprovider anmand

[attachment=2]2014-08-06_14_23_02-Servoy_Design_fld_customer_number.png[/attachment]

Field customer name with dataprovider anmand

[attachment=1]2014-08-06 14_24_19-Servoy_Design_fld_customer_name.png[/attachment]

Field customer name with no data, but in this field the search string is entered.

[attachment=0]2014-08-06_14_33_45-Servoy_debug_fld_customer_name.png[/attachment]

[deezzub]

[attachment=2]2014-08-06_14_35_33-Servoy_debug_fld_customer_name_2.png[/attachment]

Field customer number with data, but in this field the search string is not entered.

[attachment=1]2014-08-06_14_36_47-Servoy_debug_fld_customer_number.png[/attachment]

[attachment=0]2014-08-06_14_37_50-Servoy_debug_fld_customer_number_2.png[/attachment]

If I replace:

dataValue = forms[formNames[l]][dataProv];

with the search string:

dataValue = "Briese Schiffahrts GmbH & Co. KG MS \"Ostland\"";

the search works as aspected.

Is this a bug in Servoy or in Servoy Framework or do I need some better understandig how it works?

[deezzub]

deezzub:
I changed the customer name dataprovider to the customer id and return the customer id from the global valuelist method. In the valuelist I added a fallback valuelist from the table where I store the customer name and id. The valuelist is configured to show the customer in the field and return the customer id to the dataprovider.

This seems to work, except for the Servoy Framework find mode. If I want to search for a customer name, it does not find the desired records.

How can I bypass this?

As a quick workaround, I created a patch that fixes it. There are of course some improvements to the code. It is available at SVYFRMWK-790: Cannot search in a field with attached valuelist (display / real value)