Orbeon Forms community mailing list

Help, delete or not delete ?

Classic

List

Threaded

10 messages Options

vivanno

Apr 07, 2016; 2:08pm

Help, delete or not delete ?

Hi,

I use Orbeon with MySQL. I'm writing a persistence API implementation. I have observed when i delete a form from builder, the form is already send by :

http://X.X.X.X:8080/orbeon/fr/service/persistence/form/app-name

... and data are still present in mysql database.

What's wrong ?

Thanks
Vivien

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].

bruno.buzzi

Apr 07, 2016; 3:25pm

Re: Help, delete or not delete ?

CONTENTS DELETED

The author has deleted this message.

vivanno

Apr 08, 2016; 8:44am

Re: Help, delete or not delete ?

Hello,

thanks, you right. But i don't understand why the /orbeon/fr/service/persistence/form/app-name webservice returns deleted forms.

How to get list of forms without deleted?

regards,

Vivien

Le jeudi 7 avril 2016 17:56:34 UTC+2, bruno.buzzi a écrit :

Hi,

The delete is a logical delete i think. Check for "deleted" column
(orbeon_form_data).
There is no physical delete for audit purpose.

When a form is published is saved in orbeon_form_definition and is never
deleted.

Regards,
bruno

--
View this message in context: <a href="http://discuss.orbeon.com/Help-delete-or-not-delete-tp4661373p4661374.html" target="_blank" rel="nofollow" onmousedown="this.href='http://www.google.com/url?q\75http%3A%2F%2Fdiscuss.orbeon.com%2FHelp-delete-or-not-delete-tp4661373p4661374.html\46sa\75D\46sntz\0751\46usg\75AFQjCNGUExU2keNFBamCtqRtEajf_ATZwA';return true;" onclick="this.href='http://www.google.com/url?q\75http%3A%2F%2Fdiscuss.orbeon.com%2FHelp-delete-or-not-delete-tp4661373p4661374.html\46sa\75D\46sntz\0751\46usg\75AFQjCNGUExU2keNFBamCtqRtEajf_ATZwA';return true;">http://discuss.orbeon.com/Help-delete-or-not-delete-tp4661373p4661374.html
Sent from the Orbeon Forms community mailing list mailing list archive at Nabble.com.

... [show rest of quote]

vivanno

Apr 11, 2016; 6:40am

Re: Help, delete or not delete ?

Nobody know how to get list of published forms (without deleted) ?

Regards,

Vivien

Le vendredi 8 avril 2016 11:15:48 UTC+2, Katsu Don a écrit :

Hello,
thanks, you right. But i don't understand why the /orbeon/fr/service/persistence/form/app-name webservice returns deleted forms.

How to get list of forms without deleted?

regards,
Vivien

Le jeudi 7 avril 2016 17:56:34 UTC+2, bruno.buzzi a écrit :
Hi,

The delete is a logical delete i think. Check for "deleted" column
(orbeon_form_data).
There is no physical delete for audit purpose.

When a form is published is saved in orbeon_form_definition and is never
deleted.

Regards,
bruno

--
View this message in context: <a href="http://discuss.orbeon.com/Help-delete-or-not-delete-tp4661373p4661374.html" rel="nofollow" target="_blank" onmousedown="this.href='http://www.google.com/url?q\75http%3A%2F%2Fdiscuss.orbeon.com%2FHelp-delete-or-not-delete-tp4661373p4661374.html\46sa\75D\46sntz\0751\46usg\75AFQjCNGUExU2keNFBamCtqRtEajf_ATZwA';return true;" onclick="this.href='http://www.google.com/url?q\75http%3A%2F%2Fdiscuss.orbeon.com%2FHelp-delete-or-not-delete-tp4661373p4661374.html\46sa\75D\46sntz\0751\46usg\75AFQjCNGUExU2keNFBamCtqRtEajf_ATZwA';return true;">http://discuss.orbeon.com/Help-delete-or-not-delete-tp4661373p4661374.html
Sent from the Orbeon Forms community mailing list mailing list archive at Nabble.com.
... [show rest of quote]

