1. Home
  2. Forum
  3. Blazor
  4. SfGantt and CustomAdaptor - Query (WHERE) not working

SfGantt and CustomAdaptor - Query (WHERE) not working

Hi there,

in my business case basically we manage projects. Every project (ProjectId) has it's own Gannt-diagram.
So the data structure on SQL-Server and the display-model is something like this:

SQL-Server:


I added a WHERE-query to the Gantt:

Gantt.razor:


But this WHERE parameter isn't passed to the DataAccessLayer:
it's not available in the customAdaptor's DataManagerRequest  dm, and the table is not filtered. 

GanttManager.cs


Hence all tasks of all projects are displayed and not only the one of the second project (Id 4):

Gantt:



In addition:
I can't even pass any parameters using Key as a work-around, it does not arise in CustomController's Read methode, either:

Gantt.razor:



Any ideas?

Cheers,
Volker

Attachment: Example_5_ab68e8fa.zip

6 Replies 1 reply marked as answer
LG Logeswari Gopalakrishnan Syncfusion Team June 19, 2020 04:44 PM UTC

Hi Volker, 
 
Please find the below response. 
 
Query 1: Query (WHERE) not working 
 
We are also facing this problem. We have logged bug report on this. You can track the status of this through the following feedback link. 
 
 
The fix will be included in our volume 2 main release which is expected to roll out on June 29, 2020. 
 
Query 2: I can't even pass any parameters using Key as a work-around, it does not arise in CustomController's Read method 
 
In our SfDataManager, we don’t have property called Key. We handled it for internal cases only. So can you please tell us for which use case you used Key property? It will very helpful to achieve your requirement asap. 
 
Please let us know if you need further details on this. 
 
Regards, 
Logeswari G 


VO Volker June 20, 2020 10:22 AM UTC

Hi Logeswari,


Gantt.razor


I tried to pass custom parameters from SfGantt to DAL using Query's AddParams. Cause this didn't work as shown before.
So I tried to use Key as a work-around.

What we found out:
We are able to read it out on the backend side in BatchUpdate methode, but not in Read methode:

GanttManager.cs


Anyway, hope you repair Query soon, our project development therefore had to be put on hold.
We are dependent on this function...

Cheers,
Volker



LG Logeswari Gopalakrishnan Syncfusion Team June 23, 2020 12:27 PM UTC

Hi Volker, 
 
We have used this Key property only to pass primary key value to server while perform batch editing. So, we can’t use this to pass additional params. If you want to pass additional parameter, then we suggest to use specific component Query property to achieve this requirement . As we said before we already logged bug report for this. 
 
Until then we appreciate your patience. 
 
Regards, 
Logeswari G 


LG Logeswari Gopalakrishnan Syncfusion Team July 8, 2020 11:56 AM UTC

Hi Volker,  
  
We are glad to announce that our Essential Studio 2020 Volume 2 release v18.2.0.44 is rolled out and is available for download under the following link.  
We thank you for your support and appreciate your patience in waiting for this release. We have included the support for Query property which is mentioned in feedback 15416.  
We have prepared the sample with Query property with Where condition. Please find the below sample link. 
Please note that we have introduced several API breaks in this release. We would like you to check the breaking changes from the below location before you upgrade. 
 
Regards, 
Logeswari G 


Marked as answer
VO Volker July 8, 2020 12:01 PM UTC

Hi Logeswari,

thank you so much for your help.
Just've tested it: WHERE works perfectly not within Gantt-component!
Problem solved... :-)

Cheers,
Volker

LG Logeswari Gopalakrishnan Syncfusion Team July 9, 2020 06:42 AM UTC

Hi Volker,  
  
Most welcome. 
 
Please get back to us if you would require further assistance on this.    
   
Regards,    
Logeswari G  


Loader.
Up arrow icon