Referencing several documents in sql:
Locked
 
|
Hi,
I need to update a db record with data from more than 2 documents. For two documents, I used the identity processor in combination with the aggregate() function. But now that I need to use 3 docs I am not sure what would be the best approach. My Qs are: * Can aggregate work with more than 2 docs? * Is there a way to input into a processor more than 1 input? * Best approach to my issue? Thanks, Assaf -- You receive this message as a subscriber of the [hidden email] mailing list. To unsubscribe: mailto:[hidden email] For general help: mailto:[hidden email]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws |
Re: Referencing several documents in sql:
|
|
Assaf, Aggregate() works on "N" number of documents, so yes, you can aggregate your third document. The xslt processor allows you to have user defined inputs, which are available to you in your xslt template through xpath doc('input:my-input') and doc('input:data')/my-xpath , http://www.orbeon.com/ops/doc/processors-xslt#user-defined Most pipelines don't have variable number of inputs, so aggregate() is a good way to pass all the data through. --Hank Goleta, CA Quoting [hidden email]: > Hi, > > I need to update a db record with data from more than 2 documents. For two > documents, I used the identity processor in combination with the aggregate() > function. But now that I need to use 3 docs I am not sure what would be the > best approach. My Qs are: > > * Can aggregate work with more than 2 docs? > * Is there a way to input into a processor more than 1 input? > * Best approach to my issue? > > Thanks, > > Assaf > > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. -- You receive this message as a subscriber of the [hidden email] mailing list. To unsubscribe: mailto:[hidden email] For general help: mailto:[hidden email]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws |
Re: Referencing several documents in sql:
|
Administrator
|
In reply to this post by assafn
[hidden email] wrote:
> Hi, > > I need to update a db record with data from more than 2 documents. For two documents, I used the identity processor in combination with the aggregate() function. But now that I need to use 3 docs I am not sure what would be the best approach. My Qs are: > > * Can aggregate work with more than 2 docs? Yes. > * Is there a way to input into a processor more than 1 input? Some processors support custom inputs, but I don't think the SQL processor was updated to support that. > * Best approach to my issue? You can use aggregate(), and BTW you can do this directly on the "data" input of the SQL processor (no need to use the identity processor for that, but I guess it depends where you want to do the aggregation). Aggregation should be ok in your case, although it is not optimal performance-wise. Custom inputs would be more optimal and more correct, but some work would have to be done to make those work. -Erik -- Orbeon - XForms Everywhere: http://www.orbeon.com/blog/ -- You receive this message as a subscriber of the [hidden email] mailing list. To unsubscribe: mailto:[hidden email] For general help: mailto:[hidden email]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws |
|
|
thanks. it worked fine with aggregate on the identity
processor. I might consider to move the aggregate() to the sql. If we end up using OPS after our pilot, I will be happy to divert some man-power to contribute back. In the meanwhile, thanks to all who are supporting us now! Assaf --- Erik Bruchez <[hidden email]> wrote: > [hidden email] wrote: > > Hi, > > > > I need to update a db record with data from more > than 2 documents. For two documents, I used the > identity processor in combination with the > aggregate() function. But now that I need to use 3 > docs I am not sure what would be the best approach. > My Qs are: > > > > * Can aggregate work with more than 2 docs? > > Yes. > > > * Is there a way to input into a processor more > than 1 input? > > Some processors support custom inputs, but I don't > think the SQL > processor was updated to support that. > > > * Best approach to my issue? > > You can use aggregate(), and BTW you can do this > directly on the "data" > input of the SQL processor (no need to use the > identity processor for > that, but I guess it depends where you want to do > the aggregation). > > Aggregation should be ok in your case, although it > is not optimal > performance-wise. Custom inputs would be more > optimal and more correct, > but some work would have to be done to make those > work. > > -Erik > > -- > Orbeon - XForms Everywhere: > http://www.orbeon.com/blog/ > > > > -- > You receive this message as a subscriber of the > [hidden email] mailing list. > To unsubscribe: > mailto:[hidden email] > For general help: > mailto:[hidden email]?subject=help > ObjectWeb mailing lists service home page: > http://www.objectweb.org/wws > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- You receive this message as a subscriber of the [hidden email] mailing list. To unsubscribe: mailto:[hidden email] For general help: mailto:[hidden email]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws |
Re: Referencing several documents in sql:
|
Administrator
|
Assaf,
Great, and we do hope you end up using OPS! Keep in mind for your evaluation that OPS 3.1 (I should say 3.x as we haven't officially determined the release name) should come up hopefully by the end of August, with a quite large number of enhancements mainly related to XForms (features, performance, and ease of use). -Erik Assaf wrote: > thanks. it worked fine with aggregate on the identity > processor. I might consider to move the aggregate() to > the sql. > > If we end up using OPS after our pilot, I will be > happy to divert some man-power to contribute back. In > the meanwhile, thanks to all who are supporting us > now! > > Assaf > > --- Erik Bruchez <[hidden email]> wrote: > >> [hidden email] wrote: >>> Hi, >>> >>> I need to update a db record with data from more >> than 2 documents. For two documents, I used the >> identity processor in combination with the >> aggregate() function. But now that I need to use 3 >> docs I am not sure what would be the best approach. >> My Qs are: >>> * Can aggregate work with more than 2 docs? >> Yes. >> >>> * Is there a way to input into a processor more >> than 1 input? >> >> Some processors support custom inputs, but I don't >> think the SQL >> processor was updated to support that. >> >>> * Best approach to my issue? >> You can use aggregate(), and BTW you can do this >> directly on the "data" >> input of the SQL processor (no need to use the >> identity processor for >> that, but I guess it depends where you want to do >> the aggregation). >> >> Aggregation should be ok in your case, although it >> is not optimal >> performance-wise. Custom inputs would be more >> optimal and more correct, >> but some work would have to be done to make those >> work. >> >> -Erik >> >> -- >> Orbeon - XForms Everywhere: >> http://www.orbeon.com/blog/ >> >> -- >> You receive this message as a subscriber of the >> [hidden email] mailing list. >> To unsubscribe: >> mailto:[hidden email] >> For general help: >> mailto:[hidden email]?subject=help >> ObjectWeb mailing lists service home page: >> http://www.objectweb.org/wws >> > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > > > ------------------------------------------------------------------------ > > > -- > You receive this message as a subscriber of the [hidden email] mailing list. > To unsubscribe: mailto:[hidden email] > For general help: mailto:[hidden email]?subject=help > ObjectWeb mailing lists service home page: http://www.objectweb.org/wws -- Orbeon - XForms Everywhere: http://www.orbeon.com/blog/ -- You receive this message as a subscriber of the [hidden email] mailing list. To unsubscribe: mailto:[hidden email] For general help: mailto:[hidden email]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws |
«
Return to Orbeon Forms community mailing list
|
1 view|%1 views
| Free forum by Nabble | Edit this page |