I want to set table name in a dynamic SQL query. I tried successfully for parameter as following: /* Using sp_executesql */ /* Build and Execute a Transact-SQL String with a single parameter valu...

I'm trying to set up a dynamic query using spring data, basically I have an array with a bunch of characteristics and I need to assemble the query based on those characteristics, pretty much someth...

I have a method that does a search with filters, so I'm using Specification to build a dynamic query: public Page<Foo> searchFoo(@NotNull Foo probe, @NotNull Pageable pageable) { Specifica...

Most of my entities (not all) have two properties called CompanyId and Deleted. How would be possible to auto insert these two properties for all select requests instead of setting manually on ever...

Is there something like JPA Specifications for Spring Data MongoDB Repositories? If not, how can I make dynamic queries with repositories? A classic scenario could be a search form with optional...

I'm new to Liferay development in general, so feel free to point out if I'm going about stuff totally the wrong way. I'm trying to get a DynamicQuery object of all users within a certain group (I'...

The multirow subselect will be used in the right hand side of the in operator in the where clause: create table t (a integer); insert into t (a) values (1), (9); drop function if exists f(); cre...

I have a scenario where I have to use a dynamic where condition in LINQ. I want something like this: public void test(bool flag) { from e in employee where e.Field<string>("EmployeeName"...

In System.Linq.Dynamic, there are a few methods to form Select, Where and other Linq statements dynamically. But there is no for SelectMany. The method for Select is as the following: public sta...

Normally, I do this: var a = from p in db.Products where p.ProductType == "Tee Shirt" group p by p.ProductColor into g select new Category { PropertyType = g.Key, Count = g.Count() } But I...

Skip to the "specific question" as needed. Some background: The scenario: I have a set of products with a "drill down" filter (Query Object) populated with DDLs. Each progressive DDL selection wil...