... [show rest of quote]

Alessandro Vernet

Apr 11, 2016; 3:52pm

Re: Help, delete or not delete ?

Administrator

Hi Vivien,

Two things about this:

1. In your database, Orbeon Forms has the data for forms you're editing with Form Builder *and* published forms. Publishing in Form Builder creates a published form (obviously), but deleting from Form Builder doesn't delete the published form. For that, you need to go to the Form Runner home page as an admin, and use the unpublish functionality. For more on this, see:

http://doc.orbeon.com/form-runner/feature/home-page.html

2. Both for forms you're editing in Form Builder, and published forms, deleting anything doesn't delete rows in the database, but the API doesn't return deleted data.

Does this make more sense?

Alex

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

vivanno

Apr 12, 2016; 10:22am

Re: Help, delete or not delete ?

Thanks Alex.

Yes it make more sense. But i have trouble. I modified form-builder-permissions.xml and add : <role name="*" app="*" form="*"/>

Now all users can publish and unpublish. But when i unpublish a form, it still appears in the response of :

http://{{orbeon-ip}}:8080/orbeon/fr/service/persistence/form/{{fr-app}}

i'm sorry but i don't understand why. What's wrong ?

Note : I need to finish quickly my poc before buy licences.

Le lundi 11 avril 2016 18:24:31 UTC+2, Alessandro Vernet a écrit :

Hi Vivien,

Two things about this:

1. In your database, Orbeon Forms has the data for forms you're editing with
Form Builder *and* published forms. Publishing in Form Builder creates a
published form (obviously), but deleting from Form Builder doesn't delete
the published form. For that, you need to go to the Form Runner home page as
an admin, and use the unpublish functionality. For more on this, see:

<a href="http://doc.orbeon.com/form-runner/feature/home-page.html" target="_blank" rel="nofollow" onmousedown="this.href='http://www.google.com/url?q\75http%3A%2F%2Fdoc.orbeon.com%2Fform-runner%2Ffeature%2Fhome-page.html\46sa\75D\46sntz\0751\46usg\75AFQjCNFgLsTnoeFmevfSYfLk6_lHx0XRCQ';return true;" onclick="this.href='http://www.google.com/url?q\75http%3A%2F%2Fdoc.orbeon.com%2Fform-runner%2Ffeature%2Fhome-page.html\46sa\75D\46sntz\0751\46usg\75AFQjCNFgLsTnoeFmevfSYfLk6_lHx0XRCQ';return true;">http://doc.orbeon.com/form-runner/feature/home-page.html

2. Both for forms you're editing in Form Builder, and published forms,
deleting anything doesn't delete rows in the database, but the API doesn't
return deleted data.

Does this make more sense?

Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
View this message in context: <a href="http://discuss.orbeon.com/Help-delete-or-not-delete-tp4661373p4661388.html" target="_blank" rel="nofollow" onmousedown="this.href='http://www.google.com/url?q\75http%3A%2F%2Fdiscuss.orbeon.com%2FHelp-delete-or-not-delete-tp4661373p4661388.html\46sa\75D\46sntz\0751\46usg\75AFQjCNGB_f8xW0xADm6PZLawJHVHriTSYw';return true;" onclick="this.href='http://www.google.com/url?q\75http%3A%2F%2Fdiscuss.orbeon.com%2FHelp-delete-or-not-delete-tp4661373p4661388.html\46sa\75D\46sntz\0751\46usg\75AFQjCNGB_f8xW0xADm6PZLawJHVHriTSYw';return true;">http://discuss.orbeon.com/Help-delete-or-not-delete-tp4661373p4661388.html
Sent from the Orbeon Forms community mailing list mailing list archive at Nabble.com.

... [show rest of quote]

bruno.buzzi

Apr 12, 2016; 1:52pm

Re: Help, delete or not delete ?

CONTENTS DELETED

The author has deleted this message.

vivanno

Apr 12, 2016; 2:18pm

Re: Help, delete or not delete ?

