Users - Help needed for group by condition ...

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Users - Help needed for group by condition ...

Raj-18
Hi to all
I need to perform the group by operation in the where condition like order
by operation ,how to do this operation in opentaps ,or any other operation
similar to groups by in sql


 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Users - Help needed for group by condition ...

Raj-18

Hi Alexandre Gomes
 I am selecting value from table ,but when I use order by condition ,it will
allow duplication of value for example

In my table structure like this

Pid   info    value

12    v1       n1
13    v2       n2
14    v1       n1

Here I have 3 colum 3 record

I need to diplay value where info="v1"
In this query I get n1,n1
Here n1 value printed (2 times ),I need to print n1 only one time (if values
are same )
That is reason I need group by condition or distinct operation  




-----Original Message-----
From: [hidden email] [mailto:[hidden email]]
On Behalf Of [hidden email]
Sent: Wednesday, June 21, 2006 5:05 PM
To: [hidden email]
Subject: Users Digest, Vol 23, Issue 68

Send Users mailing list submissions to
        [hidden email]

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.ofbiz.org/mailman/listinfo/users
or, via email, send a message with subject or body 'help' to
        [hidden email]

You can reach the person managing the list at
        [hidden email]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Users digest..."


Today's Topics:

   1. Re: Help needed for group by condition ... (Alexandre Gomes)
   2. Re: What is template path? (Alexandre Gomes)
   3. Re: XML data import fails when importing more than ~10000
      products (Jacopo Cappellato)
   4. Re: XML data import fails when importing more than ~10000
      products (BJ Freeman)
   5. Re: how will email confirmation look like (Purani S)
   6. where from the body for email is called (Purani S)
   7. Re: how will email confirmation look like (BJ Freeman)
   8. Widget separator ? (Jacques Le Roux)
   9. Re: Widget separator ? (BJ Freeman)
  10. Re: Widget separator ? (Alexandre Gomes)


----------------------------------------------------------------------

Message: 1
Date: Wed, 21 Jun 2006 02:15:20 +0100
From: "Alexandre Gomes" <[hidden email]>
Subject: Re: [OFBiz] Users - Help needed for group by condition ...
To: "OFBiz Users / Usage Discussion" <[hidden email]>
Message-ID:
        <[hidden email]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Hi Raj,

Here you have an example of how to count the products in categories
using the ProductCategoryMember table.


            DynamicViewEntity dve = new DynamicViewEntity();
            dve.addMemberEntity("PCM", "ProductCategoryMember");
            dve.addAlias("PCM", "productId", null, null, null,
Boolean.TRUE, null);
            dve.addAlias("PCM", "productCategoryId", null, null, null,
Boolean.TRUE, null);
            dve.addAlias("PCM", "fromDate", null, null, null, null, null);
            dve.addAlias("PCM", "thruDate", null, null, null, null, null);
            dve.addAlias("PCM", "productIdCount", "productId", null,
null, null, "count");

            EntityCondition condition = new
EntityConditionList(UtilMisc.toList(
                    new EntityExpr("fromDate",
EntityOperator.LESS_THAN, nowTimestamp),
                    new EntityExpr("thruDate", EntityOperator.EQUALS, null)
                    ), EntityOperator.AND);
            EntityCondition havingCond = new
EntityExpr("productIdCount", EntityOperator.GREATER_THAN, new
Long(1));
            EntityListIterator eli =
delegator.findListIteratorByCondition(dve, condition, havingCond,
UtilMisc.toList("productId", "productCategoryId", "productIdCount"),
null, null);

Alexandre Gomes

On 6/18/05, Raj <[hidden email]> wrote:

> Hi to all
> I need to perform the group by operation in the where condition like order
> by operation ,how to do this operation in opentaps ,or any other operation
> similar to groups by in sql
>
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>


------------------------------

Message: 2
Date: Wed, 21 Jun 2006 02:27:13 +0100
From: "Alexandre Gomes" <[hidden email]>
Subject: Re: [OFBiz] Users - What is template path?
To: "OFBiz Users / Usage Discussion" <[hidden email]>
Message-ID:
        <[hidden email]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Hi Dhilip,

It's the path where ofbiz can find the template file for your
notification emails. The template file is generally a freemarker file
or a screen widget which is basically a way to use the composite and
decorator patterns with freemarker snippets.

Alexandre Gomes

On 6/19/06, dhilip kumar <[hidden email]> wrote:

>
> Hi
>
>     What is "template path" in email settings?
>
>
> Thanks & regards
>
> Thilip
>
>
>  ________________________________
> Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.
>
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>
>


------------------------------

Message: 3
Date: Wed, 21 Jun 2006 06:44:32 +0200
From: Jacopo Cappellato <[hidden email]>
Subject: Re: [OFBiz] Users - XML data import fails when importing more
        than ~10000 products
