Build & Update nuget fails about querytree HOT 7 CLOSED

"how do we update querytree nuget code & dlls"

I'm not really sure what this means, what are you trying to achieve?

In there query screen is there an option to search text like/contains -- "John*" or Johnson etc

No, but you can add more than one filter, and there are options like "Contains", "Starts with" and "Ends with" so you can have combinations of "Starts with" and "Ends with"

where should I put a break point or how can I catch/watch/copy the pre-constructed and post-constructed query on the backend

Set a breakpoint in the GetSql in Engine/Query.cs or the GetData method in Web/Managers/DbManager.cs. You'll see the SQL that is generated by each query that is submitted.

from querytree.

This looks like the issue is, you only have .NET Core 2.1 installed, but QueryTree is referencing .NET Core 2.0 libraries. We should update QueryTree to .NET 2.1.

from querytree.

Awesome thanks for the update. Now I am able to update the other packages, and I noticed after updating all 3rd party nuget packages (EF, Newton etc) it runs much much faster!

• Another question - how do we update querytree nuget code & dlls, can you please share the update command to access the query tree. This would help with adoption as well?
• In there query screen is there an option to search text like/contains -- "John*" or Johnson etc.

• To help report some testing, I am trying to post some debug information to help out here - where should I put a break point or how can I catch/watch/copy the pre-constructed and post-constructed query on the backend? I am trying to add a debug window to show the query that was constructed

from querytree.

It would be nice to update nugets like so
>Update-Package Qtree -ProjectName MyProject

Contains works well, except in the scenario where there are two wild card searches, for e.g. if we wanted all the ID values in [IDjohnDept90shift2, IDJuliaDept90shift3,.. ] ID*Dept90* here we want every ID with Dept90

Lastly is a CSV file possible for a datasource?

from querytree.

It would be nice to update nugets like so

Update-Package Qtree -ProjectName MyProject

The QueryTree project is built against specific versions of each nuget package. The packages used are defined in the .csproj files. You can't just change the versions of the DLLs that it's using without testing the overall application, but the develop branch is being developed against .NET Core 2.1 and updated versions of various packages. Once develop is ready, we will merge it into master and so the nuget packages used will be updated.

Lastly is a CSV file possible for a datasource?

No, QueryTree is designed to give users a visual way to generate SQL queries. But you could import the CSV file into a database engine using sqlizer.io.

from querytree.

Help me

from querytree.

@djshres you need to run npm install less -g

from querytree.