Data management (novice question)

[fbouqu...@gmail.com]

Hello,

I am new to RMP and not very familiar to MongoDB concepts. Therefore I have few questions related to data management before starting my first demo app.

I would like to save all my process data in a database. I first thought that I could do it in RMP collections but I can't find how I can embed array of sub-documents in my collection. Supported type seems to be text, date, number only.

I did not find the way to save data such as:

{
first_name: “Paul”,
surname: “Miller”,
city: “London”,
location: [45.123,47.232],
cars: [
{ model: “Bentley”,
year: 1973,
value: 100000, ….},
{ model: “Rolls Royce”,
year: 1965,
value: 330000, ….},
]
}

- am I correct?
- does it mean that I should use an external database to save my data using the accurate connector?

Other question, if I want to use process variables for report purposes:

- are my process instances archived at some point? I mean, are my process data always available for my reports?


Thank you for your help.

Best regards

Fabien

[Sweta Suman]

Hi,

Query 1 -

You need to create a collection and add objects in it. You can use java script or Free marker to store data in collection.

To create collection GoTo--> Project--> New--> Collection

Refer - http://docs.runmyprocess.com/Developer_Guide/Collection/Collection_JS_Freemarker#add-an-object_1

In order to push data into collection using free marker. Use.Use below code -

<#assign my_object>

{

"first_name":"Paul",

"surname":"Miller",

"city":"London",

"location": [{"latitude":"45.123","longitude":"47.232"}],

"cars": [

{"model": "Bentley","year":"1973","value":"100000"},{"model":"Rolls Royce","year":"1965","value":"330000"}

]

}

</#assign>

${save_object(my_object,"collection_name")}

where my_object is a JSON object.

Query 2 -

Yes, you can get process variable in Reports. You need to add a custom measure in the process "Measures" tab for each variable you want to see in report. In Reports you can select respective column to see all records.

Please refer screenshot for better understanding.

Hope this helps you.

Thanks,

Sweta

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/81208b47-9738-4f3d-9e25-36ccbe55a43c%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

--

Thanks,

Sweta 

Fujitsu RunMyProcess Support

[fbouqu...@gmail.com]

Hello Sweta,

Thank you for your answer.

Query 1:

if I understand correctly, it means that I can embed sub-documents but I can't visualize the data in the collections backoffice as we can only display text, number and date am I right? How do you display the collection when you have nested documents?

Query 2:

my question was more about data management, eg: do you keep process data forever or do you archive them at some point?
Would you recommend as a best practice to save all process variables in a collection?

Best regards

[Pray Desai]

Hi,

1) You cannot visualizae sub-documents from report widget but you can use "Tree Widget" to dsplay/edit hierarchy structure of data. 

Refer : http://docs.runmyprocess.com/User_Guide/Development_Environment/Toolbox/Web_Interfaces/Widget/Tree_Widget

2) It depends on the project mode and your licenses subscription renewal. 

For TEST and ACCEPTANCE mode, we auto delete process data along with the forms after 62 days. 

For LIVE project mode, we keep the process data for ever as long as licenses are renewed every year. Instant access is guaranteed for 2 years after which we may archive it for performance improvements but we donot delete it. We can also make the archived data available upon request. 

No, we donot recommend to save all process variables in a collection just for the sake of backup. 

Regards,

Pray Desai,

Fujitsu RunMyProcess.

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/80aa8a49-cedf-40ea-8d2f-61cd3a0e36ba%40runmyprocess.com.

[fbouqu...@gmail.com]

Hello Pray,

Sorry for the late reply and thank you for the detailed answer. This is exactly what I needed.

Best regards

Fabien