We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Date not getting loaded in import from sqlString

Thread ID:





145630 Jul 1,2019 08:36 PM UTC Jul 16,2019 11:43 AM UTC ASP.NET Core - EJ 2 4
Tags: Query Builder
Asked On July 1, 2019 08:36 PM UTC


I'm having an issue importing a query the queryBuilder component.

everything flows normal except the date field.

I'm using the type date and also the format I need, the one I use to save/export and import again.

relevant code:

<ejs-querybuilder id="myQuerybuilder" width="100%">
          <e-querybuilder-column field="DateField" label="Date" type="date" format="yyyy-MM-dd"></e-querybuilder-column>

---- js - functions that load the query.. ------

var querybuilderObj = ej.base.getInstance(document.getElementById("myQuerybuilder"), ej.querybuilder.QueryBuilder);
querybuilderObj.setRulesFromSql("DateField >= '2019-11-21' and Food LIKE ('%wasabi%')");

the other field (and the others also) get loaded properly, but not the date one.

Any clue?

pd: I'm using v.

Vinoth Kumar Sundara Moorthy [Syncfusion]
Replied On July 2, 2019 11:29 AM UTC

Hi Pablo, 
Good day to you. 
We have checked your reported issue and logged the defect report “Date not getting loaded in import from sqlString” for this. You can track the status of this defect using below link from our feedback portal, 
We will include the fix for this in our upcoming Essential Studio 2019 Volume 2 release and inform you once this release is rolled out. We appreciate your patience until then. 
Vinoth Kumar S 

Replied On July 3, 2019 01:20 PM UTC

Okey, please let me know when you release the new version.

Vinoth Kumar Sundara Moorthy [Syncfusion]
Replied On July 4, 2019 06:33 AM UTC

Hi Pablo, 
Thank you for the update. As promised, we will inform you once Essential Studio 2019 Volume 2 release is rolled out. 
Vinoth Kumar S 

Vinoth Kumar Sundara Moorthy [Syncfusion]
Replied On July 16, 2019 11:43 AM UTC

Hi Pablo, 
Good day to you. 
We are glad to announce that our Essential Studio Volume 2, 2019 release (v17.2.0.34) is rolled out and is available for download under the following link. 
In this release, we have fixed your reported issue “Date not getting loaded in import from sqlString”. 
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. 
Vinoth Kumar S 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon