Permissions and Summary with large quantity of forms

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

Permissions and Summary with large quantity of forms

bruno.buzzi
Alex/Erik,

Example (this is a border case i think):
* Permissions are enbaled
* The form definition has 200.000 instances and each form instance belong to a different user ;)

To generate the Summary for a particular user:
Do you have to read all rows in orbeon_form_data ? (of course filtering by app and form)

I mean after apply the filter by app and form then do you have to read 200.000 instances ? (to know which form to show)

regards
bruno



Reply | Threaded
Open this post in threaded view
|

Re: Permissions and Summary with large quantity of forms

Alessandro  Vernet
Administrator
Hi Bruno,

Assuming you setup your permissions so each users can only access their own data, then each user will only see one row in the summary page. With the built-in relational persistence layer the query will be very fast as it uses the permissions to generate SQL that tests on the value in the `username`column match the current user. (And something similar is done with eXist.) Does this make sense?

Alex
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: Permissions and Summary with large quantity of forms

bruno.buzzi
Alex,

Yes you are right. i get confused with the form definition where the permissions are on the XML.

But is only a query using 'username' and 'group'.

The same goes to GemStone/S, a query to a collection using 'username' instance variable.
With an index it will a very fast query :)

regards
bruno
Reply | Threaded
Open this post in threaded view
|

Re: Permissions and Summary with large quantity of forms

Alessandro  Vernet
Administrator
Hi Bruno,

Perfect then! And all permissions, including the new organization-base permissions, are designed so the search can be performed efficiently, using indexes, without having to go through documents (or only those that will be returned by the search, to extract values shown on the summary page).

Alex
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: Permissions and Summary with large quantity of forms

bruno.buzzi
Alex,

"organization-base permissions" are only used if you integrate Orbeon with Liferay ?

regards,
bruno
Reply | Threaded
Open this post in threaded view
|

Re: Permissions and Summary with large quantity of forms

Alessandro  Vernet
Administrator
Hi Bruno,

Organization-based permissions are supported with anything you want. It relies on you setting a header to tell Orbeon Forms about the user, the organizations she is in, and the her organization roles. You can look at this as an extension to the current header-based permissions.

And we have a special integration for Liferay that sets this header for you, based on users and organizations defined in Liferay, which makes it really simple for those who use Liferay. But you can set the header yourself, or at least you will once we have documentation for this :).

Alex
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet