Stack Overflow
Stack Overflow

Questions tagged [easyquery]

EasyQuery, an Ad-hoc visual query designer for web-sites (that requires some advanced searching and/or filtering functionality). It supports different query languages (SQL, Entity SQL, Linq, Filter expression) and all popular databases: SQL Server, MySQL, Oracle, Access, Postgre SQL, etc.

EasyQuery, an Ad-hoc visual query designer for web-sites (that requires some advanced searching and/or filtering functionality). It supports different query languages (SQL, Entity SQL, Linq, Filter expression) and all popular databases: SQL Server, MySQL, Oracle, Access, Postgre SQL, etc.

11 questions
2
votes
1 answer

LoadModel Error,LoadQuery Error in korzh Easy Query query builder

I am using Korzh Easy Query in my ASP.NET MVC project. Included the default easy query view in my views and its respective controller. When the page load i am getting a load model error. But when i remove the modelName parameter in the easy query…
Maiyarasu
  • 33
  • 3
1
vote
2 answers

EasyQuery - Wrap All Columns in the Select Statement in Brackets

I have easy query code that generates a dynamic SQL statement: //Model is loaded with "model.LoadFromConnection" var EasyQueryCachedObject = new DbQuery(); EasyQueryCachedObject.Model = model; //Specified…
David Rogers
  • 2,601
  • 4
  • 39
  • 84
1
vote
1 answer

How to do left join in korzh easy query builder?

I have implemented korzh easy query builder in a web application using asp.net mvc and sql server, so customer can make their custom queries and do data analysis. I got stuck in scenario where I have some tables Customer (CustId PK,Name,FriendId FK…
R K Sharma
  • 845
  • 8
  • 23
  • 42
1
vote
1 answer

Localization of Korzh EasyQuery in asp.net mvc

I'm trying to localize the Korzh component EasyQuery. I'm actually halfway as I managed to localize the ui messages. But the entity names, the attributes and the operators desperately remains in English. Here is what I've done (referring step…
Francois Stock
  • 685
  • 1
  • 9
  • 17
1
vote
1 answer

Not able to get condition operators in EasyQuery

I was exploring EasyQuery for our db requirements. i downloaded the trial version and in samples i replaced my datamodel created using EasyQuery itself. but when i run the sample project in condition panel where there is text to choose condition…
Radhi
  • 6,289
  • 15
  • 47
  • 68
0
votes
1 answer

How to convert SQL select queries to korzh easy query data model and export to XML

Previously I was using KORZH Easy Query Data Model builder for AD-Hoc reporting. I was using Data Model Editor tool for that manually. Now I am using dev express query builder to generate queries but my previous AD-Hoc reporting requires XML based…
Meghanath Nalawade
  • 1
  • 1
0
votes
3 answers

SQL QUERY - NO DUPLICATE RESULTS

I have the below table, named shop: Can you suggest the query to have no duplicate "product" results associated with the most recent delivery date. Thanks
Paul
  • 1
0
votes
0 answers

understandin EaayQuery how it is pulling data from sql server

I need some help understanding how easy query executes a query in which table name seems to be prefixed with eq.Sometable. Now in database there is no schema eq nor there is a table by name Somerable. But I looked at query in profiler, and then ran…
user1063108
  • 662
  • 1
  • 10
  • 24
0
votes
1 answer

EasyQuery - Add subquery by code

I am trying to nest my queries with easy query by using javascript. var query = new EQ.core.Query(); // fill in the query var finalQuery = EQ.client.getQuery(); finalQuery.addColumn({ "caption": "Item", "sorting":…
Identity
  • 1,553
  • 1
  • 22
  • 44
0
votes
1 answer

I can not use manipulated data in EasyQuery?

Suppose I have 4 columns. I want write query as Select Name,Age,DOB,'' as Salary; I am not able to write ('' as Salary) in easy query? Also I am not able to use union in easy query? How to write sub query in Select statement?
Ashish Shah
  • 1
0
votes
1 answer

The Entity is not getting loaded in Easy Query builder in MVC Application

I have added the Easy Query Builder in to my MVC project by using the demo application of Easy Query Builder and i have added the .css and .js file according to the demo project. while executing the entity is not getting loaded and the constructor…
Gowthaman
  • 790
  • 1
  • 10
  • 29