Wrong behavior of "Entity drop-down list (ajax)" when referring to another "Entity drop-down list (ajax)" (multiselect)

Post Reply
rh@syconics.de
Sponsor
Sponsor
Posts: 92
Joined: 08 Feb 2016, 18:03
Name: Reinhard Hansmann
Location: Frankenberg/Eder (Germany)
Company Name: syconics UGhb & Co. KG

Wrong behavior of "Entity drop-down list (ajax)" when referring to another "Entity drop-down list (ajax)" (multiselect)

Post by rh@syconics.de »

If an "Entity drop-down list (ajax)" with specified "Display as" = "Dropdown multi select" refers to another "Entity drop-down list (ajax)" with same assignments and the condition is specified with MySQL "in" statement not the selected items are shown in the drop-down list of the second drop-down field. Instead always all items are shown. It looks like "in" statement does not work properly.

Please refer to demo:
https://pdemo.rukovoditel.pro/3.3/index ... mo_id=1892

Please open Test-Entity 3, select the existing item and look at the second drop-down field. This field refers in condition to the first dropdown field. But in the second drop-down field all items of Test-Entity 2 are shown.

My expectation ist, that only those items of Test-Entity 2 are shown in the list of the second drop-down field which belong to the selected items of the first Ajax field.
User avatar
support
Site Admin
Posts: 6222
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Wrong behavior of "Entity drop-down list (ajax)" when referring to another "Entity drop-down list (ajax)" (multisele

Post by support »

Found issue. File from archive replace to includes\classes\fieldstypes\

And note, the correct condition should be:

Code: Select all

find_in_set(e.parent_item_id,'[252]')
because filed 252 value is array and it will be converted to string and included in condition.
Attachments
fieldtype_entity_ajax.zip
(5.96 KiB) Downloaded 24 times
rh@syconics.de
Sponsor
Sponsor
Posts: 92
Joined: 08 Feb 2016, 18:03
Name: Reinhard Hansmann
Location: Frankenberg/Eder (Germany)
Company Name: syconics UGhb & Co. KG

Re: Wrong behavior of "Entity drop-down list (ajax)" when referring to another "Entity drop-down list (ajax)" (multisele

Post by rh@syconics.de »

Works! Thank You very much.
Post Reply