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.
Wrong behavior of "Entity drop-down list (ajax)" when referring to another "Entity drop-down list (ajax)" (multiselect)
-
- Sponsor
- Posts: 92
- Joined: 08 Feb 2016, 18:03
- Name: Reinhard Hansmann
- Location: Frankenberg/Eder (Germany)
- Company Name: syconics UGhb & Co. KG
- 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
Found issue. File from archive replace to includes\classes\fieldstypes\
And note, the correct condition should be:
because filed 252 value is array and it will be converted to string and included in condition.
And note, the correct condition should be:
Code: Select all
find_in_set(e.parent_item_id,'[252]')
- Attachments
-
- fieldtype_entity_ajax.zip
- (5.96 KiB) Downloaded 24 times
-
- Sponsor
- Posts: 92
- Joined: 08 Feb 2016, 18:03
- Name: Reinhard Hansmann
- Location: Frankenberg/Eder (Germany)
- Company Name: syconics UGhb & Co. KG