Devart Forums

Code: Select all

var list = _query.Search(x => x.DataSource.Equals(param1) && (x.User.Login.Equals(login) || x.User == null));

var result = 
    (from item in list
     select new
     {
         item,
         filters = item.Filters,
         data    = from a in item.Data
                   where a.User.Login == login
                   select new { data, data.Values },
         filters2 = from b in item.Filters2
                    select new { b, b.Values },
         default = item.Default,
         columns = from c in item.Columns
                   where c.Show
                   orderby c.Order
                   select c
     }).AsEnumerable();

result.First();

Code: Select all

select to_char(null) as a
from tab1
union select to_number(null) 
from tab2