1. Home
  2. Forum
  3. Angular - EJ 2
  4. Multiselect dropdown TemplateColumn error

Multiselect dropdown TemplateColumn error

We're running into a JS error and incorrect SQL statement while using the Multiselect dropdown list.

This example is based off of this demo:
https://ej2.syncfusion.com/angular/demos/?_gl=1*174andf*_ga*MjA4NzEwNzk4LjE2NjM5NDE2NTQ.*_ga_WC4JKKPHH0*MTY2Mzk0NTU1MS4yLjEuMTY2Mzk0NTY2MC4wLjAuMA..&_ga=2.10586868.1545120361.1663941654-208710798.1663941654#/material/query-builder/template

Here is a reproducible example:
https://stackblitz.com/edit/angular-24zt9j?file=app.component.ts,app.component.html

Along with a couple of screenshots attached.

The error is also reproducible when creating a Multiselect object directly, similarly to the DropDownList example.

To reproduce the issue from the above example:

  1. Select Category
  2. Change operator Starts With to In
  3. Note the JS error
  4. Select a few values from the multiselect dropdown (Food, Transportation)
  5. Note the incorrect SQL (does not use "IN" operator)

Please advise. 

Thank you!

Luke

Attachment: Archive_34d3b3e6.zip

5 Replies
YA YuvanShankar Arunagiri Syncfusion Team September 27, 2022 12:25 PM UTC

Hi Luke,


This is already a known issue from our end. The fix for the issue will be included in upcoming volume 3 release, which is scheduled on end of the September 2022. To fix the problem until the volume 3 release, we advise using the 20.2.48 version.


Regards,

YuvanShankar A


LA Luke Adams September 27, 2022 03:07 PM UTC

Hi YuvanShankar,


Thank you for the reply. We'll look forward to the volume 3 release!


In the meantime, we tried downgrading to version 20.2.48 (both query builder and dropdowns) and the issue remains.


See example at https://stackblitz.com/edit/angular-24zt9j?file=app.component.ts,package.json.


Thanks!


YA YuvanShankar Arunagiri Syncfusion Team September 29, 2022 12:45 PM UTC

Hi Luke,


We are glad to announce that our Essential Studio 2022 Volume 3 release v20.3.0.47 is rolled out and is available for download under the following link. We have included the fix for this issue in this release.
So, we suggest you upgrade our Syncfusion packages to our latest version to resolve this issue in your end. (20.3.0.47).


https://www.syncfusion.com/forums/177858/essential-studio-2022-volume-3-main-release-v20-3-0-47-is-available-for-download


Sample link: https://stackblitz.com/edit/angular-gzm6dk?file=package.json


We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance.


Regards,          

YuvanShankar A


LA Luke Adams September 29, 2022 02:35 PM UTC

Hi YuvanShankar,


The latest package version works wonderfully!


Thank you for the update!


Luke


YA YuvanShankar Arunagiri Syncfusion Team September 30, 2022 05:45 AM UTC

You are welcome, Luke. We are happy to hear that your requirement has been fulfilled. Please get back to us if you need any further assistance on this.


Loader.
Up arrow icon