Thanks Bruno!

During to prepare my answer to you ... i saw :

<?xml version="1.0" encoding="utf-8"?>

<forms>

<application-name>app</application-name>

<form-name>form</form-name>

<title xml:lang="en">Title</title>

<singleton>false</singleton>

<available>false</available>

<last-modified-time>2016-04-12T14:42:21.238Z</last-modified-time>

</form>

</forms>

Le mardi 12 avril 2016 16:24:42 UTC+2, bruno.buzzi a écrit :

Hi,

Can you put a step by step of what you are doing ?

For example:
1- Goto .../orbeon/fr (expected result: show all forms definitions to
publish or unpublish)
2- Unpublish a Form (expected result: change the state of the form)
3- Goto .../orbeon/fr/orbeon/builder/summary (expected result: show all save
forms)
4-....

Because i do not have the whole picture of your problem...

Regards,
Bruno

--
View this message in context: <a href="http://discuss.orbeon.com/Help-delete-or-not-delete-tp4661373p4661392.html" target="_blank" rel="nofollow" onmousedown="this.href='http://www.google.com/url?q\75http%3A%2F%2Fdiscuss.orbeon.com%2FHelp-delete-or-not-delete-tp4661373p4661392.html\46sa\75D\46sntz\0751\46usg\75AFQjCNFgpNpwg5xi53nR5ONA8b_nl7qPWQ';return true;" onclick="this.href='http://www.google.com/url?q\75http%3A%2F%2Fdiscuss.orbeon.com%2FHelp-delete-or-not-delete-tp4661373p4661392.html\46sa\75D\46sntz\0751\46usg\75AFQjCNFgpNpwg5xi53nR5ONA8b_nl7qPWQ';return true;">http://discuss.orbeon.com/Help-delete-or-not-delete-tp4661373p4661392.html
Sent from the Orbeon Forms community mailing list mailing list archive at Nabble.com.

... [show rest of quote]

Alessandro Vernet

Apr 12, 2016; 4:03pm

Re: Help, delete or not delete ?

Administrator

Hi Vivien,

Yes, it's a bit tricky isn't it? Unpublishing from the Form Runner Home Page, isn't the same as deleting. When a form is "unpublished", it becomes "unavailable". So it's still returned by the search API, as, obviously, the Form Runner Home Page still wants to show "unavailable" forms, so admins can re-publish them to make them available again.

Alex

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

vivanno

Apr 13, 2016; 9:27am

Re: Help, delete or not delete ?

When we know it. It is logic. :)

Thanks Alex for your help.

Le mardi 12 avril 2016 18:35:13 UTC+2, Alessandro Vernet a écrit :

Hi Vivien,

Yes, it's a bit tricky isn't it? Unpublishing from the Form Runner Home
Page, isn't the same as deleting. When a form is "unpublished", it becomes
"unavailable". So it's still returned by the search API, as, obviously, the
Form Runner Home Page still wants to show "unavailable" forms, so admins can
re-publish them to make them available again.

Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
View this message in context: <a href="http://discuss.orbeon.com/Help-delete-or-not-delete-tp4661373p4661396.html" target="_blank" rel="nofollow" onmousedown="this.href='http://www.google.com/url?q\75http%3A%2F%2Fdiscuss.orbeon.com%2FHelp-delete-or-not-delete-tp4661373p4661396.html\46sa\75D\46sntz\0751\46usg\75AFQjCNEgNjoPhtr8gmuUyXK4uiVyz29gfw';return true;" onclick="this.href='http://www.google.com/url?q\75http%3A%2F%2Fdiscuss.orbeon.com%2FHelp-delete-or-not-delete-tp4661373p4661396.html\46sa\75D\46sntz\0751\46usg\75AFQjCNEgNjoPhtr8gmuUyXK4uiVyz29gfw';return true;">http://discuss.orbeon.com/Help-delete-or-not-delete-tp4661373p4661396.html
Sent from the Orbeon Forms community mailing list mailing list archive at Nabble.com.

... [show rest of quote]