Hi,

Back again with antoher problem/question:

1                MyNewsQuery.Select(MyNewsQuery, NewsItems.Title.As("NewsItemTitle"))
2                MyNewsQuery.InnerJoin(NewsItems).On(MyNewsQuery.Id = NewsItems.IdNews)
3                MyNewsQuery.Where(MyNewsQuery.Datedisplay.LessThanOrEqual(Now()))
4                MyNewsQuery.Where(MyNewsQuery.Dateexpiration.GreaterThanOrEqual(Now()))
5                MyNewsQuery.Where(MyNewsQuery.IdCategory.Equal(Category))
6                MyNewsQuery.Where(MyNewsQuery.Datedisplay.GreaterThanOrEqual(Now().AddMonths(-2)))
7                MyNewsQuery.Where(MyNewsQuery.Ndelaygroup.LessThanOrEqual(Level) Or (((MyNewsQuery.Datedisplay + MyNewsQuery.Delay) <= Now()) And MyNewsQuery.Delay <> 9))
8                MyNewsQuery.OrderBy(MyNewsQuery.Datedisplay, esOrderByDirection.Descending)

On line 7 I want to add a delay (number of days to delay the news item from being shown to everyone, which is stored in my table) to the datedisplay of my newsitem (also stored in my table). But on executing the query ES outputs "MyNewsQuery.Datedisplay + MyNewsQuery.Delay" as just the "datedisplay" without adding the "+ delay" to my query.

Am I using the wrong syntax here to add two column values together in the query (Oracle DB) or is something going wrong in ES conversion to Oracle DB query?

Thanks in advance for the replies!

Is it actually possible to execute a query in plain text, and then load the results in an EntitySpaces object? If so, even when a join is involved?

Yes, and I'm sorry I haven't gotten back to you, to be sure, I will test and fix this for ES2008 if there is a problem found.

namespace BusinessObjects
{
    public partial class CategoriesCollection : esCategoriesCollection
    {
        public bool CustomLoad(int id1, int id2)
        {
            return this.Load(esQueryType.Text,
                "SELECT * FROM yada WHERE field1 = {0} AND field2 = {1}",
                id1, id2); 
        }
    }
}

You can load EntitySpaces from any form of custom SQL you can dream up.