Users - Help needed for group by condition ...
Locked
 
|
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 |
|
|
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 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="&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 |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |