04-12-2011 03:18 PM
I need help with a HQL data source. I've set up an HQL data source and a grid in a form under the Contact entity. I wanted to show rows of a table/entity that have the same contactid.
i've set up all the parameters according to the help in Architect, including setting up a parameter called cid with EntityId as its value.
I know that EntityID resolves into the Id of the entity, in this case ContactID; and I use :cid in my where clause of HQL data soure. This works perfectly.
Now, If I want to use another property of Contact, let say lastname in my where clause, how would I refer to it in my parameters property ? I tried something like fn=Contact.FirstName but when I use :fn in my where clause I get a null point exception.
Any help would be appreciated.
Solved! Go to Solution.
04-18-2011 04:47 AM
you don't have to make those fields a parameter I think. Just try to use c.Firstname in your where... (imagine that you had contact c in your FROM).
There is good documentation in the Help with an example of magic carpets. Maybe have a look at that. The help in the application architect is getting better and better.
04-21-2011 10:05 AM
05-13-2011 02:18 PM
Is hql datasource available in 7.5.2?
I don't see it as an option when building a quickform, but it is shown in one of the developer videos labeled 7.5.2.
Add a Where Condition to a Data Grid
Publication Date: 2010/07/29