Examples of org.apache.ojb.broker.query.ReportQueryByCriteria

org.apache.ojb.broker.query.ReportQueryByCriteria
Query for Reports. Supports selection of a subset of attributes. @author Jakob Braeuchi @version $Id: ReportQueryByCriteria.java,v 1.10.2.2 2005/12/21 22:27:09 tomdz Exp $

    public void testReportQueryPathExpression()
    {
        Criteria crit = new Criteria();
        Collection results = new Vector();
        crit.addLike("articleName", "C%");
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Article.class, crit);
        q.setAttributes(new String[] { "productGroup.groupName","articleId", "articleName", "price" });


        Iterator iter = broker.getReportQueryIteratorByQuery(q);


        assertNotNull(iter);
        while (iter.hasNext())

View Full Code Here

    {


        Criteria crit = new Criteria();
        Collection results = new Vector();
        crit.addEqualTo("productGroup.groupName", "Liquors");
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Article.class, crit);
        q.setAttributes(new String[] { "articleId", "articleName", "price" });
        q.addOrderByAscending("price");


        Iterator iter = broker.getReportQueryIteratorByQuery(q);
        assertNotNull(iter);
        while (iter.hasNext())
        {

View Full Code Here

    {


        Criteria crit = new Criteria();
        Collection results = new Vector();
        crit.addEqualTo("productGroup.groupName", "Liquors");
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Article.class, crit);
        q.setAttributes(new String[] { "articleId", "articleName", "price" });
        q.addOrderByAscending("productGroup.groupId");


        Iterator iter = broker.getReportQueryIteratorByQuery(q);
        assertNotNull(iter);
        while (iter.hasNext())
        {

View Full Code Here

   */
    public void testReportQueryGroupByExtents2()
    {
        Criteria crit = new Criteria();
        Collection results = new Vector();
        ReportQueryByCriteria q = QueryFactory.newReportQuery(ProductGroup.class, crit);
        q.setAttributes(new String[] { "groupName", "sum(allArticlesInGroup.stock)", "sum(allArticlesInGroup.price)" });
        q.addGroupBy("groupName");


        Iterator iter = broker.getReportQueryIteratorByQuery(q);
        
//        SELECT A0.KategorieName,sum(A1.Lagerbestand),sum(A1.Einzelpreis)
//        FROM Kategorien A0

View Full Code Here

   */
    public void testReportQueryGroupByExtents1()
    {
        Criteria crit = new Criteria();
        Collection results = new Vector();
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Article.class, crit);
        q.setAttributes(new String[] { "productGroup.groupName", "sum(stock)", "sum(price)" });
        q.addGroupBy("productGroup.groupName");


        Iterator iter = broker.getReportQueryIteratorByQuery(q);
        
//        SELECT  A1.KategorieName,sum(A0.Lagerbestand),sum(A0.Einzelpreis) 
//        FROM artikel A0

View Full Code Here

    public void testNestedJoins()
    {
        ArrayList list = new java.util.ArrayList();


        Criteria crit = new Criteria();
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Person.class, crit, true);


        q.setAttributes(new String[] { "roles.roleName", "roles.project.title", "firstname", });


        Iterator iter = broker.getReportQueryIteratorByQuery(q);
        while (iter.hasNext())
        {
            list.add(iter.next());

View Full Code Here

    public void testMultipleJoins()
    {
        ArrayList list = new java.util.ArrayList();


        Criteria crit = new Criteria();
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Role.class, crit, true);


        q.setAttributes(new String[] { "roleName", "project.title", "person.firstname", });


        Iterator iter = broker.getReportQueryIteratorByQuery(q);
        while (iter.hasNext())
        {
            list.add(iter.next());

View Full Code Here

   */
    public void tesXNestedJoins2()
    {
        ArrayList list = new ArrayList();
        Criteria crit = new Criteria();
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Task.class, crit);


        q.setAttributes(new String[] { "role.roleName", "role.project.title", "role.person.firstname", });


        Iterator iter = broker.getReportQueryIteratorByQuery(q);
        while (iter.hasNext())
        {
            list.add(iter.next());

View Full Code Here


        ArrayList list = new ArrayList();
        Criteria crit = new Criteria();
        crit.addEqualTo("groupId", new Integer(5));


        ReportQueryByCriteria q = QueryFactory.newReportQuery(ProductGroupWithAbstractArticles.class, crit, true);
        q.setAttributes(new String[] { "groupId", "groupName", "allArticlesInGroup.articleId", "allArticlesInGroup.articleName" });


        Iterator iter = broker.getReportQueryIteratorByQuery(q);
        while (iter.hasNext())
        {
            list.add(iter.next());

View Full Code Here


        Criteria crit = new Criteria();
        crit.addGreaterOrEqualThan("allArticlesInGroup.articleId", new Integer(1));
        crit.addLessOrEqualThan("allArticlesInGroup.articleId", new Integer(5));


        ReportQueryByCriteria q = QueryFactory.newReportQuery(ProductGroup.class, crit, true);
        q.setAttributes(new String[] { "groupId", "groupName", "allArticlesInGroup.articleId" });


        Iterator iter = broker.getReportQueryIteratorByQuery(q);
        while (iter.hasNext())
        {
            Object obj = iter.next();

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.ojb.broker.query.ReportQueryByCriteria

org.apache.jetspeed.components.portletpreferences.PortletPreferencesServiceImpl

org.apache.jetspeed.security.spi.impl.JetspeedSecurityPersistenceManager

org.apache.ojb.broker.PersistenceBrokerTest

org.apache.ojb.broker.QueryTest

org.apache.ojb.broker.util.BrokerHelper

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.