To: OFBiz Users / Usage Discussion <[hidden email]>
Message-ID: <[hidden email]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Nick, all,

I probably know the cause of this issue (but maybe not how to resolve
this): this issue has been introduced when that import page has been
converted to from jsp to screen widget; in fact 2 minutes is the default
transaction timeout set for screens.
In the "EntityImport" screen definition there is the following entry:

<set field="parameters.TRANSACTION_TIMEOUT" value="7200"/>

that should set the transaction timeout to 2 hours; if this doesn't work
it is probably too late to set the timeout there (or the timeout is
overriden by one of the screen's decorator)... any hints?

Jacopo

PS: Nick, you can always import your products using the command line:

http://ofbizwiki.go-integral.com/Wiki.jsp?page=SeedData



Nick Olson wrote:

> It takes about 2 minutes before it comes back with this error. I've
> tried increasing the timeout in the services.xml file, but it doesn't
> seem to make a difference.
>
> David Welton wrote:
>> On 6/20/06, Nick Olson <[hidden email]> wrote:
>>> I am trying to import 40k products into the database (I'm running
>>> postgres), but when I try to import, I get an error message that says:
>>> ERROR parsing Entity Xml file: Commit transaction failed.
>> How long is it taking?  No idea if this is the cause, but there is a
>> transaction timeout.
>>
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>



------------------------------

Message: 4
Date: Tue, 20 Jun 2006 21:52:53 -0700
From: BJ Freeman <[hidden email]>
Subject: Re: [OFBiz] Users - XML data import fails when importing more
        than ~10000 products
To: OFBiz Users / Usage Discussion <[hidden email]>
Message-ID: <[hidden email]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

I know command line would not work for me.
I import from emails (CSV, Tab, XML) websites (Txt using | delimiter,
XmL) FTP sites(zip, CSV, XML).
Some file are 8-100mb
These are done daily sometimes every four hours.

thanks for the tip where to look will see what I can do, if someone does
not pick up on it before then.


Not sure on second thought that widgets would effect a service, but will
look anyway.


Jacopo Cappellato sent the following on 6/20/06 9:44 PM:

> Nick, all,
>
> I probably know the cause of this issue (but maybe not how to resolve
> this): this issue has been introduced when that import page has been
> converted to from jsp to screen widget; in fact 2 minutes is the default
> transaction timeout set for screens.
> In the "EntityImport" screen definition there is the following entry:
>
> <set field="parameters.TRANSACTION_TIMEOUT" value="7200"/>
>
> that should set the transaction timeout to 2 hours; if this doesn't work
> it is probably too late to set the timeout there (or the timeout is
> overriden by one of the screen's decorator)... any hints?
>
> Jacopo
>
> PS: Nick, you can always import your products using the command line:
>
> http://ofbizwiki.go-integral.com/Wiki.jsp?page=SeedData
>
>
>
> Nick Olson wrote:
>
>>It takes about 2 minutes before it comes back with this error. I've
>>tried increasing the timeout in the services.xml file, but it doesn't
>>seem to make a difference.
>>
>>David Welton wrote:
>>
>>>On 6/20/06, Nick Olson <[hidden email]> wrote:
>>>
>>>>I am trying to import 40k products into the database (I'm running
>>>>postgres), but when I try to import, I get an error message that says:
>>>>ERROR parsing Entity Xml file: Commit transaction failed.
>>>
>>>How long is it taking?  No idea if this is the cause, but there is a
>>>transaction timeout.
>>>
>>
>>
>>_______________________________________________
>>Users mailing list
>>[hidden email]
>>http://lists.ofbiz.org/mailman/listinfo/users
>>
>
>
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>


------------------------------

Message: 5
Date: 21 Jun 2006 05:43:11 -0000
From: "Purani S" <[hidden email]>
Subject: Re: [OFBiz] Users - how will email confirmation look like
To: [hidden email]
Message-ID: <[hidden email]>
Content-Type: text/plain; charset="iso-8859-1"

Hi Si chen,
If I need to check with the demo data, I need SMTP server, Isn't it?

Thanks
Purani




On Tue, 20 Jun 2006 Si Chen wrote :

>Why don't you just try the demo data?  It should be pretty clear.
>
>On Jun 20, 2006, at 1:24 AM, Purani S wrote:
>
>>How will email confirmation displayed in sequoiaerp0.8.3.
>>Is the confirmation given as header in  the orderconfirmation page?
>>
>>
>>Thanks
>>Purani
>>
>>
>>
>>
>>
>>_______________________________________________
>>Users mailing list
>>[hidden email]
>>http://lists.ofbiz.org/mailman/listinfo/users
>
>
>_______________________________________________
>Users mailing list
>[hidden email]
>http://lists.ofbiz.org/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.ofbiz.org/pipermail/users/attachments/20060621/1e7cc677/attachm
ent-0001.htm

------------------------------

Message: 6
Date: 21 Jun 2006 09:30:26 -0000
From: "Purani S" <[hidden email]>
Subject: [OFBiz] Users - where from the body for email is called
To: [hidden email]
Message-ID: <[hidden email]>
Content-Type: text/plain; charset="iso-8859-1"

Hi,
Where from is the body for the email message is called. The rest of the
informations are from backend in  the table
"product_store_email_setting"(Send CC, BCC).
But where from Body is called.

This is a critical issue.
I need help.

Thanks and Regard
Purani ?
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.ofbiz.org/pipermail/users/attachments/20060621/bb3ada0a/attachm
ent-0001.htm

------------------------------

Message: 7
Date: Wed, 21 Jun 2006 03:10:36 -0700
From: BJ Freeman <[hidden email]>
Subject: Re: [OFBiz] Users - how will email confirmation look like
To: OFBiz Users / Usage Discussion <[hidden email]>
Message-ID: <[hidden email]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

ofbiz is configured to send to a SMTP server and Get from either a POP3
or IMAP server. If you need a SMTP pop3 server for testing you can run
apache James on the same machine.

I believe the Demo data reference was more to look at the code to see
how to pre load the email data.

There are many routines and services that support sending and receiving
emails.  I suggest you use a find type of program to search for the word
  mail on the folders and in the code. Once you see all that I am sure
you can figure out the rest.


Purani S sent the following on 6/20/06 10:43 PM:

> Hi Si chen,
> If I need to check with the demo data, I need SMTP server, Isn't it?
>
> Thanks
> Purani
>
>
>
>
> On Tue, 20 Jun 2006 Si Chen wrote :
>
>>Why don't you just try the demo data?  It should be pretty clear.
>>
>>On Jun 20, 2006, at 1:24 AM, Purani S wrote:
>>
>>
>>>How will email confirmation displayed in sequoiaerp0.8.3.
>>>Is the confirmation given as header in  the orderconfirmation page?
>>>
>>>
>>>Thanks
>>>Purani
>>>
>>>
>>>
>>>
>>>
>>>_______________________________________________
>>>Users mailing list
>>>[hidden email]
>>>http://lists.ofbiz.org/mailman/listinfo/users
>>
>>
>>_______________________________________________
>>Users mailing list
>>[hidden email]
>>http://lists.ofbiz.org/mailman/listinfo/users
>
>
>
> ------------------------------------------------------------------------
>
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users


------------------------------

Message: 8
Date: Wed, 21 Jun 2006 12:09:56 +0200
From: Jacques Le Roux <[hidden email]>
Subject: [OFBiz] Users - Widget separator ?
To: OFBiz Users / Usage Discussion <[hidden email]>
Message-ID: <00e201c6951a$da54b2b0$0300a8c0@LesArts>
Content-Type: text/plain; charset="iso-8859-1"

Is there something in the widget that act as a panel, frame or lign to
separate or group fields or is FTL needed for that ?

Jacques
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.ofbiz.org/pipermail/users/attachments/20060621/0f200d4c/attachm
ent-0001.htm

------------------------------

Message: 9
Date: Wed, 21 Jun 2006 03:38:14 -0700
From: BJ Freeman <[hidden email]>
Subject: Re: [OFBiz] Users - Widget separator ?
To: OFBiz Users / Usage Discussion <[hidden email]>
Message-ID: <[hidden email]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

This is more a Style setting in the CSS. Like Boxhead or topbox class.
Take a look at some of the decorators.

Jacques Le Roux sent the following on 6/21/06 3:09 AM:
> Is there something in the widget that act as a panel, frame or lign to
separate or group fields or is FTL needed for that ?

>
> Jacques
>
>
>
> ------------------------------------------------------------------------
>
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users


------------------------------

Message: 10
Date: Wed, 21 Jun 2006 12:34:58 +0100
From: "Alexandre Gomes" <[hidden email]>
Subject: Re: [OFBiz] Users - Widget separator ?
To: "OFBiz Users / Usage Discussion" <[hidden email]>
Message-ID:
        <[hidden email]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Hi Jacques,

You have this stuff you can use in the form widget. I don't know if it
is exactly what you need :

 <sort-order>
    <banner left-text-style="bannerleft" left-text="&amp;nbsp;Name"/>
    <field-group id="person" style="boxoutside">
        <sort-field name="mcMarketingCampaignId"/>
        <sort-field name="mcCampaignName"/>
        <sort-field name="mcCampaignSummary"/>
        <sort-field name="ptyPartyId"/>
        <sort-field name="perMemberId"/>
     </field-group>
 </sort-order>


Regards,
Alex
On 6/21/06, Jacques Le Roux <[hidden email]> wrote:

>
>
> Is there something in the widget that act as a panel, frame or lign to
> separate or group fields or is FTL needed for that ?
>
> Jacques
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>
>


------------------------------

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

End of Users Digest, Vol 23, Issue 68
*************************************

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users