Hello,

I use the latest Version and have the following Problem.

Given there is a table_b with two columns (column_a string; column_b string with foreign key relation to table_a, display value: name, store value: id)

And there is a row with values test, 1 correctly shown as test, name_from_table_a

When I edit this row and change test to test2

And don't touch value from column_b

And save this

Then 
the row is stored with values test, name_from_table_a but should be test, 1

HINT:

<select id="table_3_columnb" data-input_type="selectbox" data-key="columnb" class="form-control editDialogInput selectpicker wdt-possible-values-ajax wdt-foreign-key-select" data-live-search="true" data-live-search-placeholder="Search..." data-column_header="column_b" tabindex="-98">
    <optgroup label="Currently Selected">
        <option value="name_from_table_a" title="name_from_table_a" selected="selected">name_from_table_a</option>
    </optgroup>
    <option value="" title=""></option>
    <option value="1" title="name_from_table_a">name_from_table_a</option>
</select>
THE ERROR value="name_from_table_a" of element //*[@id="table_3_columnb"]//option[@selected="selected"]

Hello, We are running into this same issue. Instead of the foreign key being entered it enters the string. So editing one cell breaks the rest, then this also does not allow for any filters to work. Please help as our main table is basically all built out on foreign keys.

Not sure where you guys are in the progress of this, but I think to have fixed why this wasn't working for us. We had the column with foreign keys with the data to view set to the default of 10. When our actual list had more than 10, once we changed to all it seemed to start saving correctly. We also had a checkbox filter on but took that off.

Bogdan,
I apologize, as I didn't open this ticket but is that solution for anyone whom is having the issue or just the person whom opened this ticket?

Thanks,

Chase

Great, thank you for your assistance on this matter and finding a solution. You've been great with support.

Hi Bogdan,

sadly your fix does not solve my problem.

I created a video showing the bug. Have a look at the attachment please.

I don't think you are able to solve this. It's definitely a bug! I don't have the time to write here again and again. I wrote a litte plugin by myself for my use case and now i simply avoid the foreign key functionality.

The example you have created uses the workaround that was proposed by Chase Sabers. By the way I have expressly forbidden you to change or access any data on MY system exept from tables with IDs 8, 9 and 10! Use your own system for testing, please!

You may close this ticket. I'm really pissed about not reading the information I've provided in this ticket and violating the rules about data access on my system.