You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Pierre Smits <pi...@gmail.com> on 2010/08/20 12:31:22 UTC
Groovy question regarding passing html parameters
In a url I pass following parameters:
?profile=10000&experience=10000,100010
In a groovy file I get the parameters....
parameter.profile
parameter.experience
My question is: how do I get the delegator to find entities in the database
based on both parameter.profile and parameter.experience?
In all the other codes in groovy files that I see it seems that parameters
have only 1 value... Or I might be overlooking one...
Regards,,
Pierre
Re: Groovy question regarding passing html parameters
Posted by Jacques Le Roux <ja...@les7arts.com>.
Yes, I saw also something like that when looking at it, for instance different values for radio buttons...
Jacques
From: "Scott Gray" <sc...@hotwaxmedia.com>
Hi Pierre,
I believe the correct way to send multiple values for the same key as part of a query string is like this:
?profileSummaryId=10091&experienceSelected=10003&experienceSelected=10020
That should result in parameters.experienceSelected being a list containing the two values and would avoid you have to split the
string yourself.
Regards
Scott
On 24/08/2010, at 12:47 AM, Pierre Smits wrote:
> Hi Scott,
>
> I think I've got it solved.
> First I use:
> String delims = "[,]";
> String[] experienceTokens = selectedExperiences.split(delims);
>
> to split the query_string to a list. And subsequently I use
> condList.add(EntityCondition.makeCondition("experienceId",EntityOperator.IN, experienceTokens as List));
>
> to add the items in the query string as conditions.
>
> This renders:
> cond = (profileOwnerId= '10010, experienceId IN('10010','10003'))
>
> And finally I get my pdf with both experiences.
>
> And if I don't send any experienceId's in the query string I get all experiences associated with profileOwnerId (which is what I
> want).:)
>
> Thanks for your patience and help.
>
> Regards,
>
> Pierre
>
> 2010/8/23 Pierre Smits <pi...@gmail.com>
> When removing 'as list' from the groovy code, I get following error:
>
> Problems with the response writer/output stream: org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]: java.lang.ClassCastException: java.lang.String cannot be
> cast to java.util.Collection (java.lang.String cannot be cast to java.util.Collection)
>
> In my input form (a combination of two) I indeed use a checkbox solution to select the experiences: These checkboxes have the
> same input name. I then use some javascript code to generate the url and open a new window which has the query_string:
> ?profileSummaryId=10091&experienceSelected=10003,10020
>
>
>
>
> 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> Try removing the "as List" in the entity condition (I checked and an array parameter value is automatically converted to a list of
> values). If that doesn't work, what do the form inputs for experienceId look like? You should have multiple input fields
> (checkboxes I guess) sharing the same experienceId input name.
>
> Regards
> Scott
>
> On 23/08/2010, at 10:07 PM, Pierre Smits wrote:
>
> > I have added some print statements to the code to see what is generated, and I see following in my ofbiz console:
> >
> > selectedExperiences are 10003, 10020
> > condList = [profileOwnerId = '10010', experienceId IN ('1', '0', '0', '0', '3',
> > ',', ' ', '1', '0', '0', '2', '0')]
> > cond = (profileOwnerId = '10010' AND experienceId IN ('1', '0', '0', '0', '3', '
> > ,', ' ', '1', '0', '0', '2', '0'))
> >
> > It seems that the values of the second part of the query_string (&experienceSelected=10003, 10020) parsed in individual
> > characters in
> > EntityCondition.makeCondition("experienceId", EntityOperator.IN, selectedExperiences as List)
> >
> >
> >
> > 2010/8/23 Pierre Smits <pi...@gmail.com>
> > You are absolutely right. Slightly the same is a huge difference...
> >
> >
> > Regards,
> >
> > Pierre
> >
> > 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> > The same or slightly different? You also need to do the same for the EntityOperator class and any others that are being used by
> > your script.
> >
> > Regards
> > Scott
> >
> > On 23/08/2010, at 8:47 PM, Pierre Smits wrote:
> >
> > > Hi Scott,
> > >
> > > I added the import. Unfortunately, the result is the same error.
> > >
> > > Regards,
> > >
> > > Pierre
> > >
> > >
> > > 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> > > Hi Pierre,
> > >
> > > You need to add the EntityCondition class to the list of imports:
> > > import org.ofbiz.entity.condition.EntityCondition;
> > >
> > > Regards
> > > Scott
> > >
> > > HotWax Media
> > > http://www.hotwaxmedia.com
> > >
> > > On 23/08/2010, at 7:49 PM, Pierre Smits wrote:
> > >
> > > > The error more readable:
> > > >
> > > > Problems with the response writer/output stream:
> > > > org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> > > > [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> > > > groovy.lang.MissingPropertyException: No such property: EntityCondition for
> > > > class: ProfileExperiences (No such property: EntityCondition for class:
> > > > ProfileExperiences)
> > > >
> > > > Regards,
> > > >
> > > > Pierre
> > > >
> > > > 2010/8/23 Pierre Smits <pi...@gmail.com>
> > > >
> > > >> Hi Scott,
> > > >>
> > > >> Thanks for the pointer. I think it should be on the money.... However after
> > > >> some tweaking I got following error:
> > > >>
> > > >> <p>Problems with the response writer/output stream:
> > > >>
> > > >> org.ofbiz.widget.screen.ScreenRenderException:
> > > >> Error rendering screen
> > > >> [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> > > >>
> > > >> groovy.lang.MissingPropertyException: No such property:
> > > >> EntityCondition for class: ProfileExperiences (No such property: EntityCondition for class:
> > > >> ProfileExperiences)
> > > >>
> > > >> </p>
> > > >>
> > > >>
> > > >> The complete code in the groovy file is:
> > > >> import org.ofbiz.base.util.*;
> > > >> import org.ofbiz.entity.*;
> > > >> import org.ofbiz.entity.util.*;
> > > >> import org.ofbiz.party.contact.*;
> > > >> import javolution.util.FastMap;
> > > >>
> > > >> List experienceItems = [];
> > > >>
> > > >> profileOwnerId = profileSummary.profileOwnerId;
> > > >> selectedExperiences = parameters.experienceSelected;
> > > >>
> > > >>
> > > >> condList = [];
> > > >> condList.add(EntityCondition.makeCondition("profileOwnerId",
> > > >> profileOwnerId));
> > > >> if (selectedExperiences) {
> > > >> condList.add(EntityCondition.makeCondition("experienceId",
> > > >> EntityOperator.IN, selectedExperiences as List));
> > > >> }
> > > >> cond = EntityCondition.makeCondition(condList);
> > > >> experienceItemList = delegator.findList("ProfileExperience", cond, null,
> > > >> null, null, false);
> > > >>
> > > >> if (experienceItemList) {
> > > >> experienceItemList.each { profileExperience ->
> > > >> experienceDesc = profileExperience.experienceDesc;
> > > >> experienceStartDate = profileExperience.experienceStartDate;
> > > >> experienceEndDate = profileExperience.experienceEndDate;
> > > >> experienceCustomerId = profileExperience.experienceCustomerId;
> > > >> experienceIndustryId = profileExperience.experienceIndustryId;
> > > >> experienceProjectId = profileExperience.experienceProjectId;
> > > >> experienceTaskId = profileExperience.experienceTaskId;
> > > >> experienceBackground = profileExperience.experienceBackground;
> > > >> experienceContext = profileExperience.experienceContext;
> > > >> experienceTask = profileExperience.experienceTask;
> > > >> experienceMethods = profileExperience.experienceMethods;
> > > >> experienceTools = profileExperience.experienceTools;
> > > >>
> > > >> Map experienceItemMap = FastMap.newInstance();
> > > >> experienceItemMap.putAll((Map) profileExperience);
> > > >>
> > > >> experienceItems.add(experienceItemMap);
> > > >> }
> > > >> context.experienceItems = experienceItems;
> > > >> }
> > > >>
> > > >> Any suggestions?
> > > >>
> > > >> Regards,
> > > >>
> > > >> Pierre
> > > >>
> > > >>
> > > >> 2010/8/21 Scott Gray <sc...@hotwaxmedia.com>
> > > >>
> > > >> Hi Pierre,
> > > >>>
> > > >>> See my other response to Michal for the correct code, it was only from
> > > >>> memory though so may not actually work without tweaking.
> > > >>>
> > > >>> Regards
> > > >>> Scott
> > > >>>
> > > >>> On 21/08/2010, at 12:02 AM, Pierre Smits wrote:
> > > >>>
> > > >>>> Hi Scott,
> > > >>>>
> > > >>>> Thanks for the pointer!
> > > >>>>
> > > >>>> Unfortunately, I am a total groovy-newbie....
> > > >>>>
> > > >>>> Would
> > > >>>> selectedExperiences = parameter.selectedExperiences;
> > > >>>> if (selectedExperiences==""){
> > > >>>> experienceItemList = delegator.findByAnd("ProfileExperience",
> > > >>>> [profileOwnerId : profileOwnerId]);
> > > >>>> }
> > > >>>> else{
> > > >>>> experienceItemList = delegator.findList("ProfileExperience",
> > > >>>> [experienceId : selectedExperiences]);
> > > >>>>
> > > >>>> }
> > > >>>>
> > > >>>> do the trick?
> > > >>>>
> > > >>>> Regards,
> > > >>>>
> > > >>>> Pierre
> > > >>>>
> > > >>>>
> > > >>>> 2010/8/20 Scott Gray <sc...@hotwaxmedia.com>
> > > >>>>
> > > >>>>> Hi Pierre,
> > > >>>>>
> > > >>>>> You'll want to use delegator.findList(...) with an EntityOperator.IN
> > > >>>>> condition for the experience field.
> > > >>>>>
> > > >>>>> Regards
> > > >>>>> Scott
> > > >>>>>
> > > >>>>> HotWax Media
> > > >>>>> http://www.hotwaxmedia.com
> > > >>>>>
> > > >>>>> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
> > > >>>>>
> > > >>>>>> In a url I pass following parameters:
> > > >>>>>>
> > > >>>>>> ?profile=10000&experience=10000,100010
> > > >>>>>>
> > > >>>>>> In a groovy file I get the parameters....
> > > >>>>>> parameter.profile
> > > >>>>>> parameter.experience
> > > >>>>>>
> > > >>>>>> My question is: how do I get the delegator to find entities in the
> > > >>>>> database
> > > >>>>>> based on both parameter.profile and parameter.experience?
> > > >>>>>>
> > > >>>>>> In all the other codes in groovy files that I see it seems that
> > > >>>>> parameters
> > > >>>>>> have only 1 value... Or I might be overlooking one...
> > > >>>>>>
> > > >>>>>> Regards,,
> > > >>>>>>
> > > >>>>>> Pierre
> > > >>>>>
> > > >>>>>
> > > >>>
> > > >>>
> > > >>
> > >
> > >
> >
> >
> >
>
>
>
Re: Groovy question regarding passing html parameters
Posted by Scott Gray <sc...@hotwaxmedia.com>.
That's why forms and ajax typically use "post" instead of instead of "get" :-)
Regards
Scott
On 25/08/2010, at 5:54 PM, Pierre Smits wrote:
> Hi Scott,
>
> This solution would probably lead to running out of space in the query_string, as there are still some limits regarding the length.
>
> But thanks for the support and heads up.
>
> Regards,
>
> Pierre
>
> 2010/8/24 Scott Gray <sc...@hotwaxmedia.com>
> Hi Pierre,
>
> I believe the correct way to send multiple values for the same key as part of a query string is like this:
> ?profileSummaryId=10091&experienceSelected=10003&experienceSelected=10020
> That should result in parameters.experienceSelected being a list containing the two values and would avoid you have to split the string yourself.
>
> Regards
> Scott
>
> On 24/08/2010, at 12:47 AM, Pierre Smits wrote:
>
> > Hi Scott,
> >
> > I think I've got it solved.
> > First I use:
> > String delims = "[,]";
> > String[] experienceTokens = selectedExperiences.split(delims);
> >
> > to split the query_string to a list. And subsequently I use
> > condList.add(EntityCondition.makeCondition("experienceId",EntityOperator.IN, experienceTokens as List));
> >
> > to add the items in the query string as conditions.
> >
> > This renders:
> > cond = (profileOwnerId= '10010, experienceId IN('10010','10003'))
> >
> > And finally I get my pdf with both experiences.
> >
> > And if I don't send any experienceId's in the query string I get all experiences associated with profileOwnerId (which is what I want).:)
> >
> > Thanks for your patience and help.
> >
> > Regards,
> >
> > Pierre
> >
> > 2010/8/23 Pierre Smits <pi...@gmail.com>
> > When removing 'as list' from the groovy code, I get following error:
> >
> > Problems with the response writer/output stream: org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]: java.lang.ClassCastException: java.lang.String cannot be cast to java.util.Collection (java.lang.String cannot be cast to java.util.Collection)
> >
> > In my input form (a combination of two) I indeed use a checkbox solution to select the experiences: These checkboxes have the same input name. I then use some javascript code to generate the url and open a new window which has the query_string: ?profileSummaryId=10091&experienceSelected=10003,10020
> >
> >
> >
> >
> > 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> > Try removing the "as List" in the entity condition (I checked and an array parameter value is automatically converted to a list of values). If that doesn't work, what do the form inputs for experienceId look like? You should have multiple input fields (checkboxes I guess) sharing the same experienceId input name.
> >
> > Regards
> > Scott
> >
> > On 23/08/2010, at 10:07 PM, Pierre Smits wrote:
> >
> > > I have added some print statements to the code to see what is generated, and I see following in my ofbiz console:
> > >
> > > selectedExperiences are 10003, 10020
> > > condList = [profileOwnerId = '10010', experienceId IN ('1', '0', '0', '0', '3',
> > > ',', ' ', '1', '0', '0', '2', '0')]
> > > cond = (profileOwnerId = '10010' AND experienceId IN ('1', '0', '0', '0', '3', '
> > > ,', ' ', '1', '0', '0', '2', '0'))
> > >
> > > It seems that the values of the second part of the query_string (&experienceSelected=10003, 10020) parsed in individual characters in
> > > EntityCondition.makeCondition("experienceId", EntityOperator.IN, selectedExperiences as List)
> > >
> > >
> > >
> > > 2010/8/23 Pierre Smits <pi...@gmail.com>
> > > You are absolutely right. Slightly the same is a huge difference...
> > >
> > >
> > > Regards,
> > >
> > > Pierre
> > >
> > > 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> > > The same or slightly different? You also need to do the same for the EntityOperator class and any others that are being used by your script.
> > >
> > > Regards
> > > Scott
> > >
> > > On 23/08/2010, at 8:47 PM, Pierre Smits wrote:
> > >
> > > > Hi Scott,
> > > >
> > > > I added the import. Unfortunately, the result is the same error.
> > > >
> > > > Regards,
> > > >
> > > > Pierre
> > > >
> > > >
> > > > 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> > > > Hi Pierre,
> > > >
> > > > You need to add the EntityCondition class to the list of imports:
> > > > import org.ofbiz.entity.condition.EntityCondition;
> > > >
> > > > Regards
> > > > Scott
> > > >
> > > > HotWax Media
> > > > http://www.hotwaxmedia.com
> > > >
> > > > On 23/08/2010, at 7:49 PM, Pierre Smits wrote:
> > > >
> > > > > The error more readable:
> > > > >
> > > > > Problems with the response writer/output stream:
> > > > > org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> > > > > [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> > > > > groovy.lang.MissingPropertyException: No such property: EntityCondition for
> > > > > class: ProfileExperiences (No such property: EntityCondition for class:
> > > > > ProfileExperiences)
> > > > >
> > > > > Regards,
> > > > >
> > > > > Pierre
> > > > >
> > > > > 2010/8/23 Pierre Smits <pi...@gmail.com>
> > > > >
> > > > >> Hi Scott,
> > > > >>
> > > > >> Thanks for the pointer. I think it should be on the money.... However after
> > > > >> some tweaking I got following error:
> > > > >>
> > > > >> <p>Problems with the response writer/output stream:
> > > > >>
> > > > >> org.ofbiz.widget.screen.ScreenRenderException:
> > > > >> Error rendering screen [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> > > > >>
> > > > >> groovy.lang.MissingPropertyException: No such property:
> > > > >> EntityCondition for class: ProfileExperiences (No such property: EntityCondition for class: ProfileExperiences)
> > > > >>
> > > > >> </p>
> > > > >>
> > > > >>
> > > > >> The complete code in the groovy file is:
> > > > >> import org.ofbiz.base.util.*;
> > > > >> import org.ofbiz.entity.*;
> > > > >> import org.ofbiz.entity.util.*;
> > > > >> import org.ofbiz.party.contact.*;
> > > > >> import javolution.util.FastMap;
> > > > >>
> > > > >> List experienceItems = [];
> > > > >>
> > > > >> profileOwnerId = profileSummary.profileOwnerId;
> > > > >> selectedExperiences = parameters.experienceSelected;
> > > > >>
> > > > >>
> > > > >> condList = [];
> > > > >> condList.add(EntityCondition.makeCondition("profileOwnerId",
> > > > >> profileOwnerId));
> > > > >> if (selectedExperiences) {
> > > > >> condList.add(EntityCondition.makeCondition("experienceId",
> > > > >> EntityOperator.IN, selectedExperiences as List));
> > > > >> }
> > > > >> cond = EntityCondition.makeCondition(condList);
> > > > >> experienceItemList = delegator.findList("ProfileExperience", cond, null,
> > > > >> null, null, false);
> > > > >>
> > > > >> if (experienceItemList) {
> > > > >> experienceItemList.each { profileExperience ->
> > > > >> experienceDesc = profileExperience.experienceDesc;
> > > > >> experienceStartDate = profileExperience.experienceStartDate;
> > > > >> experienceEndDate = profileExperience.experienceEndDate;
> > > > >> experienceCustomerId = profileExperience.experienceCustomerId;
> > > > >> experienceIndustryId = profileExperience.experienceIndustryId;
> > > > >> experienceProjectId = profileExperience.experienceProjectId;
> > > > >> experienceTaskId = profileExperience.experienceTaskId;
> > > > >> experienceBackground = profileExperience.experienceBackground;
> > > > >> experienceContext = profileExperience.experienceContext;
> > > > >> experienceTask = profileExperience.experienceTask;
> > > > >> experienceMethods = profileExperience.experienceMethods;
> > > > >> experienceTools = profileExperience.experienceTools;
> > > > >>
> > > > >> Map experienceItemMap = FastMap.newInstance();
> > > > >> experienceItemMap.putAll((Map) profileExperience);
> > > > >>
> > > > >> experienceItems.add(experienceItemMap);
> > > > >> }
> > > > >> context.experienceItems = experienceItems;
> > > > >> }
> > > > >>
> > > > >> Any suggestions?
> > > > >>
> > > > >> Regards,
> > > > >>
> > > > >> Pierre
> > > > >>
> > > > >>
> > > > >> 2010/8/21 Scott Gray <sc...@hotwaxmedia.com>
> > > > >>
> > > > >> Hi Pierre,
> > > > >>>
> > > > >>> See my other response to Michal for the correct code, it was only from
> > > > >>> memory though so may not actually work without tweaking.
> > > > >>>
> > > > >>> Regards
> > > > >>> Scott
> > > > >>>
> > > > >>> On 21/08/2010, at 12:02 AM, Pierre Smits wrote:
> > > > >>>
> > > > >>>> Hi Scott,
> > > > >>>>
> > > > >>>> Thanks for the pointer!
> > > > >>>>
> > > > >>>> Unfortunately, I am a total groovy-newbie....
> > > > >>>>
> > > > >>>> Would
> > > > >>>> selectedExperiences = parameter.selectedExperiences;
> > > > >>>> if (selectedExperiences==""){
> > > > >>>> experienceItemList = delegator.findByAnd("ProfileExperience",
> > > > >>>> [profileOwnerId : profileOwnerId]);
> > > > >>>> }
> > > > >>>> else{
> > > > >>>> experienceItemList = delegator.findList("ProfileExperience",
> > > > >>>> [experienceId : selectedExperiences]);
> > > > >>>>
> > > > >>>> }
> > > > >>>>
> > > > >>>> do the trick?
> > > > >>>>
> > > > >>>> Regards,
> > > > >>>>
> > > > >>>> Pierre
> > > > >>>>
> > > > >>>>
> > > > >>>> 2010/8/20 Scott Gray <sc...@hotwaxmedia.com>
> > > > >>>>
> > > > >>>>> Hi Pierre,
> > > > >>>>>
> > > > >>>>> You'll want to use delegator.findList(...) with an EntityOperator.IN
> > > > >>>>> condition for the experience field.
> > > > >>>>>
> > > > >>>>> Regards
> > > > >>>>> Scott
> > > > >>>>>
> > > > >>>>> HotWax Media
> > > > >>>>> http://www.hotwaxmedia.com
> > > > >>>>>
> > > > >>>>> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
> > > > >>>>>
> > > > >>>>>> In a url I pass following parameters:
> > > > >>>>>>
> > > > >>>>>> ?profile=10000&experience=10000,100010
> > > > >>>>>>
> > > > >>>>>> In a groovy file I get the parameters....
> > > > >>>>>> parameter.profile
> > > > >>>>>> parameter.experience
> > > > >>>>>>
> > > > >>>>>> My question is: how do I get the delegator to find entities in the
> > > > >>>>> database
> > > > >>>>>> based on both parameter.profile and parameter.experience?
> > > > >>>>>>
> > > > >>>>>> In all the other codes in groovy files that I see it seems that
> > > > >>>>> parameters
> > > > >>>>>> have only 1 value... Or I might be overlooking one...
> > > > >>>>>>
> > > > >>>>>> Regards,,
> > > > >>>>>>
> > > > >>>>>> Pierre
> > > > >>>>>
> > > > >>>>>
> > > > >>>
> > > > >>>
> > > > >>
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>
Re: Groovy question regarding passing html parameters
Posted by Pierre Smits <pi...@gmail.com>.
Hi Scott,
This solution would probably lead to running out of space in the
query_string, as there are still some limits regarding the length.
But thanks for the support and heads up.
Regards,
Pierre
2010/8/24 Scott Gray <sc...@hotwaxmedia.com>
> Hi Pierre,
>
> I believe the correct way to send multiple values for the same key as part
> of a query string is like this:
> ?profileSummaryId=10091&experienceSelected=10003&experienceSelected=10020
> That should result in parameters.experienceSelected being a list containing
> the two values and would avoid you have to split the string yourself.
>
> Regards
> Scott
>
> On 24/08/2010, at 12:47 AM, Pierre Smits wrote:
>
> > Hi Scott,
> >
> > I think I've got it solved.
> > First I use:
> > String delims = "[,]";
> > String[] experienceTokens = selectedExperiences.split(delims);
> >
> > to split the query_string to a list. And subsequently I use
> >
> condList.add(EntityCondition.makeCondition("experienceId",EntityOperator.IN,
> experienceTokens as List));
> >
> > to add the items in the query string as conditions.
> >
> > This renders:
> > cond = (profileOwnerId= '10010, experienceId IN('10010','10003'))
> >
> > And finally I get my pdf with both experiences.
> >
> > And if I don't send any experienceId's in the query string I get all
> experiences associated with profileOwnerId (which is what I want).:)
> >
> > Thanks for your patience and help.
> >
> > Regards,
> >
> > Pierre
> >
> > 2010/8/23 Pierre Smits <pi...@gmail.com>
> > When removing 'as list' from the groovy code, I get following error:
> >
> > Problems with the response writer/output stream:
> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> java.lang.ClassCastException: java.lang.String cannot be cast to
> java.util.Collection (java.lang.String cannot be cast to
> java.util.Collection)
> >
> > In my input form (a combination of two) I indeed use a checkbox solution
> to select the experiences: These checkboxes have the same input name. I
> then use some javascript code to generate the url and open a new window
> which has the query_string:
> ?profileSummaryId=10091&experienceSelected=10003,10020
> >
> >
> >
> >
> > 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> > Try removing the "as List" in the entity condition (I checked and an
> array parameter value is automatically converted to a list of values). If
> that doesn't work, what do the form inputs for experienceId look like? You
> should have multiple input fields (checkboxes I guess) sharing the same
> experienceId input name.
> >
> > Regards
> > Scott
> >
> > On 23/08/2010, at 10:07 PM, Pierre Smits wrote:
> >
> > > I have added some print statements to the code to see what is
> generated, and I see following in my ofbiz console:
> > >
> > > selectedExperiences are 10003, 10020
> > > condList = [profileOwnerId = '10010', experienceId IN ('1', '0', '0',
> '0', '3',
> > > ',', ' ', '1', '0', '0', '2', '0')]
> > > cond = (profileOwnerId = '10010' AND experienceId IN ('1', '0', '0',
> '0', '3', '
> > > ,', ' ', '1', '0', '0', '2', '0'))
> > >
> > > It seems that the values of the second part of the query_string
> (&experienceSelected=10003, 10020) parsed in individual characters in
> > > EntityCondition.makeCondition("experienceId", EntityOperator.IN,
> selectedExperiences as List)
> > >
> > >
> > >
> > > 2010/8/23 Pierre Smits <pi...@gmail.com>
> > > You are absolutely right. Slightly the same is a huge difference...
> > >
> > >
> > > Regards,
> > >
> > > Pierre
> > >
> > > 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> > > The same or slightly different? You also need to do the same for the
> EntityOperator class and any others that are being used by your script.
> > >
> > > Regards
> > > Scott
> > >
> > > On 23/08/2010, at 8:47 PM, Pierre Smits wrote:
> > >
> > > > Hi Scott,
> > > >
> > > > I added the import. Unfortunately, the result is the same error.
> > > >
> > > > Regards,
> > > >
> > > > Pierre
> > > >
> > > >
> > > > 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> > > > Hi Pierre,
> > > >
> > > > You need to add the EntityCondition class to the list of imports:
> > > > import org.ofbiz.entity.condition.EntityCondition;
> > > >
> > > > Regards
> > > > Scott
> > > >
> > > > HotWax Media
> > > > http://www.hotwaxmedia.com
> > > >
> > > > On 23/08/2010, at 7:49 PM, Pierre Smits wrote:
> > > >
> > > > > The error more readable:
> > > > >
> > > > > Problems with the response writer/output stream:
> > > > > org.ofbiz.widget.screen.ScreenRenderException: Error rendering
> screen
> > > > >
> [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> > > > > groovy.lang.MissingPropertyException: No such property:
> EntityCondition for
> > > > > class: ProfileExperiences (No such property: EntityCondition for
> class:
> > > > > ProfileExperiences)
> > > > >
> > > > > Regards,
> > > > >
> > > > > Pierre
> > > > >
> > > > > 2010/8/23 Pierre Smits <pi...@gmail.com>
> > > > >
> > > > >> Hi Scott,
> > > > >>
> > > > >> Thanks for the pointer. I think it should be on the money....
> However after
> > > > >> some tweaking I got following error:
> > > > >>
> > > > >> <p>Problems with the response writer/output stream:
> > > > >>
> > > > >> org.ofbiz.widget.screen.ScreenRenderException:
> > > > >> Error rendering screen
> [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> > > > >>
> > > > >> groovy.lang.MissingPropertyException: No such property:
> > > > >> EntityCondition for class: ProfileExperiences (No such
> property: EntityCondition for class: ProfileExperiences)
> > > > >>
> > > > >> </p>
> > > > >>
> > > > >>
> > > > >> The complete code in the groovy file is:
> > > > >> import org.ofbiz.base.util.*;
> > > > >> import org.ofbiz.entity.*;
> > > > >> import org.ofbiz.entity.util.*;
> > > > >> import org.ofbiz.party.contact.*;
> > > > >> import javolution.util.FastMap;
> > > > >>
> > > > >> List experienceItems = [];
> > > > >>
> > > > >> profileOwnerId = profileSummary.profileOwnerId;
> > > > >> selectedExperiences = parameters.experienceSelected;
> > > > >>
> > > > >>
> > > > >> condList = [];
> > > > >> condList.add(EntityCondition.makeCondition("profileOwnerId",
> > > > >> profileOwnerId));
> > > > >> if (selectedExperiences) {
> > > > >> condList.add(EntityCondition.makeCondition("experienceId",
> > > > >> EntityOperator.IN, selectedExperiences as List));
> > > > >> }
> > > > >> cond = EntityCondition.makeCondition(condList);
> > > > >> experienceItemList = delegator.findList("ProfileExperience", cond,
> null,
> > > > >> null, null, false);
> > > > >>
> > > > >> if (experienceItemList) {
> > > > >> experienceItemList.each { profileExperience ->
> > > > >> experienceDesc = profileExperience.experienceDesc;
> > > > >> experienceStartDate =
> profileExperience.experienceStartDate;
> > > > >> experienceEndDate = profileExperience.experienceEndDate;
> > > > >> experienceCustomerId =
> profileExperience.experienceCustomerId;
> > > > >> experienceIndustryId =
> profileExperience.experienceIndustryId;
> > > > >> experienceProjectId =
> profileExperience.experienceProjectId;
> > > > >> experienceTaskId = profileExperience.experienceTaskId;
> > > > >> experienceBackground =
> profileExperience.experienceBackground;
> > > > >> experienceContext = profileExperience.experienceContext;
> > > > >> experienceTask = profileExperience.experienceTask;
> > > > >> experienceMethods = profileExperience.experienceMethods;
> > > > >> experienceTools = profileExperience.experienceTools;
> > > > >>
> > > > >> Map experienceItemMap = FastMap.newInstance();
> > > > >> experienceItemMap.putAll((Map) profileExperience);
> > > > >>
> > > > >> experienceItems.add(experienceItemMap);
> > > > >> }
> > > > >> context.experienceItems = experienceItems;
> > > > >> }
> > > > >>
> > > > >> Any suggestions?
> > > > >>
> > > > >> Regards,
> > > > >>
> > > > >> Pierre
> > > > >>
> > > > >>
> > > > >> 2010/8/21 Scott Gray <sc...@hotwaxmedia.com>
> > > > >>
> > > > >> Hi Pierre,
> > > > >>>
> > > > >>> See my other response to Michal for the correct code, it was only
> from
> > > > >>> memory though so may not actually work without tweaking.
> > > > >>>
> > > > >>> Regards
> > > > >>> Scott
> > > > >>>
> > > > >>> On 21/08/2010, at 12:02 AM, Pierre Smits wrote:
> > > > >>>
> > > > >>>> Hi Scott,
> > > > >>>>
> > > > >>>> Thanks for the pointer!
> > > > >>>>
> > > > >>>> Unfortunately, I am a total groovy-newbie....
> > > > >>>>
> > > > >>>> Would
> > > > >>>> selectedExperiences = parameter.selectedExperiences;
> > > > >>>> if (selectedExperiences==""){
> > > > >>>> experienceItemList = delegator.findByAnd("ProfileExperience",
> > > > >>>> [profileOwnerId : profileOwnerId]);
> > > > >>>> }
> > > > >>>> else{
> > > > >>>> experienceItemList = delegator.findList("ProfileExperience",
> > > > >>>> [experienceId : selectedExperiences]);
> > > > >>>>
> > > > >>>> }
> > > > >>>>
> > > > >>>> do the trick?
> > > > >>>>
> > > > >>>> Regards,
> > > > >>>>
> > > > >>>> Pierre
> > > > >>>>
> > > > >>>>
> > > > >>>> 2010/8/20 Scott Gray <sc...@hotwaxmedia.com>
> > > > >>>>
> > > > >>>>> Hi Pierre,
> > > > >>>>>
> > > > >>>>> You'll want to use delegator.findList(...) with an
> EntityOperator.IN
> > > > >>>>> condition for the experience field.
> > > > >>>>>
> > > > >>>>> Regards
> > > > >>>>> Scott
> > > > >>>>>
> > > > >>>>> HotWax Media
> > > > >>>>> http://www.hotwaxmedia.com
> > > > >>>>>
> > > > >>>>> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
> > > > >>>>>
> > > > >>>>>> In a url I pass following parameters:
> > > > >>>>>>
> > > > >>>>>> ?profile=10000&experience=10000,100010
> > > > >>>>>>
> > > > >>>>>> In a groovy file I get the parameters....
> > > > >>>>>> parameter.profile
> > > > >>>>>> parameter.experience
> > > > >>>>>>
> > > > >>>>>> My question is: how do I get the delegator to find entities in
> the
> > > > >>>>> database
> > > > >>>>>> based on both parameter.profile and parameter.experience?
> > > > >>>>>>
> > > > >>>>>> In all the other codes in groovy files that I see it seems
> that
> > > > >>>>> parameters
> > > > >>>>>> have only 1 value... Or I might be overlooking one...
> > > > >>>>>>
> > > > >>>>>> Regards,,
> > > > >>>>>>
> > > > >>>>>> Pierre
> > > > >>>>>
> > > > >>>>>
> > > > >>>
> > > > >>>
> > > > >>
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>
Re: Groovy question regarding passing html parameters
Posted by Scott Gray <sc...@hotwaxmedia.com>.
Hi Pierre,
I believe the correct way to send multiple values for the same key as part of a query string is like this:
?profileSummaryId=10091&experienceSelected=10003&experienceSelected=10020
That should result in parameters.experienceSelected being a list containing the two values and would avoid you have to split the string yourself.
Regards
Scott
On 24/08/2010, at 12:47 AM, Pierre Smits wrote:
> Hi Scott,
>
> I think I've got it solved.
> First I use:
> String delims = "[,]";
> String[] experienceTokens = selectedExperiences.split(delims);
>
> to split the query_string to a list. And subsequently I use
> condList.add(EntityCondition.makeCondition("experienceId",EntityOperator.IN, experienceTokens as List));
>
> to add the items in the query string as conditions.
>
> This renders:
> cond = (profileOwnerId= '10010, experienceId IN('10010','10003'))
>
> And finally I get my pdf with both experiences.
>
> And if I don't send any experienceId's in the query string I get all experiences associated with profileOwnerId (which is what I want).:)
>
> Thanks for your patience and help.
>
> Regards,
>
> Pierre
>
> 2010/8/23 Pierre Smits <pi...@gmail.com>
> When removing 'as list' from the groovy code, I get following error:
>
> Problems with the response writer/output stream: org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]: java.lang.ClassCastException: java.lang.String cannot be cast to java.util.Collection (java.lang.String cannot be cast to java.util.Collection)
>
> In my input form (a combination of two) I indeed use a checkbox solution to select the experiences: These checkboxes have the same input name. I then use some javascript code to generate the url and open a new window which has the query_string: ?profileSummaryId=10091&experienceSelected=10003,10020
>
>
>
>
> 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> Try removing the "as List" in the entity condition (I checked and an array parameter value is automatically converted to a list of values). If that doesn't work, what do the form inputs for experienceId look like? You should have multiple input fields (checkboxes I guess) sharing the same experienceId input name.
>
> Regards
> Scott
>
> On 23/08/2010, at 10:07 PM, Pierre Smits wrote:
>
> > I have added some print statements to the code to see what is generated, and I see following in my ofbiz console:
> >
> > selectedExperiences are 10003, 10020
> > condList = [profileOwnerId = '10010', experienceId IN ('1', '0', '0', '0', '3',
> > ',', ' ', '1', '0', '0', '2', '0')]
> > cond = (profileOwnerId = '10010' AND experienceId IN ('1', '0', '0', '0', '3', '
> > ,', ' ', '1', '0', '0', '2', '0'))
> >
> > It seems that the values of the second part of the query_string (&experienceSelected=10003, 10020) parsed in individual characters in
> > EntityCondition.makeCondition("experienceId", EntityOperator.IN, selectedExperiences as List)
> >
> >
> >
> > 2010/8/23 Pierre Smits <pi...@gmail.com>
> > You are absolutely right. Slightly the same is a huge difference...
> >
> >
> > Regards,
> >
> > Pierre
> >
> > 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> > The same or slightly different? You also need to do the same for the EntityOperator class and any others that are being used by your script.
> >
> > Regards
> > Scott
> >
> > On 23/08/2010, at 8:47 PM, Pierre Smits wrote:
> >
> > > Hi Scott,
> > >
> > > I added the import. Unfortunately, the result is the same error.
> > >
> > > Regards,
> > >
> > > Pierre
> > >
> > >
> > > 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> > > Hi Pierre,
> > >
> > > You need to add the EntityCondition class to the list of imports:
> > > import org.ofbiz.entity.condition.EntityCondition;
> > >
> > > Regards
> > > Scott
> > >
> > > HotWax Media
> > > http://www.hotwaxmedia.com
> > >
> > > On 23/08/2010, at 7:49 PM, Pierre Smits wrote:
> > >
> > > > The error more readable:
> > > >
> > > > Problems with the response writer/output stream:
> > > > org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> > > > [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> > > > groovy.lang.MissingPropertyException: No such property: EntityCondition for
> > > > class: ProfileExperiences (No such property: EntityCondition for class:
> > > > ProfileExperiences)
> > > >
> > > > Regards,
> > > >
> > > > Pierre
> > > >
> > > > 2010/8/23 Pierre Smits <pi...@gmail.com>
> > > >
> > > >> Hi Scott,
> > > >>
> > > >> Thanks for the pointer. I think it should be on the money.... However after
> > > >> some tweaking I got following error:
> > > >>
> > > >> <p>Problems with the response writer/output stream:
> > > >>
> > > >> org.ofbiz.widget.screen.ScreenRenderException:
> > > >> Error rendering screen [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> > > >>
> > > >> groovy.lang.MissingPropertyException: No such property:
> > > >> EntityCondition for class: ProfileExperiences (No such property: EntityCondition for class: ProfileExperiences)
> > > >>
> > > >> </p>
> > > >>
> > > >>
> > > >> The complete code in the groovy file is:
> > > >> import org.ofbiz.base.util.*;
> > > >> import org.ofbiz.entity.*;
> > > >> import org.ofbiz.entity.util.*;
> > > >> import org.ofbiz.party.contact.*;
> > > >> import javolution.util.FastMap;
> > > >>
> > > >> List experienceItems = [];
> > > >>
> > > >> profileOwnerId = profileSummary.profileOwnerId;
> > > >> selectedExperiences = parameters.experienceSelected;
> > > >>
> > > >>
> > > >> condList = [];
> > > >> condList.add(EntityCondition.makeCondition("profileOwnerId",
> > > >> profileOwnerId));
> > > >> if (selectedExperiences) {
> > > >> condList.add(EntityCondition.makeCondition("experienceId",
> > > >> EntityOperator.IN, selectedExperiences as List));
> > > >> }
> > > >> cond = EntityCondition.makeCondition(condList);
> > > >> experienceItemList = delegator.findList("ProfileExperience", cond, null,
> > > >> null, null, false);
> > > >>
> > > >> if (experienceItemList) {
> > > >> experienceItemList.each { profileExperience ->
> > > >> experienceDesc = profileExperience.experienceDesc;
> > > >> experienceStartDate = profileExperience.experienceStartDate;
> > > >> experienceEndDate = profileExperience.experienceEndDate;
> > > >> experienceCustomerId = profileExperience.experienceCustomerId;
> > > >> experienceIndustryId = profileExperience.experienceIndustryId;
> > > >> experienceProjectId = profileExperience.experienceProjectId;
> > > >> experienceTaskId = profileExperience.experienceTaskId;
> > > >> experienceBackground = profileExperience.experienceBackground;
> > > >> experienceContext = profileExperience.experienceContext;
> > > >> experienceTask = profileExperience.experienceTask;
> > > >> experienceMethods = profileExperience.experienceMethods;
> > > >> experienceTools = profileExperience.experienceTools;
> > > >>
> > > >> Map experienceItemMap = FastMap.newInstance();
> > > >> experienceItemMap.putAll((Map) profileExperience);
> > > >>
> > > >> experienceItems.add(experienceItemMap);
> > > >> }
> > > >> context.experienceItems = experienceItems;
> > > >> }
> > > >>
> > > >> Any suggestions?
> > > >>
> > > >> Regards,
> > > >>
> > > >> Pierre
> > > >>
> > > >>
> > > >> 2010/8/21 Scott Gray <sc...@hotwaxmedia.com>
> > > >>
> > > >> Hi Pierre,
> > > >>>
> > > >>> See my other response to Michal for the correct code, it was only from
> > > >>> memory though so may not actually work without tweaking.
> > > >>>
> > > >>> Regards
> > > >>> Scott
> > > >>>
> > > >>> On 21/08/2010, at 12:02 AM, Pierre Smits wrote:
> > > >>>
> > > >>>> Hi Scott,
> > > >>>>
> > > >>>> Thanks for the pointer!
> > > >>>>
> > > >>>> Unfortunately, I am a total groovy-newbie....
> > > >>>>
> > > >>>> Would
> > > >>>> selectedExperiences = parameter.selectedExperiences;
> > > >>>> if (selectedExperiences==""){
> > > >>>> experienceItemList = delegator.findByAnd("ProfileExperience",
> > > >>>> [profileOwnerId : profileOwnerId]);
> > > >>>> }
> > > >>>> else{
> > > >>>> experienceItemList = delegator.findList("ProfileExperience",
> > > >>>> [experienceId : selectedExperiences]);
> > > >>>>
> > > >>>> }
> > > >>>>
> > > >>>> do the trick?
> > > >>>>
> > > >>>> Regards,
> > > >>>>
> > > >>>> Pierre
> > > >>>>
> > > >>>>
> > > >>>> 2010/8/20 Scott Gray <sc...@hotwaxmedia.com>
> > > >>>>
> > > >>>>> Hi Pierre,
> > > >>>>>
> > > >>>>> You'll want to use delegator.findList(...) with an EntityOperator.IN
> > > >>>>> condition for the experience field.
> > > >>>>>
> > > >>>>> Regards
> > > >>>>> Scott
> > > >>>>>
> > > >>>>> HotWax Media
> > > >>>>> http://www.hotwaxmedia.com
> > > >>>>>
> > > >>>>> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
> > > >>>>>
> > > >>>>>> In a url I pass following parameters:
> > > >>>>>>
> > > >>>>>> ?profile=10000&experience=10000,100010
> > > >>>>>>
> > > >>>>>> In a groovy file I get the parameters....
> > > >>>>>> parameter.profile
> > > >>>>>> parameter.experience
> > > >>>>>>
> > > >>>>>> My question is: how do I get the delegator to find entities in the
> > > >>>>> database
> > > >>>>>> based on both parameter.profile and parameter.experience?
> > > >>>>>>
> > > >>>>>> In all the other codes in groovy files that I see it seems that
> > > >>>>> parameters
> > > >>>>>> have only 1 value... Or I might be overlooking one...
> > > >>>>>>
> > > >>>>>> Regards,,
> > > >>>>>>
> > > >>>>>> Pierre
> > > >>>>>
> > > >>>>>
> > > >>>
> > > >>>
> > > >>
> > >
> > >
> >
> >
> >
>
>
>
Re: Groovy question regarding passing html parameters
Posted by Pierre Smits <pi...@gmail.com>.
Hi Scott,
I think I've got it solved.
First I use:
String delims = "[,]";
String[] experienceTokens = selectedExperiences.split(delims);
to split the query_string to a list. And subsequently I use
condList.add(EntityCondition.makeCondition("experienceId",EntityOperator.IN,
experienceTokens as List));
to add the items in the query string as conditions.
This renders:
cond = (profileOwnerId= '10010, experienceId IN('10010','10003'))
And finally I get my pdf with both experiences.
And if I don't send any experienceId's in the query string I get all
experiences associated with profileOwnerId (which is what I want).:)
Thanks for your patience and help.
Regards,
Pierre
2010/8/23 Pierre Smits <pi...@gmail.com>
> When removing 'as list' from the groovy code, I get following error:
>
> Problems with the response writer/output stream:
> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> java.lang.ClassCastException: java.lang.String cannot be cast to
> java.util.Collection (java.lang.String cannot be cast to
> java.util.Collection)
>
> In my input form (a combination of two) I indeed use a checkbox solution
> to select the experiences: These checkboxes have the same input name. I then
> use some javascript code to generate the url and open a new window which has
> the query_string: ?profileSummaryId=10091&experienceSelected=10003,10020
>
>
>
>
> 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
>
>> Try removing the "as List" in the entity condition (I checked and an array
>> parameter value is automatically converted to a list of values). If that
>> doesn't work, what do the form inputs for experienceId look like? You
>> should have multiple input fields (checkboxes I guess) sharing the same
>> experienceId input name.
>>
>> Regards
>> Scott
>>
>> On 23/08/2010, at 10:07 PM, Pierre Smits wrote:
>>
>> > I have added some print statements to the code to see what is generated,
>> and I see following in my ofbiz console:
>> >
>> > selectedExperiences are 10003, 10020
>> > condList = [profileOwnerId = '10010', experienceId IN ('1', '0', '0',
>> '0', '3',
>> > ',', ' ', '1', '0', '0', '2', '0')]
>> > cond = (profileOwnerId = '10010' AND experienceId IN ('1', '0', '0',
>> '0', '3', '
>> > ,', ' ', '1', '0', '0', '2', '0'))
>> >
>> > It seems that the values of the second part of the query_string
>> (&experienceSelected=10003, 10020) parsed in individual characters in
>> > EntityCondition.makeCondition("experienceId", EntityOperator.IN,
>> selectedExperiences as List)
>> >
>> >
>> >
>> > 2010/8/23 Pierre Smits <pi...@gmail.com>
>> > You are absolutely right. Slightly the same is a huge difference...
>> >
>> >
>> > Regards,
>> >
>> > Pierre
>> >
>> > 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
>> > The same or slightly different? You also need to do the same for the
>> EntityOperator class and any others that are being used by your script.
>> >
>> > Regards
>> > Scott
>> >
>> > On 23/08/2010, at 8:47 PM, Pierre Smits wrote:
>> >
>> > > Hi Scott,
>> > >
>> > > I added the import. Unfortunately, the result is the same error.
>> > >
>> > > Regards,
>> > >
>> > > Pierre
>> > >
>> > >
>> > > 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
>> > > Hi Pierre,
>> > >
>> > > You need to add the EntityCondition class to the list of imports:
>> > > import org.ofbiz.entity.condition.EntityCondition;
>> > >
>> > > Regards
>> > > Scott
>> > >
>> > > HotWax Media
>> > > http://www.hotwaxmedia.com
>> > >
>> > > On 23/08/2010, at 7:49 PM, Pierre Smits wrote:
>> > >
>> > > > The error more readable:
>> > > >
>> > > > Problems with the response writer/output stream:
>> > > > org.ofbiz.widget.screen.ScreenRenderException: Error rendering
>> screen
>> > > >
>> [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
>> > > > groovy.lang.MissingPropertyException: No such property:
>> EntityCondition for
>> > > > class: ProfileExperiences (No such property: EntityCondition for
>> class:
>> > > > ProfileExperiences)
>> > > >
>> > > > Regards,
>> > > >
>> > > > Pierre
>> > > >
>> > > > 2010/8/23 Pierre Smits <pi...@gmail.com>
>> > > >
>> > > >> Hi Scott,
>> > > >>
>> > > >> Thanks for the pointer. I think it should be on the money....
>> However after
>> > > >> some tweaking I got following error:
>> > > >>
>> > > >> <p>Problems with the response writer/output stream:
>> > > >>
>> > > >> org.ofbiz.widget.screen.ScreenRenderException:
>> > > >> Error rendering screen
>> [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
>> > > >>
>> > > >> groovy.lang.MissingPropertyException: No such property:
>> > > >> EntityCondition for class: ProfileExperiences (No such
>> property: EntityCondition for class: ProfileExperiences)
>> > > >>
>> > > >> </p>
>> > > >>
>> > > >>
>> > > >> The complete code in the groovy file is:
>> > > >> import org.ofbiz.base.util.*;
>> > > >> import org.ofbiz.entity.*;
>> > > >> import org.ofbiz.entity.util.*;
>> > > >> import org.ofbiz.party.contact.*;
>> > > >> import javolution.util.FastMap;
>> > > >>
>> > > >> List experienceItems = [];
>> > > >>
>> > > >> profileOwnerId = profileSummary.profileOwnerId;
>> > > >> selectedExperiences = parameters.experienceSelected;
>> > > >>
>> > > >>
>> > > >> condList = [];
>> > > >> condList.add(EntityCondition.makeCondition("profileOwnerId",
>> > > >> profileOwnerId));
>> > > >> if (selectedExperiences) {
>> > > >> condList.add(EntityCondition.makeCondition("experienceId",
>> > > >> EntityOperator.IN, selectedExperiences as List));
>> > > >> }
>> > > >> cond = EntityCondition.makeCondition(condList);
>> > > >> experienceItemList = delegator.findList("ProfileExperience", cond,
>> null,
>> > > >> null, null, false);
>> > > >>
>> > > >> if (experienceItemList) {
>> > > >> experienceItemList.each { profileExperience ->
>> > > >> experienceDesc = profileExperience.experienceDesc;
>> > > >> experienceStartDate = profileExperience.experienceStartDate;
>> > > >> experienceEndDate = profileExperience.experienceEndDate;
>> > > >> experienceCustomerId =
>> profileExperience.experienceCustomerId;
>> > > >> experienceIndustryId =
>> profileExperience.experienceIndustryId;
>> > > >> experienceProjectId = profileExperience.experienceProjectId;
>> > > >> experienceTaskId = profileExperience.experienceTaskId;
>> > > >> experienceBackground =
>> profileExperience.experienceBackground;
>> > > >> experienceContext = profileExperience.experienceContext;
>> > > >> experienceTask = profileExperience.experienceTask;
>> > > >> experienceMethods = profileExperience.experienceMethods;
>> > > >> experienceTools = profileExperience.experienceTools;
>> > > >>
>> > > >> Map experienceItemMap = FastMap.newInstance();
>> > > >> experienceItemMap.putAll((Map) profileExperience);
>> > > >>
>> > > >> experienceItems.add(experienceItemMap);
>> > > >> }
>> > > >> context.experienceItems = experienceItems;
>> > > >> }
>> > > >>
>> > > >> Any suggestions?
>> > > >>
>> > > >> Regards,
>> > > >>
>> > > >> Pierre
>> > > >>
>> > > >>
>> > > >> 2010/8/21 Scott Gray <sc...@hotwaxmedia.com>
>> > > >>
>> > > >> Hi Pierre,
>> > > >>>
>> > > >>> See my other response to Michal for the correct code, it was only
>> from
>> > > >>> memory though so may not actually work without tweaking.
>> > > >>>
>> > > >>> Regards
>> > > >>> Scott
>> > > >>>
>> > > >>> On 21/08/2010, at 12:02 AM, Pierre Smits wrote:
>> > > >>>
>> > > >>>> Hi Scott,
>> > > >>>>
>> > > >>>> Thanks for the pointer!
>> > > >>>>
>> > > >>>> Unfortunately, I am a total groovy-newbie....
>> > > >>>>
>> > > >>>> Would
>> > > >>>> selectedExperiences = parameter.selectedExperiences;
>> > > >>>> if (selectedExperiences==""){
>> > > >>>> experienceItemList = delegator.findByAnd("ProfileExperience",
>> > > >>>> [profileOwnerId : profileOwnerId]);
>> > > >>>> }
>> > > >>>> else{
>> > > >>>> experienceItemList = delegator.findList("ProfileExperience",
>> > > >>>> [experienceId : selectedExperiences]);
>> > > >>>>
>> > > >>>> }
>> > > >>>>
>> > > >>>> do the trick?
>> > > >>>>
>> > > >>>> Regards,
>> > > >>>>
>> > > >>>> Pierre
>> > > >>>>
>> > > >>>>
>> > > >>>> 2010/8/20 Scott Gray <sc...@hotwaxmedia.com>
>> > > >>>>
>> > > >>>>> Hi Pierre,
>> > > >>>>>
>> > > >>>>> You'll want to use delegator.findList(...) with an
>> EntityOperator.IN
>> > > >>>>> condition for the experience field.
>> > > >>>>>
>> > > >>>>> Regards
>> > > >>>>> Scott
>> > > >>>>>
>> > > >>>>> HotWax Media
>> > > >>>>> http://www.hotwaxmedia.com
>> > > >>>>>
>> > > >>>>> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
>> > > >>>>>
>> > > >>>>>> In a url I pass following parameters:
>> > > >>>>>>
>> > > >>>>>> ?profile=10000&experience=10000,100010
>> > > >>>>>>
>> > > >>>>>> In a groovy file I get the parameters....
>> > > >>>>>> parameter.profile
>> > > >>>>>> parameter.experience
>> > > >>>>>>
>> > > >>>>>> My question is: how do I get the delegator to find entities in
>> the
>> > > >>>>> database
>> > > >>>>>> based on both parameter.profile and parameter.experience?
>> > > >>>>>>
>> > > >>>>>> In all the other codes in groovy files that I see it seems that
>> > > >>>>> parameters
>> > > >>>>>> have only 1 value... Or I might be overlooking one...
>> > > >>>>>>
>> > > >>>>>> Regards,,
>> > > >>>>>>
>> > > >>>>>> Pierre
>> > > >>>>>
>> > > >>>>>
>> > > >>>
>> > > >>>
>> > > >>
>> > >
>> > >
>> >
>> >
>> >
>>
>>
>
Re: Groovy question regarding passing html parameters
Posted by Scott Gray <sc...@hotwaxmedia.com>.
Try removing the "as List" in the entity condition (I checked and an array parameter value is automatically converted to a list of values). If that doesn't work, what do the form inputs for experienceId look like? You should have multiple input fields (checkboxes I guess) sharing the same experienceId input name.
Regards
Scott
On 23/08/2010, at 10:07 PM, Pierre Smits wrote:
> I have added some print statements to the code to see what is generated, and I see following in my ofbiz console:
>
> selectedExperiences are 10003, 10020
> condList = [profileOwnerId = '10010', experienceId IN ('1', '0', '0', '0', '3',
> ',', ' ', '1', '0', '0', '2', '0')]
> cond = (profileOwnerId = '10010' AND experienceId IN ('1', '0', '0', '0', '3', '
> ,', ' ', '1', '0', '0', '2', '0'))
>
> It seems that the values of the second part of the query_string (&experienceSelected=10003, 10020) parsed in individual characters in
> EntityCondition.makeCondition("experienceId", EntityOperator.IN, selectedExperiences as List)
>
>
>
> 2010/8/23 Pierre Smits <pi...@gmail.com>
> You are absolutely right. Slightly the same is a huge difference...
>
>
> Regards,
>
> Pierre
>
> 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> The same or slightly different? You also need to do the same for the EntityOperator class and any others that are being used by your script.
>
> Regards
> Scott
>
> On 23/08/2010, at 8:47 PM, Pierre Smits wrote:
>
> > Hi Scott,
> >
> > I added the import. Unfortunately, the result is the same error.
> >
> > Regards,
> >
> > Pierre
> >
> >
> > 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> > Hi Pierre,
> >
> > You need to add the EntityCondition class to the list of imports:
> > import org.ofbiz.entity.condition.EntityCondition;
> >
> > Regards
> > Scott
> >
> > HotWax Media
> > http://www.hotwaxmedia.com
> >
> > On 23/08/2010, at 7:49 PM, Pierre Smits wrote:
> >
> > > The error more readable:
> > >
> > > Problems with the response writer/output stream:
> > > org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> > > [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> > > groovy.lang.MissingPropertyException: No such property: EntityCondition for
> > > class: ProfileExperiences (No such property: EntityCondition for class:
> > > ProfileExperiences)
> > >
> > > Regards,
> > >
> > > Pierre
> > >
> > > 2010/8/23 Pierre Smits <pi...@gmail.com>
> > >
> > >> Hi Scott,
> > >>
> > >> Thanks for the pointer. I think it should be on the money.... However after
> > >> some tweaking I got following error:
> > >>
> > >> <p>Problems with the response writer/output stream:
> > >>
> > >> org.ofbiz.widget.screen.ScreenRenderException:
> > >> Error rendering screen [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> > >>
> > >> groovy.lang.MissingPropertyException: No such property:
> > >> EntityCondition for class: ProfileExperiences (No such property: EntityCondition for class: ProfileExperiences)
> > >>
> > >> </p>
> > >>
> > >>
> > >> The complete code in the groovy file is:
> > >> import org.ofbiz.base.util.*;
> > >> import org.ofbiz.entity.*;
> > >> import org.ofbiz.entity.util.*;
> > >> import org.ofbiz.party.contact.*;
> > >> import javolution.util.FastMap;
> > >>
> > >> List experienceItems = [];
> > >>
> > >> profileOwnerId = profileSummary.profileOwnerId;
> > >> selectedExperiences = parameters.experienceSelected;
> > >>
> > >>
> > >> condList = [];
> > >> condList.add(EntityCondition.makeCondition("profileOwnerId",
> > >> profileOwnerId));
> > >> if (selectedExperiences) {
> > >> condList.add(EntityCondition.makeCondition("experienceId",
> > >> EntityOperator.IN, selectedExperiences as List));
> > >> }
> > >> cond = EntityCondition.makeCondition(condList);
> > >> experienceItemList = delegator.findList("ProfileExperience", cond, null,
> > >> null, null, false);
> > >>
> > >> if (experienceItemList) {
> > >> experienceItemList.each { profileExperience ->
> > >> experienceDesc = profileExperience.experienceDesc;
> > >> experienceStartDate = profileExperience.experienceStartDate;
> > >> experienceEndDate = profileExperience.experienceEndDate;
> > >> experienceCustomerId = profileExperience.experienceCustomerId;
> > >> experienceIndustryId = profileExperience.experienceIndustryId;
> > >> experienceProjectId = profileExperience.experienceProjectId;
> > >> experienceTaskId = profileExperience.experienceTaskId;
> > >> experienceBackground = profileExperience.experienceBackground;
> > >> experienceContext = profileExperience.experienceContext;
> > >> experienceTask = profileExperience.experienceTask;
> > >> experienceMethods = profileExperience.experienceMethods;
> > >> experienceTools = profileExperience.experienceTools;
> > >>
> > >> Map experienceItemMap = FastMap.newInstance();
> > >> experienceItemMap.putAll((Map) profileExperience);
> > >>
> > >> experienceItems.add(experienceItemMap);
> > >> }
> > >> context.experienceItems = experienceItems;
> > >> }
> > >>
> > >> Any suggestions?
> > >>
> > >> Regards,
> > >>
> > >> Pierre
> > >>
> > >>
> > >> 2010/8/21 Scott Gray <sc...@hotwaxmedia.com>
> > >>
> > >> Hi Pierre,
> > >>>
> > >>> See my other response to Michal for the correct code, it was only from
> > >>> memory though so may not actually work without tweaking.
> > >>>
> > >>> Regards
> > >>> Scott
> > >>>
> > >>> On 21/08/2010, at 12:02 AM, Pierre Smits wrote:
> > >>>
> > >>>> Hi Scott,
> > >>>>
> > >>>> Thanks for the pointer!
> > >>>>
> > >>>> Unfortunately, I am a total groovy-newbie....
> > >>>>
> > >>>> Would
> > >>>> selectedExperiences = parameter.selectedExperiences;
> > >>>> if (selectedExperiences==""){
> > >>>> experienceItemList = delegator.findByAnd("ProfileExperience",
> > >>>> [profileOwnerId : profileOwnerId]);
> > >>>> }
> > >>>> else{
> > >>>> experienceItemList = delegator.findList("ProfileExperience",
> > >>>> [experienceId : selectedExperiences]);
> > >>>>
> > >>>> }
> > >>>>
> > >>>> do the trick?
> > >>>>
> > >>>> Regards,
> > >>>>
> > >>>> Pierre
> > >>>>
> > >>>>
> > >>>> 2010/8/20 Scott Gray <sc...@hotwaxmedia.com>
> > >>>>
> > >>>>> Hi Pierre,
> > >>>>>
> > >>>>> You'll want to use delegator.findList(...) with an EntityOperator.IN
> > >>>>> condition for the experience field.
> > >>>>>
> > >>>>> Regards
> > >>>>> Scott
> > >>>>>
> > >>>>> HotWax Media
> > >>>>> http://www.hotwaxmedia.com
> > >>>>>
> > >>>>> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
> > >>>>>
> > >>>>>> In a url I pass following parameters:
> > >>>>>>
> > >>>>>> ?profile=10000&experience=10000,100010
> > >>>>>>
> > >>>>>> In a groovy file I get the parameters....
> > >>>>>> parameter.profile
> > >>>>>> parameter.experience
> > >>>>>>
> > >>>>>> My question is: how do I get the delegator to find entities in the
> > >>>>> database
> > >>>>>> based on both parameter.profile and parameter.experience?
> > >>>>>>
> > >>>>>> In all the other codes in groovy files that I see it seems that
> > >>>>> parameters
> > >>>>>> have only 1 value... Or I might be overlooking one...
> > >>>>>>
> > >>>>>> Regards,,
> > >>>>>>
> > >>>>>> Pierre
> > >>>>>
> > >>>>>
> > >>>
> > >>>
> > >>
> >
> >
>
>
>
Re: Groovy question regarding passing html parameters
Posted by Pierre Smits <pi...@gmail.com>.
I have added some print statements to the code to see what is generated, and
I see following in my ofbiz console:
selectedExperiences are 10003, 10020
condList = [profileOwnerId = '10010', experienceId IN ('1', '0', '0', '0',
'3',
',', ' ', '1', '0', '0', '2', '0')]
cond = (profileOwnerId = '10010' AND experienceId IN ('1', '0', '0', '0',
'3', '
,', ' ', '1', '0', '0', '2', '0'))
It seems that the values of the second part of the query_string
(&experienceSelected=10003, 10020) parsed in individual characters in
EntityCondition.makeCondition("experienceId", EntityOperator.IN,
selectedExperiences as List)
2010/8/23 Pierre Smits <pi...@gmail.com>
> You are absolutely right. Slightly the same is a huge difference...
>
>
> Regards,
>
> Pierre
>
> 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
>
>> The same or slightly different? You also need to do the same for the
>> EntityOperator class and any others that are being used by your script.
>>
>> Regards
>> Scott
>>
>> On 23/08/2010, at 8:47 PM, Pierre Smits wrote:
>>
>> > Hi Scott,
>> >
>> > I added the import. Unfortunately, the result is the same error.
>> >
>> > Regards,
>> >
>> > Pierre
>> >
>> >
>> > 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
>> > Hi Pierre,
>> >
>> > You need to add the EntityCondition class to the list of imports:
>> > import org.ofbiz.entity.condition.EntityCondition;
>> >
>> > Regards
>> > Scott
>> >
>> > HotWax Media
>> > http://www.hotwaxmedia.com
>> >
>> > On 23/08/2010, at 7:49 PM, Pierre Smits wrote:
>> >
>> > > The error more readable:
>> > >
>> > > Problems with the response writer/output stream:
>> > > org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
>> > >
>> [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
>> > > groovy.lang.MissingPropertyException: No such property:
>> EntityCondition for
>> > > class: ProfileExperiences (No such property: EntityCondition for
>> class:
>> > > ProfileExperiences)
>> > >
>> > > Regards,
>> > >
>> > > Pierre
>> > >
>> > > 2010/8/23 Pierre Smits <pi...@gmail.com>
>> > >
>> > >> Hi Scott,
>> > >>
>> > >> Thanks for the pointer. I think it should be on the money.... However
>> after
>> > >> some tweaking I got following error:
>> > >>
>> > >> <p>Problems with the response writer/output stream:
>> > >>
>> > >> org.ofbiz.widget.screen.ScreenRenderException:
>> > >> Error rendering screen
>> [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
>> > >>
>> > >> groovy.lang.MissingPropertyException: No such property:
>> > >> EntityCondition for class: ProfileExperiences (No such
>> property: EntityCondition for class: ProfileExperiences)
>> > >>
>> > >> </p>
>> > >>
>> > >>
>> > >> The complete code in the groovy file is:
>> > >> import org.ofbiz.base.util.*;
>> > >> import org.ofbiz.entity.*;
>> > >> import org.ofbiz.entity.util.*;
>> > >> import org.ofbiz.party.contact.*;
>> > >> import javolution.util.FastMap;
>> > >>
>> > >> List experienceItems = [];
>> > >>
>> > >> profileOwnerId = profileSummary.profileOwnerId;
>> > >> selectedExperiences = parameters.experienceSelected;
>> > >>
>> > >>
>> > >> condList = [];
>> > >> condList.add(EntityCondition.makeCondition("profileOwnerId",
>> > >> profileOwnerId));
>> > >> if (selectedExperiences) {
>> > >> condList.add(EntityCondition.makeCondition("experienceId",
>> > >> EntityOperator.IN, selectedExperiences as List));
>> > >> }
>> > >> cond = EntityCondition.makeCondition(condList);
>> > >> experienceItemList = delegator.findList("ProfileExperience", cond,
>> null,
>> > >> null, null, false);
>> > >>
>> > >> if (experienceItemList) {
>> > >> experienceItemList.each { profileExperience ->
>> > >> experienceDesc = profileExperience.experienceDesc;
>> > >> experienceStartDate = profileExperience.experienceStartDate;
>> > >> experienceEndDate = profileExperience.experienceEndDate;
>> > >> experienceCustomerId = profileExperience.experienceCustomerId;
>> > >> experienceIndustryId = profileExperience.experienceIndustryId;
>> > >> experienceProjectId = profileExperience.experienceProjectId;
>> > >> experienceTaskId = profileExperience.experienceTaskId;
>> > >> experienceBackground = profileExperience.experienceBackground;
>> > >> experienceContext = profileExperience.experienceContext;
>> > >> experienceTask = profileExperience.experienceTask;
>> > >> experienceMethods = profileExperience.experienceMethods;
>> > >> experienceTools = profileExperience.experienceTools;
>> > >>
>> > >> Map experienceItemMap = FastMap.newInstance();
>> > >> experienceItemMap.putAll((Map) profileExperience);
>> > >>
>> > >> experienceItems.add(experienceItemMap);
>> > >> }
>> > >> context.experienceItems = experienceItems;
>> > >> }
>> > >>
>> > >> Any suggestions?
>> > >>
>> > >> Regards,
>> > >>
>> > >> Pierre
>> > >>
>> > >>
>> > >> 2010/8/21 Scott Gray <sc...@hotwaxmedia.com>
>> > >>
>> > >> Hi Pierre,
>> > >>>
>> > >>> See my other response to Michal for the correct code, it was only
>> from
>> > >>> memory though so may not actually work without tweaking.
>> > >>>
>> > >>> Regards
>> > >>> Scott
>> > >>>
>> > >>> On 21/08/2010, at 12:02 AM, Pierre Smits wrote:
>> > >>>
>> > >>>> Hi Scott,
>> > >>>>
>> > >>>> Thanks for the pointer!
>> > >>>>
>> > >>>> Unfortunately, I am a total groovy-newbie....
>> > >>>>
>> > >>>> Would
>> > >>>> selectedExperiences = parameter.selectedExperiences;
>> > >>>> if (selectedExperiences==""){
>> > >>>> experienceItemList = delegator.findByAnd("ProfileExperience",
>> > >>>> [profileOwnerId : profileOwnerId]);
>> > >>>> }
>> > >>>> else{
>> > >>>> experienceItemList = delegator.findList("ProfileExperience",
>> > >>>> [experienceId : selectedExperiences]);
>> > >>>>
>> > >>>> }
>> > >>>>
>> > >>>> do the trick?
>> > >>>>
>> > >>>> Regards,
>> > >>>>
>> > >>>> Pierre
>> > >>>>
>> > >>>>
>> > >>>> 2010/8/20 Scott Gray <sc...@hotwaxmedia.com>
>> > >>>>
>> > >>>>> Hi Pierre,
>> > >>>>>
>> > >>>>> You'll want to use delegator.findList(...) with an
>> EntityOperator.IN
>> > >>>>> condition for the experience field.
>> > >>>>>
>> > >>>>> Regards
>> > >>>>> Scott
>> > >>>>>
>> > >>>>> HotWax Media
>> > >>>>> http://www.hotwaxmedia.com
>> > >>>>>
>> > >>>>> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
>> > >>>>>
>> > >>>>>> In a url I pass following parameters:
>> > >>>>>>
>> > >>>>>> ?profile=10000&experience=10000,100010
>> > >>>>>>
>> > >>>>>> In a groovy file I get the parameters....
>> > >>>>>> parameter.profile
>> > >>>>>> parameter.experience
>> > >>>>>>
>> > >>>>>> My question is: how do I get the delegator to find entities in
>> the
>> > >>>>> database
>> > >>>>>> based on both parameter.profile and parameter.experience?
>> > >>>>>>
>> > >>>>>> In all the other codes in groovy files that I see it seems that
>> > >>>>> parameters
>> > >>>>>> have only 1 value... Or I might be overlooking one...
>> > >>>>>>
>> > >>>>>> Regards,,
>> > >>>>>>
>> > >>>>>> Pierre
>> > >>>>>
>> > >>>>>
>> > >>>
>> > >>>
>> > >>
>> >
>> >
>>
>>
>
Re: Groovy question regarding passing html parameters
Posted by Pierre Smits <pi...@gmail.com>.
You are absolutely right. Slightly the same is a huge difference...
Regards,
Pierre
2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> The same or slightly different? You also need to do the same for the
> EntityOperator class and any others that are being used by your script.
>
> Regards
> Scott
>
> On 23/08/2010, at 8:47 PM, Pierre Smits wrote:
>
> > Hi Scott,
> >
> > I added the import. Unfortunately, the result is the same error.
> >
> > Regards,
> >
> > Pierre
> >
> >
> > 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> > Hi Pierre,
> >
> > You need to add the EntityCondition class to the list of imports:
> > import org.ofbiz.entity.condition.EntityCondition;
> >
> > Regards
> > Scott
> >
> > HotWax Media
> > http://www.hotwaxmedia.com
> >
> > On 23/08/2010, at 7:49 PM, Pierre Smits wrote:
> >
> > > The error more readable:
> > >
> > > Problems with the response writer/output stream:
> > > org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> > > [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> > > groovy.lang.MissingPropertyException: No such property: EntityCondition
> for
> > > class: ProfileExperiences (No such property: EntityCondition for class:
> > > ProfileExperiences)
> > >
> > > Regards,
> > >
> > > Pierre
> > >
> > > 2010/8/23 Pierre Smits <pi...@gmail.com>
> > >
> > >> Hi Scott,
> > >>
> > >> Thanks for the pointer. I think it should be on the money.... However
> after
> > >> some tweaking I got following error:
> > >>
> > >> <p>Problems with the response writer/output stream:
> > >>
> > >> org.ofbiz.widget.screen.ScreenRenderException:
> > >> Error rendering screen
> [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> > >>
> > >> groovy.lang.MissingPropertyException: No such property:
> > >> EntityCondition for class: ProfileExperiences (No such
> property: EntityCondition for class: ProfileExperiences)
> > >>
> > >> </p>
> > >>
> > >>
> > >> The complete code in the groovy file is:
> > >> import org.ofbiz.base.util.*;
> > >> import org.ofbiz.entity.*;
> > >> import org.ofbiz.entity.util.*;
> > >> import org.ofbiz.party.contact.*;
> > >> import javolution.util.FastMap;
> > >>
> > >> List experienceItems = [];
> > >>
> > >> profileOwnerId = profileSummary.profileOwnerId;
> > >> selectedExperiences = parameters.experienceSelected;
> > >>
> > >>
> > >> condList = [];
> > >> condList.add(EntityCondition.makeCondition("profileOwnerId",
> > >> profileOwnerId));
> > >> if (selectedExperiences) {
> > >> condList.add(EntityCondition.makeCondition("experienceId",
> > >> EntityOperator.IN, selectedExperiences as List));
> > >> }
> > >> cond = EntityCondition.makeCondition(condList);
> > >> experienceItemList = delegator.findList("ProfileExperience", cond,
> null,
> > >> null, null, false);
> > >>
> > >> if (experienceItemList) {
> > >> experienceItemList.each { profileExperience ->
> > >> experienceDesc = profileExperience.experienceDesc;
> > >> experienceStartDate = profileExperience.experienceStartDate;
> > >> experienceEndDate = profileExperience.experienceEndDate;
> > >> experienceCustomerId = profileExperience.experienceCustomerId;
> > >> experienceIndustryId = profileExperience.experienceIndustryId;
> > >> experienceProjectId = profileExperience.experienceProjectId;
> > >> experienceTaskId = profileExperience.experienceTaskId;
> > >> experienceBackground = profileExperience.experienceBackground;
> > >> experienceContext = profileExperience.experienceContext;
> > >> experienceTask = profileExperience.experienceTask;
> > >> experienceMethods = profileExperience.experienceMethods;
> > >> experienceTools = profileExperience.experienceTools;
> > >>
> > >> Map experienceItemMap = FastMap.newInstance();
> > >> experienceItemMap.putAll((Map) profileExperience);
> > >>
> > >> experienceItems.add(experienceItemMap);
> > >> }
> > >> context.experienceItems = experienceItems;
> > >> }
> > >>
> > >> Any suggestions?
> > >>
> > >> Regards,
> > >>
> > >> Pierre
> > >>
> > >>
> > >> 2010/8/21 Scott Gray <sc...@hotwaxmedia.com>
> > >>
> > >> Hi Pierre,
> > >>>
> > >>> See my other response to Michal for the correct code, it was only
> from
> > >>> memory though so may not actually work without tweaking.
> > >>>
> > >>> Regards
> > >>> Scott
> > >>>
> > >>> On 21/08/2010, at 12:02 AM, Pierre Smits wrote:
> > >>>
> > >>>> Hi Scott,
> > >>>>
> > >>>> Thanks for the pointer!
> > >>>>
> > >>>> Unfortunately, I am a total groovy-newbie....
> > >>>>
> > >>>> Would
> > >>>> selectedExperiences = parameter.selectedExperiences;
> > >>>> if (selectedExperiences==""){
> > >>>> experienceItemList = delegator.findByAnd("ProfileExperience",
> > >>>> [profileOwnerId : profileOwnerId]);
> > >>>> }
> > >>>> else{
> > >>>> experienceItemList = delegator.findList("ProfileExperience",
> > >>>> [experienceId : selectedExperiences]);
> > >>>>
> > >>>> }
> > >>>>
> > >>>> do the trick?
> > >>>>
> > >>>> Regards,
> > >>>>
> > >>>> Pierre
> > >>>>
> > >>>>
> > >>>> 2010/8/20 Scott Gray <sc...@hotwaxmedia.com>
> > >>>>
> > >>>>> Hi Pierre,
> > >>>>>
> > >>>>> You'll want to use delegator.findList(...) with an
> EntityOperator.IN
> > >>>>> condition for the experience field.
> > >>>>>
> > >>>>> Regards
> > >>>>> Scott
> > >>>>>
> > >>>>> HotWax Media
> > >>>>> http://www.hotwaxmedia.com
> > >>>>>
> > >>>>> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
> > >>>>>
> > >>>>>> In a url I pass following parameters:
> > >>>>>>
> > >>>>>> ?profile=10000&experience=10000,100010
> > >>>>>>
> > >>>>>> In a groovy file I get the parameters....
> > >>>>>> parameter.profile
> > >>>>>> parameter.experience
> > >>>>>>
> > >>>>>> My question is: how do I get the delegator to find entities in the
> > >>>>> database
> > >>>>>> based on both parameter.profile and parameter.experience?
> > >>>>>>
> > >>>>>> In all the other codes in groovy files that I see it seems that
> > >>>>> parameters
> > >>>>>> have only 1 value... Or I might be overlooking one...
> > >>>>>>
> > >>>>>> Regards,,
> > >>>>>>
> > >>>>>> Pierre
> > >>>>>
> > >>>>>
> > >>>
> > >>>
> > >>
> >
> >
>
>
Re: Groovy question regarding passing html parameters
Posted by Scott Gray <sc...@hotwaxmedia.com>.
The same or slightly different? You also need to do the same for the EntityOperator class and any others that are being used by your script.
Regards
Scott
On 23/08/2010, at 8:47 PM, Pierre Smits wrote:
> Hi Scott,
>
> I added the import. Unfortunately, the result is the same error.
>
> Regards,
>
> Pierre
>
>
> 2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> Hi Pierre,
>
> You need to add the EntityCondition class to the list of imports:
> import org.ofbiz.entity.condition.EntityCondition;
>
> Regards
> Scott
>
> HotWax Media
> http://www.hotwaxmedia.com
>
> On 23/08/2010, at 7:49 PM, Pierre Smits wrote:
>
> > The error more readable:
> >
> > Problems with the response writer/output stream:
> > org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> > [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> > groovy.lang.MissingPropertyException: No such property: EntityCondition for
> > class: ProfileExperiences (No such property: EntityCondition for class:
> > ProfileExperiences)
> >
> > Regards,
> >
> > Pierre
> >
> > 2010/8/23 Pierre Smits <pi...@gmail.com>
> >
> >> Hi Scott,
> >>
> >> Thanks for the pointer. I think it should be on the money.... However after
> >> some tweaking I got following error:
> >>
> >> <p>Problems with the response writer/output stream:
> >>
> >> org.ofbiz.widget.screen.ScreenRenderException:
> >> Error rendering screen [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> >>
> >> groovy.lang.MissingPropertyException: No such property:
> >> EntityCondition for class: ProfileExperiences (No such property: EntityCondition for class: ProfileExperiences)
> >>
> >> </p>
> >>
> >>
> >> The complete code in the groovy file is:
> >> import org.ofbiz.base.util.*;
> >> import org.ofbiz.entity.*;
> >> import org.ofbiz.entity.util.*;
> >> import org.ofbiz.party.contact.*;
> >> import javolution.util.FastMap;
> >>
> >> List experienceItems = [];
> >>
> >> profileOwnerId = profileSummary.profileOwnerId;
> >> selectedExperiences = parameters.experienceSelected;
> >>
> >>
> >> condList = [];
> >> condList.add(EntityCondition.makeCondition("profileOwnerId",
> >> profileOwnerId));
> >> if (selectedExperiences) {
> >> condList.add(EntityCondition.makeCondition("experienceId",
> >> EntityOperator.IN, selectedExperiences as List));
> >> }
> >> cond = EntityCondition.makeCondition(condList);
> >> experienceItemList = delegator.findList("ProfileExperience", cond, null,
> >> null, null, false);
> >>
> >> if (experienceItemList) {
> >> experienceItemList.each { profileExperience ->
> >> experienceDesc = profileExperience.experienceDesc;
> >> experienceStartDate = profileExperience.experienceStartDate;
> >> experienceEndDate = profileExperience.experienceEndDate;
> >> experienceCustomerId = profileExperience.experienceCustomerId;
> >> experienceIndustryId = profileExperience.experienceIndustryId;
> >> experienceProjectId = profileExperience.experienceProjectId;
> >> experienceTaskId = profileExperience.experienceTaskId;
> >> experienceBackground = profileExperience.experienceBackground;
> >> experienceContext = profileExperience.experienceContext;
> >> experienceTask = profileExperience.experienceTask;
> >> experienceMethods = profileExperience.experienceMethods;
> >> experienceTools = profileExperience.experienceTools;
> >>
> >> Map experienceItemMap = FastMap.newInstance();
> >> experienceItemMap.putAll((Map) profileExperience);
> >>
> >> experienceItems.add(experienceItemMap);
> >> }
> >> context.experienceItems = experienceItems;
> >> }
> >>
> >> Any suggestions?
> >>
> >> Regards,
> >>
> >> Pierre
> >>
> >>
> >> 2010/8/21 Scott Gray <sc...@hotwaxmedia.com>
> >>
> >> Hi Pierre,
> >>>
> >>> See my other response to Michal for the correct code, it was only from
> >>> memory though so may not actually work without tweaking.
> >>>
> >>> Regards
> >>> Scott
> >>>
> >>> On 21/08/2010, at 12:02 AM, Pierre Smits wrote:
> >>>
> >>>> Hi Scott,
> >>>>
> >>>> Thanks for the pointer!
> >>>>
> >>>> Unfortunately, I am a total groovy-newbie....
> >>>>
> >>>> Would
> >>>> selectedExperiences = parameter.selectedExperiences;
> >>>> if (selectedExperiences==""){
> >>>> experienceItemList = delegator.findByAnd("ProfileExperience",
> >>>> [profileOwnerId : profileOwnerId]);
> >>>> }
> >>>> else{
> >>>> experienceItemList = delegator.findList("ProfileExperience",
> >>>> [experienceId : selectedExperiences]);
> >>>>
> >>>> }
> >>>>
> >>>> do the trick?
> >>>>
> >>>> Regards,
> >>>>
> >>>> Pierre
> >>>>
> >>>>
> >>>> 2010/8/20 Scott Gray <sc...@hotwaxmedia.com>
> >>>>
> >>>>> Hi Pierre,
> >>>>>
> >>>>> You'll want to use delegator.findList(...) with an EntityOperator.IN
> >>>>> condition for the experience field.
> >>>>>
> >>>>> Regards
> >>>>> Scott
> >>>>>
> >>>>> HotWax Media
> >>>>> http://www.hotwaxmedia.com
> >>>>>
> >>>>> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
> >>>>>
> >>>>>> In a url I pass following parameters:
> >>>>>>
> >>>>>> ?profile=10000&experience=10000,100010
> >>>>>>
> >>>>>> In a groovy file I get the parameters....
> >>>>>> parameter.profile
> >>>>>> parameter.experience
> >>>>>>
> >>>>>> My question is: how do I get the delegator to find entities in the
> >>>>> database
> >>>>>> based on both parameter.profile and parameter.experience?
> >>>>>>
> >>>>>> In all the other codes in groovy files that I see it seems that
> >>>>> parameters
> >>>>>> have only 1 value... Or I might be overlooking one...
> >>>>>>
> >>>>>> Regards,,
> >>>>>>
> >>>>>> Pierre
> >>>>>
> >>>>>
> >>>
> >>>
> >>
>
>
Re: Groovy question regarding passing html parameters
Posted by Pierre Smits <pi...@gmail.com>.
Hi Scott,
I added the import. Unfortunately, the result is the same error.
Regards,
Pierre
2010/8/23 Scott Gray <sc...@hotwaxmedia.com>
> Hi Pierre,
>
> You need to add the EntityCondition class to the list of imports:
> import org.ofbiz.entity.condition.EntityCondition;
>
> Regards
> Scott
>
> HotWax Media
> http://www.hotwaxmedia.com
>
> On 23/08/2010, at 7:49 PM, Pierre Smits wrote:
>
> > The error more readable:
> >
> > Problems with the response writer/output stream:
> > org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> > [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> > groovy.lang.MissingPropertyException: No such property: EntityCondition
> for
> > class: ProfileExperiences (No such property: EntityCondition for class:
> > ProfileExperiences)
> >
> > Regards,
> >
> > Pierre
> >
> > 2010/8/23 Pierre Smits <pi...@gmail.com>
> >
> >> Hi Scott,
> >>
> >> Thanks for the pointer. I think it should be on the money.... However
> after
> >> some tweaking I got following error:
> >>
> >> <p>Problems with the response writer/output stream:
> >>
> >> org.ofbiz.widget.screen.ScreenRenderException:
> >> Error rendering screen
> [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> >>
> >> groovy.lang.MissingPropertyException: No such property:
> >> EntityCondition for class: ProfileExperiences (No such
> property: EntityCondition for class: ProfileExperiences)
> >>
> >> </p>
> >>
> >>
> >> The complete code in the groovy file is:
> >> import org.ofbiz.base.util.*;
> >> import org.ofbiz.entity.*;
> >> import org.ofbiz.entity.util.*;
> >> import org.ofbiz.party.contact.*;
> >> import javolution.util.FastMap;
> >>
> >> List experienceItems = [];
> >>
> >> profileOwnerId = profileSummary.profileOwnerId;
> >> selectedExperiences = parameters.experienceSelected;
> >>
> >>
> >> condList = [];
> >> condList.add(EntityCondition.makeCondition("profileOwnerId",
> >> profileOwnerId));
> >> if (selectedExperiences) {
> >> condList.add(EntityCondition.makeCondition("experienceId",
> >> EntityOperator.IN, selectedExperiences as List));
> >> }
> >> cond = EntityCondition.makeCondition(condList);
> >> experienceItemList = delegator.findList("ProfileExperience", cond, null,
> >> null, null, false);
> >>
> >> if (experienceItemList) {
> >> experienceItemList.each { profileExperience ->
> >> experienceDesc = profileExperience.experienceDesc;
> >> experienceStartDate = profileExperience.experienceStartDate;
> >> experienceEndDate = profileExperience.experienceEndDate;
> >> experienceCustomerId = profileExperience.experienceCustomerId;
> >> experienceIndustryId = profileExperience.experienceIndustryId;
> >> experienceProjectId = profileExperience.experienceProjectId;
> >> experienceTaskId = profileExperience.experienceTaskId;
> >> experienceBackground = profileExperience.experienceBackground;
> >> experienceContext = profileExperience.experienceContext;
> >> experienceTask = profileExperience.experienceTask;
> >> experienceMethods = profileExperience.experienceMethods;
> >> experienceTools = profileExperience.experienceTools;
> >>
> >> Map experienceItemMap = FastMap.newInstance();
> >> experienceItemMap.putAll((Map) profileExperience);
> >>
> >> experienceItems.add(experienceItemMap);
> >> }
> >> context.experienceItems = experienceItems;
> >> }
> >>
> >> Any suggestions?
> >>
> >> Regards,
> >>
> >> Pierre
> >>
> >>
> >> 2010/8/21 Scott Gray <sc...@hotwaxmedia.com>
> >>
> >> Hi Pierre,
> >>>
> >>> See my other response to Michal for the correct code, it was only from
> >>> memory though so may not actually work without tweaking.
> >>>
> >>> Regards
> >>> Scott
> >>>
> >>> On 21/08/2010, at 12:02 AM, Pierre Smits wrote:
> >>>
> >>>> Hi Scott,
> >>>>
> >>>> Thanks for the pointer!
> >>>>
> >>>> Unfortunately, I am a total groovy-newbie....
> >>>>
> >>>> Would
> >>>> selectedExperiences = parameter.selectedExperiences;
> >>>> if (selectedExperiences==""){
> >>>> experienceItemList = delegator.findByAnd("ProfileExperience",
> >>>> [profileOwnerId : profileOwnerId]);
> >>>> }
> >>>> else{
> >>>> experienceItemList = delegator.findList("ProfileExperience",
> >>>> [experienceId : selectedExperiences]);
> >>>>
> >>>> }
> >>>>
> >>>> do the trick?
> >>>>
> >>>> Regards,
> >>>>
> >>>> Pierre
> >>>>
> >>>>
> >>>> 2010/8/20 Scott Gray <sc...@hotwaxmedia.com>
> >>>>
> >>>>> Hi Pierre,
> >>>>>
> >>>>> You'll want to use delegator.findList(...) with an EntityOperator.IN
> >>>>> condition for the experience field.
> >>>>>
> >>>>> Regards
> >>>>> Scott
> >>>>>
> >>>>> HotWax Media
> >>>>> http://www.hotwaxmedia.com
> >>>>>
> >>>>> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
> >>>>>
> >>>>>> In a url I pass following parameters:
> >>>>>>
> >>>>>> ?profile=10000&experience=10000,100010
> >>>>>>
> >>>>>> In a groovy file I get the parameters....
> >>>>>> parameter.profile
> >>>>>> parameter.experience
> >>>>>>
> >>>>>> My question is: how do I get the delegator to find entities in the
> >>>>> database
> >>>>>> based on both parameter.profile and parameter.experience?
> >>>>>>
> >>>>>> In all the other codes in groovy files that I see it seems that
> >>>>> parameters
> >>>>>> have only 1 value... Or I might be overlooking one...
> >>>>>>
> >>>>>> Regards,,
> >>>>>>
> >>>>>> Pierre
> >>>>>
> >>>>>
> >>>
> >>>
> >>
>
>
Re: Groovy question regarding passing html parameters
Posted by Scott Gray <sc...@hotwaxmedia.com>.
Hi Pierre,
You need to add the EntityCondition class to the list of imports:
import org.ofbiz.entity.condition.EntityCondition;
Regards
Scott
HotWax Media
http://www.hotwaxmedia.com
On 23/08/2010, at 7:49 PM, Pierre Smits wrote:
> The error more readable:
>
> Problems with the response writer/output stream:
> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
> groovy.lang.MissingPropertyException: No such property: EntityCondition for
> class: ProfileExperiences (No such property: EntityCondition for class:
> ProfileExperiences)
>
> Regards,
>
> Pierre
>
> 2010/8/23 Pierre Smits <pi...@gmail.com>
>
>> Hi Scott,
>>
>> Thanks for the pointer. I think it should be on the money.... However after
>> some tweaking I got following error:
>>
>> <p>Problems with the response writer/output stream:
>>
>> org.ofbiz.widget.screen.ScreenRenderException:
>> Error rendering screen [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
>>
>> groovy.lang.MissingPropertyException: No such property:
>> EntityCondition for class: ProfileExperiences (No such property: EntityCondition for class: ProfileExperiences)
>>
>> </p>
>>
>>
>> The complete code in the groovy file is:
>> import org.ofbiz.base.util.*;
>> import org.ofbiz.entity.*;
>> import org.ofbiz.entity.util.*;
>> import org.ofbiz.party.contact.*;
>> import javolution.util.FastMap;
>>
>> List experienceItems = [];
>>
>> profileOwnerId = profileSummary.profileOwnerId;
>> selectedExperiences = parameters.experienceSelected;
>>
>>
>> condList = [];
>> condList.add(EntityCondition.makeCondition("profileOwnerId",
>> profileOwnerId));
>> if (selectedExperiences) {
>> condList.add(EntityCondition.makeCondition("experienceId",
>> EntityOperator.IN, selectedExperiences as List));
>> }
>> cond = EntityCondition.makeCondition(condList);
>> experienceItemList = delegator.findList("ProfileExperience", cond, null,
>> null, null, false);
>>
>> if (experienceItemList) {
>> experienceItemList.each { profileExperience ->
>> experienceDesc = profileExperience.experienceDesc;
>> experienceStartDate = profileExperience.experienceStartDate;
>> experienceEndDate = profileExperience.experienceEndDate;
>> experienceCustomerId = profileExperience.experienceCustomerId;
>> experienceIndustryId = profileExperience.experienceIndustryId;
>> experienceProjectId = profileExperience.experienceProjectId;
>> experienceTaskId = profileExperience.experienceTaskId;
>> experienceBackground = profileExperience.experienceBackground;
>> experienceContext = profileExperience.experienceContext;
>> experienceTask = profileExperience.experienceTask;
>> experienceMethods = profileExperience.experienceMethods;
>> experienceTools = profileExperience.experienceTools;
>>
>> Map experienceItemMap = FastMap.newInstance();
>> experienceItemMap.putAll((Map) profileExperience);
>>
>> experienceItems.add(experienceItemMap);
>> }
>> context.experienceItems = experienceItems;
>> }
>>
>> Any suggestions?
>>
>> Regards,
>>
>> Pierre
>>
>>
>> 2010/8/21 Scott Gray <sc...@hotwaxmedia.com>
>>
>> Hi Pierre,
>>>
>>> See my other response to Michal for the correct code, it was only from
>>> memory though so may not actually work without tweaking.
>>>
>>> Regards
>>> Scott
>>>
>>> On 21/08/2010, at 12:02 AM, Pierre Smits wrote:
>>>
>>>> Hi Scott,
>>>>
>>>> Thanks for the pointer!
>>>>
>>>> Unfortunately, I am a total groovy-newbie....
>>>>
>>>> Would
>>>> selectedExperiences = parameter.selectedExperiences;
>>>> if (selectedExperiences==""){
>>>> experienceItemList = delegator.findByAnd("ProfileExperience",
>>>> [profileOwnerId : profileOwnerId]);
>>>> }
>>>> else{
>>>> experienceItemList = delegator.findList("ProfileExperience",
>>>> [experienceId : selectedExperiences]);
>>>>
>>>> }
>>>>
>>>> do the trick?
>>>>
>>>> Regards,
>>>>
>>>> Pierre
>>>>
>>>>
>>>> 2010/8/20 Scott Gray <sc...@hotwaxmedia.com>
>>>>
>>>>> Hi Pierre,
>>>>>
>>>>> You'll want to use delegator.findList(...) with an EntityOperator.IN
>>>>> condition for the experience field.
>>>>>
>>>>> Regards
>>>>> Scott
>>>>>
>>>>> HotWax Media
>>>>> http://www.hotwaxmedia.com
>>>>>
>>>>> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
>>>>>
>>>>>> In a url I pass following parameters:
>>>>>>
>>>>>> ?profile=10000&experience=10000,100010
>>>>>>
>>>>>> In a groovy file I get the parameters....
>>>>>> parameter.profile
>>>>>> parameter.experience
>>>>>>
>>>>>> My question is: how do I get the delegator to find entities in the
>>>>> database
>>>>>> based on both parameter.profile and parameter.experience?
>>>>>>
>>>>>> In all the other codes in groovy files that I see it seems that
>>>>> parameters
>>>>>> have only 1 value... Or I might be overlooking one...
>>>>>>
>>>>>> Regards,,
>>>>>>
>>>>>> Pierre
>>>>>
>>>>>
>>>
>>>
>>
Re: Groovy question regarding passing html parameters
Posted by Pierre Smits <pi...@gmail.com>.
The error more readable:
Problems with the response writer/output stream:
org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
[component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
groovy.lang.MissingPropertyException: No such property: EntityCondition for
class: ProfileExperiences (No such property: EntityCondition for class:
ProfileExperiences)
Regards,
Pierre
2010/8/23 Pierre Smits <pi...@gmail.com>
> Hi Scott,
>
> Thanks for the pointer. I think it should be on the money.... However after
> some tweaking I got following error:
>
> <p>Problems with the response writer/output stream:
>
> org.ofbiz.widget.screen.ScreenRenderException:
> Error rendering screen [component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
>
> groovy.lang.MissingPropertyException: No such property:
> EntityCondition for class: ProfileExperiences (No such property: EntityCondition for class: ProfileExperiences)
>
> </p>
>
>
> The complete code in the groovy file is:
> import org.ofbiz.base.util.*;
> import org.ofbiz.entity.*;
> import org.ofbiz.entity.util.*;
> import org.ofbiz.party.contact.*;
> import javolution.util.FastMap;
>
> List experienceItems = [];
>
> profileOwnerId = profileSummary.profileOwnerId;
> selectedExperiences = parameters.experienceSelected;
>
>
> condList = [];
> condList.add(EntityCondition.makeCondition("profileOwnerId",
> profileOwnerId));
> if (selectedExperiences) {
> condList.add(EntityCondition.makeCondition("experienceId",
> EntityOperator.IN, selectedExperiences as List));
> }
> cond = EntityCondition.makeCondition(condList);
> experienceItemList = delegator.findList("ProfileExperience", cond, null,
> null, null, false);
>
> if (experienceItemList) {
> experienceItemList.each { profileExperience ->
> experienceDesc = profileExperience.experienceDesc;
> experienceStartDate = profileExperience.experienceStartDate;
> experienceEndDate = profileExperience.experienceEndDate;
> experienceCustomerId = profileExperience.experienceCustomerId;
> experienceIndustryId = profileExperience.experienceIndustryId;
> experienceProjectId = profileExperience.experienceProjectId;
> experienceTaskId = profileExperience.experienceTaskId;
> experienceBackground = profileExperience.experienceBackground;
> experienceContext = profileExperience.experienceContext;
> experienceTask = profileExperience.experienceTask;
> experienceMethods = profileExperience.experienceMethods;
> experienceTools = profileExperience.experienceTools;
>
> Map experienceItemMap = FastMap.newInstance();
> experienceItemMap.putAll((Map) profileExperience);
>
> experienceItems.add(experienceItemMap);
> }
> context.experienceItems = experienceItems;
> }
>
> Any suggestions?
>
> Regards,
>
> Pierre
>
>
> 2010/8/21 Scott Gray <sc...@hotwaxmedia.com>
>
> Hi Pierre,
>>
>> See my other response to Michal for the correct code, it was only from
>> memory though so may not actually work without tweaking.
>>
>> Regards
>> Scott
>>
>> On 21/08/2010, at 12:02 AM, Pierre Smits wrote:
>>
>> > Hi Scott,
>> >
>> > Thanks for the pointer!
>> >
>> > Unfortunately, I am a total groovy-newbie....
>> >
>> > Would
>> > selectedExperiences = parameter.selectedExperiences;
>> > if (selectedExperiences==""){
>> > experienceItemList = delegator.findByAnd("ProfileExperience",
>> > [profileOwnerId : profileOwnerId]);
>> > }
>> > else{
>> > experienceItemList = delegator.findList("ProfileExperience",
>> > [experienceId : selectedExperiences]);
>> >
>> > }
>> >
>> > do the trick?
>> >
>> > Regards,
>> >
>> > Pierre
>> >
>> >
>> > 2010/8/20 Scott Gray <sc...@hotwaxmedia.com>
>> >
>> >> Hi Pierre,
>> >>
>> >> You'll want to use delegator.findList(...) with an EntityOperator.IN
>> >> condition for the experience field.
>> >>
>> >> Regards
>> >> Scott
>> >>
>> >> HotWax Media
>> >> http://www.hotwaxmedia.com
>> >>
>> >> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
>> >>
>> >>> In a url I pass following parameters:
>> >>>
>> >>> ?profile=10000&experience=10000,100010
>> >>>
>> >>> In a groovy file I get the parameters....
>> >>> parameter.profile
>> >>> parameter.experience
>> >>>
>> >>> My question is: how do I get the delegator to find entities in the
>> >> database
>> >>> based on both parameter.profile and parameter.experience?
>> >>>
>> >>> In all the other codes in groovy files that I see it seems that
>> >> parameters
>> >>> have only 1 value... Or I might be overlooking one...
>> >>>
>> >>> Regards,,
>> >>>
>> >>> Pierre
>> >>
>> >>
>>
>>
>
Re: Groovy question regarding passing html parameters
Posted by Pierre Smits <pi...@gmail.com>.
Hi Scott,
Thanks for the pointer. I think it should be on the money.... However after
some tweaking I got following error:
<p>Problems with the response writer/output stream:
org.ofbiz.widget.screen.ScreenRenderException:
Error rendering screen
[component://profiler/widget/ProfilerPrintScreens.xml#PrintProfilePDF]:
groovy.lang.MissingPropertyException: No such property:
EntityCondition for class: ProfileExperiences (No such
property: EntityCondition for class: ProfileExperiences)
</p>
The complete code in the groovy file is:
import org.ofbiz.base.util.*;
import org.ofbiz.entity.*;
import org.ofbiz.entity.util.*;
import org.ofbiz.party.contact.*;
import javolution.util.FastMap;
List experienceItems = [];
profileOwnerId = profileSummary.profileOwnerId;
selectedExperiences = parameters.experienceSelected;
condList = [];
condList.add(EntityCondition.makeCondition("profileOwnerId",
profileOwnerId));
if (selectedExperiences) {
condList.add(EntityCondition.makeCondition("experienceId",
EntityOperator.IN, selectedExperiences as List));
}
cond = EntityCondition.makeCondition(condList);
experienceItemList = delegator.findList("ProfileExperience", cond, null,
null, null, false);
if (experienceItemList) {
experienceItemList.each { profileExperience ->
experienceDesc = profileExperience.experienceDesc;
experienceStartDate = profileExperience.experienceStartDate;
experienceEndDate = profileExperience.experienceEndDate;
experienceCustomerId = profileExperience.experienceCustomerId;
experienceIndustryId = profileExperience.experienceIndustryId;
experienceProjectId = profileExperience.experienceProjectId;
experienceTaskId = profileExperience.experienceTaskId;
experienceBackground = profileExperience.experienceBackground;
experienceContext = profileExperience.experienceContext;
experienceTask = profileExperience.experienceTask;
experienceMethods = profileExperience.experienceMethods;
experienceTools = profileExperience.experienceTools;
Map experienceItemMap = FastMap.newInstance();
experienceItemMap.putAll((Map) profileExperience);
experienceItems.add(experienceItemMap);
}
context.experienceItems = experienceItems;
}
Any suggestions?
Regards,
Pierre
2010/8/21 Scott Gray <sc...@hotwaxmedia.com>
> Hi Pierre,
>
> See my other response to Michal for the correct code, it was only from
> memory though so may not actually work without tweaking.
>
> Regards
> Scott
>
> On 21/08/2010, at 12:02 AM, Pierre Smits wrote:
>
> > Hi Scott,
> >
> > Thanks for the pointer!
> >
> > Unfortunately, I am a total groovy-newbie....
> >
> > Would
> > selectedExperiences = parameter.selectedExperiences;
> > if (selectedExperiences==""){
> > experienceItemList = delegator.findByAnd("ProfileExperience",
> > [profileOwnerId : profileOwnerId]);
> > }
> > else{
> > experienceItemList = delegator.findList("ProfileExperience",
> > [experienceId : selectedExperiences]);
> >
> > }
> >
> > do the trick?
> >
> > Regards,
> >
> > Pierre
> >
> >
> > 2010/8/20 Scott Gray <sc...@hotwaxmedia.com>
> >
> >> Hi Pierre,
> >>
> >> You'll want to use delegator.findList(...) with an EntityOperator.IN
> >> condition for the experience field.
> >>
> >> Regards
> >> Scott
> >>
> >> HotWax Media
> >> http://www.hotwaxmedia.com
> >>
> >> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
> >>
> >>> In a url I pass following parameters:
> >>>
> >>> ?profile=10000&experience=10000,100010
> >>>
> >>> In a groovy file I get the parameters....
> >>> parameter.profile
> >>> parameter.experience
> >>>
> >>> My question is: how do I get the delegator to find entities in the
> >> database
> >>> based on both parameter.profile and parameter.experience?
> >>>
> >>> In all the other codes in groovy files that I see it seems that
> >> parameters
> >>> have only 1 value... Or I might be overlooking one...
> >>>
> >>> Regards,,
> >>>
> >>> Pierre
> >>
> >>
>
>
Re: Groovy question regarding passing html parameters
Posted by Scott Gray <sc...@hotwaxmedia.com>.
Hi Pierre,
See my other response to Michal for the correct code, it was only from memory though so may not actually work without tweaking.
Regards
Scott
On 21/08/2010, at 12:02 AM, Pierre Smits wrote:
> Hi Scott,
>
> Thanks for the pointer!
>
> Unfortunately, I am a total groovy-newbie....
>
> Would
> selectedExperiences = parameter.selectedExperiences;
> if (selectedExperiences==""){
> experienceItemList = delegator.findByAnd("ProfileExperience",
> [profileOwnerId : profileOwnerId]);
> }
> else{
> experienceItemList = delegator.findList("ProfileExperience",
> [experienceId : selectedExperiences]);
>
> }
>
> do the trick?
>
> Regards,
>
> Pierre
>
>
> 2010/8/20 Scott Gray <sc...@hotwaxmedia.com>
>
>> Hi Pierre,
>>
>> You'll want to use delegator.findList(...) with an EntityOperator.IN
>> condition for the experience field.
>>
>> Regards
>> Scott
>>
>> HotWax Media
>> http://www.hotwaxmedia.com
>>
>> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
>>
>>> In a url I pass following parameters:
>>>
>>> ?profile=10000&experience=10000,100010
>>>
>>> In a groovy file I get the parameters....
>>> parameter.profile
>>> parameter.experience
>>>
>>> My question is: how do I get the delegator to find entities in the
>> database
>>> based on both parameter.profile and parameter.experience?
>>>
>>> In all the other codes in groovy files that I see it seems that
>> parameters
>>> have only 1 value... Or I might be overlooking one...
>>>
>>> Regards,,
>>>
>>> Pierre
>>
>>
Re: Groovy question regarding passing html parameters
Posted by Pierre Smits <pi...@gmail.com>.
Hi Scott,
Thanks for the pointer!
Unfortunately, I am a total groovy-newbie....
Would
selectedExperiences = parameter.selectedExperiences;
if (selectedExperiences==""){
experienceItemList = delegator.findByAnd("ProfileExperience",
[profileOwnerId : profileOwnerId]);
}
else{
experienceItemList = delegator.findList("ProfileExperience",
[experienceId : selectedExperiences]);
}
do the trick?
Regards,
Pierre
2010/8/20 Scott Gray <sc...@hotwaxmedia.com>
> Hi Pierre,
>
> You'll want to use delegator.findList(...) with an EntityOperator.IN
> condition for the experience field.
>
> Regards
> Scott
>
> HotWax Media
> http://www.hotwaxmedia.com
>
> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
>
> > In a url I pass following parameters:
> >
> > ?profile=10000&experience=10000,100010
> >
> > In a groovy file I get the parameters....
> > parameter.profile
> > parameter.experience
> >
> > My question is: how do I get the delegator to find entities in the
> database
> > based on both parameter.profile and parameter.experience?
> >
> > In all the other codes in groovy files that I see it seems that
> parameters
> > have only 1 value... Or I might be overlooking one...
> >
> > Regards,,
> >
> > Pierre
>
>
Re: Groovy question regarding passing html parameters
Posted by Michał Cukierman <mc...@partbook.eu>.
Hi Scott,
Thats why I started with: "Maybe I am wrong".
The situation you describing is ok, when both parameters exists in one
table. The question is not clear in that case, thats why we
misunderstood each other. I was thinking about getting some sort of
objects from related objects, based on two parameters.
Sorry for my criticism, but I am stil confused about some limitations in
Ofbiz persistence Layer (which is in fact graet - but limited). Today I
get "initial" Product data I will put into ofbiz. It's around 400 000
ProductCategories + a lot of criterias and extended model. So at the
moment, optimalization is my key point.
Regards,
Michał
Dnia 2010-08-21, sob o godzinie 11:41 +1200, Scott Gray pisze:
> Hi Michal,
>
> To be honest I'm not really sure what you're talking about?
>
> I was simply suggesting the Pierre could do the following for his query:
> condList = []
> condList.add(EntityCondition.makeCondition("profileOwnerId", profileOwnerId))
> if (selectedExperiences) {
> condList.add(EntityCondition.makeCondition("experienceId", EntityOperator.IN, selectedExperiences as List)
> }
> cond = EntityCondition.makeCondition(condList);
> results = delegator.findList("ProfileExperience", condList, null, null, null, false);
>
> Which should result in the following query (assuming selectedExperiences has content):
> SELECT * FROM PROFILE_EXPERIENCE WHERE PROFILE_ID = ? AND EXPERIENCE_ID IN (?)
> Are you saying there is some sort of problem with this type of query?
>
> Regards
> Scott
>
> On 21/08/2010, at 1:58 AM, Michał Cukierman wrote:
>
> > Scott,
> >
> > Maybe I am wrong but ... EntityOperator.IN is used to filter objects
> > that you already have. From the developer point of view it's very bad
> > practice.
> >
> > For example:
> > 1) You need to query for 1000 products
> > 2) You use EntityOperator and do a second query to "filter" those, just
> > to get ,lets say, 10 products as a result.
> >
> > You can do it within a single query (not two of them), and you can fetch
> > just 10 objects from a database not 1010.
> >
> > It's complitely OK If you already have objects passed after
> > EntityOperator.IN in a java collection, but in this case:
> > You need to do it specialy for creating second DB call.
> >
> > There should be a method for doing sth like:
> > EntityCondition.makeCondition("shipmentId", EntityOperator.IN,
> > CustomWhereCondition).
> > There should be extended methods for making joins.
> > As long as those do not exist - we should at least try use PROPER SQL
> > calls.
> >
> >> From my perspective, Ofbiz is much more limited 'cause of such code.
> >
> > Regards,
> > Michał
> >
> >
> >
> > Dnia 2010-08-20, pią o godzinie 23:27 +1200, Scott Gray pisze:
> >> Hi Pierre,
> >>
> >> You'll want to use delegator.findList(...) with an EntityOperator.IN condition for the experience field.
> >>
> >> Regards
> >> Scott
> >>
> >> HotWax Media
> >> http://www.hotwaxmedia.com
> >>
> >> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
> >>
> >>> In a url I pass following parameters:
> >>>
> >>> ?profile=10000&experience=10000,100010
> >>>
> >>> In a groovy file I get the parameters....
> >>> parameter.profile
> >>> parameter.experience
> >>>
> >>> My question is: how do I get the delegator to find entities in the database
> >>> based on both parameter.profile and parameter.experience?
> >>>
> >>> In all the other codes in groovy files that I see it seems that parameters
> >>> have only 1 value... Or I might be overlooking one...
> >>>
> >>> Regards,,
> >>>
> >>> Pierre
> >>
> >
>
Re: Groovy question regarding passing html parameters
Posted by Scott Gray <sc...@hotwaxmedia.com>.
Hi Michal,
To be honest I'm not really sure what you're talking about?
I was simply suggesting the Pierre could do the following for his query:
condList = []
condList.add(EntityCondition.makeCondition("profileOwnerId", profileOwnerId))
if (selectedExperiences) {
condList.add(EntityCondition.makeCondition("experienceId", EntityOperator.IN, selectedExperiences as List)
}
cond = EntityCondition.makeCondition(condList);
results = delegator.findList("ProfileExperience", condList, null, null, null, false);
Which should result in the following query (assuming selectedExperiences has content):
SELECT * FROM PROFILE_EXPERIENCE WHERE PROFILE_ID = ? AND EXPERIENCE_ID IN (?)
Are you saying there is some sort of problem with this type of query?
Regards
Scott
On 21/08/2010, at 1:58 AM, Michał Cukierman wrote:
> Scott,
>
> Maybe I am wrong but ... EntityOperator.IN is used to filter objects
> that you already have. From the developer point of view it's very bad
> practice.
>
> For example:
> 1) You need to query for 1000 products
> 2) You use EntityOperator and do a second query to "filter" those, just
> to get ,lets say, 10 products as a result.
>
> You can do it within a single query (not two of them), and you can fetch
> just 10 objects from a database not 1010.
>
> It's complitely OK If you already have objects passed after
> EntityOperator.IN in a java collection, but in this case:
> You need to do it specialy for creating second DB call.
>
> There should be a method for doing sth like:
> EntityCondition.makeCondition("shipmentId", EntityOperator.IN,
> CustomWhereCondition).
> There should be extended methods for making joins.
> As long as those do not exist - we should at least try use PROPER SQL
> calls.
>
>> From my perspective, Ofbiz is much more limited 'cause of such code.
>
> Regards,
> Michał
>
>
>
> Dnia 2010-08-20, pią o godzinie 23:27 +1200, Scott Gray pisze:
>> Hi Pierre,
>>
>> You'll want to use delegator.findList(...) with an EntityOperator.IN condition for the experience field.
>>
>> Regards
>> Scott
>>
>> HotWax Media
>> http://www.hotwaxmedia.com
>>
>> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
>>
>>> In a url I pass following parameters:
>>>
>>> ?profile=10000&experience=10000,100010
>>>
>>> In a groovy file I get the parameters....
>>> parameter.profile
>>> parameter.experience
>>>
>>> My question is: how do I get the delegator to find entities in the database
>>> based on both parameter.profile and parameter.experience?
>>>
>>> In all the other codes in groovy files that I see it seems that parameters
>>> have only 1 value... Or I might be overlooking one...
>>>
>>> Regards,,
>>>
>>> Pierre
>>
>
Re: Groovy question regarding passing html parameters
Posted by James McGill <ja...@ableengineering.com>.
2010/8/20 Michał Cukierman <mc...@partbook.eu>
>
> There should be a method for doing sth like:
> EntityCondition.makeCondition("shipmentId", EntityOperator.IN,
> CustomWhereCondition).
> There should be extended methods for making joins.
> As long as those do not exist - we should at least try use P
>
"IN" (and "NOT IN") conditions should be definable on view entities. The
XSD defines an "IN" operator for entity-conditions and implies that
entity-conditions are valid in view entities, but I couldn't get this to
work. I can't tell how you would represent the right hand side of "IN",
either. There is a TODO comment in the XSD for "NOT IN".
I'm sure the implementation of this becomes rather complicated for all the
different SQL flavors that OFBiz supports, especially when you take it to
the next level, "SELECT" on the right hand side of "IN".
Opentaps has a "Query Tool" to deal with situations where implementing a
query concept is beyond what the entity delegator will do,
in order to support things like JDBC PreparedStatements, "IN" clauses and
subselects.
http://www.opentaps.org/docs/index.php/Using_the_Query_Tool
Notice that this approach was abandoned in favor of Hibernate integration.
With that, I would personally just punt in this situation, get a connection
from the delegator, and deal with the results as a Map. Before I did that,
I'd want to make sure that my assumptions are correct (performance of
subsequent cached queries, cost of traversing an EntityListIterator for
conditions, selecting on a view or DVE, etc.)
--
James McGill
Phoenix AZ
Re: Groovy question regarding passing html parameters
Posted by Michał Cukierman <mc...@partbook.eu>.
Scott,
Maybe I am wrong but ... EntityOperator.IN is used to filter objects
that you already have. From the developer point of view it's very bad
practice.
For example:
1) You need to query for 1000 products
2) You use EntityOperator and do a second query to "filter" those, just
to get ,lets say, 10 products as a result.
You can do it within a single query (not two of them), and you can fetch
just 10 objects from a database not 1010.
It's complitely OK If you already have objects passed after
EntityOperator.IN in a java collection, but in this case:
You need to do it specialy for creating second DB call.
There should be a method for doing sth like:
EntityCondition.makeCondition("shipmentId", EntityOperator.IN,
CustomWhereCondition).
There should be extended methods for making joins.
As long as those do not exist - we should at least try use PROPER SQL
calls.
>>From my perspective, Ofbiz is much more limited 'cause of such code.
Regards,
Michał
Dnia 2010-08-20, pią o godzinie 23:27 +1200, Scott Gray pisze:
> Hi Pierre,
>
> You'll want to use delegator.findList(...) with an EntityOperator.IN condition for the experience field.
>
> Regards
> Scott
>
> HotWax Media
> http://www.hotwaxmedia.com
>
> On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
>
> > In a url I pass following parameters:
> >
> > ?profile=10000&experience=10000,100010
> >
> > In a groovy file I get the parameters....
> > parameter.profile
> > parameter.experience
> >
> > My question is: how do I get the delegator to find entities in the database
> > based on both parameter.profile and parameter.experience?
> >
> > In all the other codes in groovy files that I see it seems that parameters
> > have only 1 value... Or I might be overlooking one...
> >
> > Regards,,
> >
> > Pierre
>
Re: Groovy question regarding passing html parameters
Posted by Scott Gray <sc...@hotwaxmedia.com>.
Hi Pierre,
You'll want to use delegator.findList(...) with an EntityOperator.IN condition for the experience field.
Regards
Scott
HotWax Media
http://www.hotwaxmedia.com
On 20/08/2010, at 10:31 PM, Pierre Smits wrote:
> In a url I pass following parameters:
>
> ?profile=10000&experience=10000,100010
>
> In a groovy file I get the parameters....
> parameter.profile
> parameter.experience
>
> My question is: how do I get the delegator to find entities in the database
> based on both parameter.profile and parameter.experience?
>
> In all the other codes in groovy files that I see it seems that parameters
> have only 1 value... Or I might be overlooking one...
>
> Regards,,
>
> Pierre
Re: Groovy question regarding passing html parameters
Posted by Jacques Le Roux <ja...@les7arts.com>.
BTW I leanrt something reading this article:
http://www.w3.org/TR/1999/REC-html401-19991224/appendix/notes.html#h-B.2.2
Too bad, ";" does not seem to be widely supported :/
Jacques
Jacques Le Roux wrote:
> http://en.wikipedia.org/wiki/Query_string
>
> Jacques
>
> Pierre Smits wrote:
>> In a url I pass following parameters:
>>
>> ?profile=10000&experience=10000,100010
>>
>> In a groovy file I get the parameters....
>> parameter.profile
>> parameter.experience
>>
>> My question is: how do I get the delegator to find entities in the database
>> based on both parameter.profile and parameter.experience?
>>
>> In all the other codes in groovy files that I see it seems that parameters
>> have only 1 value... Or I might be overlooking one...
>>
>> Regards,,
>>
>> Pierre
Re: Groovy question regarding passing html parameters
Posted by Jacques Le Roux <ja...@les7arts.com>.
http://en.wikipedia.org/wiki/Query_string
Jacques
Pierre Smits wrote:
> In a url I pass following parameters:
>
> ?profile=10000&experience=10000,100010
>
> In a groovy file I get the parameters....
> parameter.profile
> parameter.experience
>
> My question is: how do I get the delegator to find entities in the database
> based on both parameter.profile and parameter.experience?
>
> In all the other codes in groovy files that I see it seems that parameters
> have only 1 value... Or I might be overlooking one...
>
> Regards,,
>
> Pierre