advanced search

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

advanced search

koenvdk
Hello,

In the form runner persistence search api, I see exact and partial text searches, but is it also possible to do a little more advanced query?
For example: get all form submissions made since a certain date. This should not be too difficult to do because all submissions have such a date, but is the REST api able to handle it?

(by the way, I'm still waiting for an answer to my mysql scaling badly question, thx! )

Sincerely,



Koen Vanderkimpen

Connect: Twitter

[hidden email]








Overeenkomstig de bepalingen inzake de vertegenwoordiging van de vzw in haar statuten, kan enkel de gedelegeerde bestuurder, de algemeen directeur of zijn uitdrukkelijke lasthebber verbintenissen aangaan namens Smals.
Indien dit bericht niet voor u bestemd is, verzoeken wij u dit onmiddellijk aan ons te melden en het bericht te vernietigen.

Conformément aux dispositions relatives à la représentation de l'asbl dans ses statuts, seul l'administrateur délégué, le directeur général ou son mandataire exprès est habilité à souscrire des engagements au nom de Smals.
Si ce message ne vous est pas destiné, nous vous prions de nous le signaler immédiatement et de détruire le message.

According to the provisions regarding representation of the non profit association in its bylaws, only the chief executive officer, the general manager or his explicit agent can enter into engagements on behalf of Smals.
If you are not the addressee of this message, we kindly ask you to signal this to us immediately and to delete the message.





--
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
OW2 mailing lists service home page: http://www.ow2.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: advanced search

Erik Bruchez
Administrator
Koen,

Currently that kind of searches are not possible. The API should be able to handle it because the API supports match="exact|substring". Some other operation could be put there, such as greater/lower. Or, another attribute could be added.

It might not be terribly complicated, but if we implement this we have to support eXist, MySQL, and Oracle. So that's probably not something we'll do for 4.0. But if you wish to help that's great ;)

-Erik

On Wed, May 23, 2012 at 6:54 AM, <[hidden email]> wrote:
Hello,

In the form runner persistence search api, I see exact and partial text searches, but is it also possible to do a little more advanced query?
For example: get all form submissions made since a certain date. This should not be too difficult to do because all submissions have such a date, but is the REST api able to handle it?

(by the way, I'm still waiting for an answer to my mysql scaling badly question, thx! )

Sincerely,



Koen Vanderkimpen

Connect: Twitter

[hidden email]








Overeenkomstig de bepalingen inzake de vertegenwoordiging van de vzw in haar statuten, kan enkel de gedelegeerde bestuurder, de algemeen directeur of zijn uitdrukkelijke lasthebber verbintenissen aangaan namens Smals.
Indien dit bericht niet voor u bestemd is, verzoeken wij u dit onmiddellijk aan ons te melden en het bericht te vernietigen.

Conformément aux dispositions relatives à la représentation de l'asbl dans ses statuts, seul l'administrateur délégué, le directeur général ou son mandataire exprès est habilité à souscrire des engagements au nom de Smals.
Si ce message ne vous est pas destiné, nous vous prions de nous le signaler immédiatement et de détruire le message.

According to the provisions regarding representation of the non profit association in its bylaws, only the chief executive officer, the general manager or his explicit agent can enter into engagements on behalf of Smals.
If you are not the addressee of this message, we kindly ask you to signal this to us immediately and to delete the message.






--
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
OW2 mailing lists service home page: http://www.ow2.org/wws
DL
Reply | Threaded
Open this post in threaded view
|

Re: advanced search

DL
This post was updated on .
I'm interested in following the answers to this question since this is a step I will soon have to take .. advanced searching through large populations of xforms submissions.

Is this a case for migrating to an external eXist database to use the more advanced XQuery functions provided by eXist-db API?

http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/persistence-api

[Later Edit]

See conditionals in XQuery syntax ..

http://www.w3schools.com/xquery/xquery_syntax.asp






Reply | Threaded
Open this post in threaded view
|

Re: Re: advanced search

Erik Bruchez
Administrator
That's orthogonal. For any production deployment you should setup an
external database.

But improved search could work on the embedded database as well.

-Erik

On Thu, May 24, 2012 at 3:54 AM, DL <[hidden email]> wrote:

> I'm interested in following the answers to this question since this is a step
> I will soon have to take .. advanced searching through large populations of
> xforms submissions.
>
> Is this a case for migrating to an external eXist database and use the more
> advanced XQuery functions provided by eXist-db API?
>
> http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/persistence-api
>
>
>
>
>
>
>
> --
> View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/advanced-search-tp4651624p4652826.html
> Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.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
> OW2 mailing lists service home page: http://www.ow2.org/wws
>


--
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
OW2 mailing lists service home page: http://www.ow2.org/wws