Hi All

I am trying to add more fields onto the Notes datagrid.  Adding fields from the current table is easy enough as below

if (_hqlBindingSource == null)<br />            {
                List<HqlSelectField> sel = new List<HqlSelectField>();
                sel.Add(new HqlSelectField("id", "HistoryId"));
                sel.Add(new HqlSelectField("Description", "Description"));
                sel.Add(new HqlSelectField("CreateDate", "CreateDate"));
                sel.Add(new HqlSelectField("Notes", "Notes"));
                sel.Add(new HqlSelectField("CreateUser", "CreateUser"));
                _hqlBindingSource = new WebHqlListBindingSource(sel, "History");
            }
            return _hqlBindingSource;

However I am not to sure how I would change the CreateUser to FirstName,LastName from the userinfo table.

Also does anyone know any good sites so I can learn a little more on Hql as so far all my developments have used SQL commands only

I been to busy looking at the internet when the solution is right in front of me in another page

also what are the Pro's / Con's of using Hql over Sql?

if (_hqlBindingSource == null)<br />            {
                List<HqlSelectField> sel = new List<HqlSelectField>();
                sel.Add(new HqlSelectField("h.id", "HistoryId"));
                sel.Add(new HqlSelectField("h.Description", "Description"));
                sel.Add(new HqlSelectField("h.CreateDate", "CreateDate"));
                sel.Add(new HqlSelectField("h.Notes", "Notes"));
                sel.Add(new HqlSelectField("ui.UserName", "UserName"));
                _hqlBindingSource = new WebHqlListBindingSource(sel, "History h, UserInfo ui");
            }
            return _hqlBindingSource;

and the where clause is done onformbound

HqlBindingSource.Where = string.Format("h.UserId = ui.id and Type = {0} and {1} = '{2}'", (int)HistoryType.atNote, keyId, entityID);<br />        
HqlBindingSource.OrderBy = "CompletedDate desc";
        HqlBindingSource.BoundGrid = grdNotes;
        grdNotes.DataBind();

Hi

I am trying to use the HQLdatasource control on my smart part. I have taken a HQL Datasource Control and a datagrid.

I have given all the property names such as columns, table name in my property window and mapped it to Datagrid.

But i am getting an error like

OPPORTUNITY_CONTACT

Please Help

Thanks,

Mark

HQL goes after OBJECTS, SQL goes after fields and tables.

If you don't define the fields and tables in an object (XML file, what have you) then referring to a missing ojbect in an HQL statement will give you an error.....

Thanks RJ. I got it! Thank you very much for the help

Regards,

Mark