get data from process variable using P_request

[r...@dynamo.net]

Hi, Ive been trying to get data from a process using p_request as the key to get other data. In a WI using an autocomplete widget, and serching for the p_request number of other WI, then getting the value of an other variable in that request. Is there a way to dynamically generate a collection with all process variables data(both future and past)?

Dont know if there is an easier way to do this using WI reports, but I havent been able to filter those reports with the user input from the new WI.

Any help will be appreciated.

Best

[Bidisha Das]

Hi,

You can use connectors available in RunMyProcess-Secured Connection in process to dynamically generate collection and save objects into it. For eg: "Create an item into a collection [c]" is one of the Connectors.There are other connectors as well for collection.Please check those out.

Regarding WI report,I could not get what exactly you want?If you want to filter the report using any data from WI, then you need to add the variable of that data in your process Measures tab, so only you can filter the report on basis of that.

Let me know if any further information required.

Thanks & Regards

Bidisha

[RunMyProcess herramienta]

Thanks for the reply. Can those connectors be used to save into a collection from data that has allready been inputed into the aplication prior to this modification?

Regarding the WI report what Im looking at doing is having the end user input a value into the WI. Then use that value as a filter in a report widget in the same WI.  Idealy Id like to be able to query the report and get some data based on filter that was created. I know this can be done with collections so thats why6 I asked for those beforehand.

Best,

  

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to a topic in the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/UfOdM2wkYAQ/unsubscribe.
To unsubscribe from this group and all its topics, 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/CAMGV9zvF_JREBsZtHkNzwdesvLJ%3DtrbMGKt%3D5ps-tU-%2BqT805Q%40mail.gmail.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[Bidisha Das]

Hi,

As far as I can understand from your reply,you don't need to use Connector for that since the end user is manually entering the data from Web Interface and its getting saved into collection.For better undestanding about Collection, please refer to the link: http://docs.runmyprocess.com/Developer_Guide/Collection/

To save into Collection and retrieve them back,you can refer to : http://docs.runmyprocess.com/Developer_Guide/Collection/Collection_JS_Freemarker

For performing query on Collection report,you can refer to : http://docs.runmyprocess.com/User_Guide/Development_Environment/Toolbox/Web_Interfaces/Widget/Report_Widget

For performing filter on a field in WI/Process report,you need to add that particular field variable in the Measures tab of the process which is triggered by that WI.You can then go to the particular report and add filter and search results.So it will generate report based on the filter.

Thanks & Regards

Bidisha

[RunMyProcess herramienta]

Hi, as of right now its not getting saved into a collection. Its getting saved into a spreadsheet. What im trying to do is start a collection from the data in the spreadsheet and keep it updated automatically from that spreadsheet. Thats one thing

The other Route im exploring is getting this information from a WI report. The idea is to use a seprate WI to query the information from the first process based on input given by the user in the new WI. 

Not really sure what would be the best way to go about this.

Best,

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to a topic in the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/UfOdM2wkYAQ/unsubscribe.
To unsubscribe from this group and all its topics, 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/CAMGV9zsr2Vc7s6YYe8o0qQoKXnKVDG7yPh%2BMa7YQwSS%3DDVwi3g%40mail.gmail.com.

[Tejas Laddha]

Hi,

For the first scenario, there is no way to update collection automatically from spreadsheet.

In that case, you can use collection to store the values and simultaneously using connector to update into the spreadsheet.

For the second case, I am not getting your requirement properly. Could you please elaborate it?

 

Thanks and Regards,

Tejas Laddha

You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" 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/CAFc3B8JMxJFPsT%3DYJri_UPwt4njQK77S3RJmtXwgfMD7wCbj-A%40mail.gmail.com.

[RunMyProcess herramienta]

I have one process thats got a measure to store the p_request for the WI, as well as another measure to store another value from that process.. In a new WI a user is going to input the same value for the p-request from the first process. With that number i need to be able to retrieve the value of the second measure from the fisrt process. I was thinking of using WI report on the the second WI to get the values from the first using the input from te user (which is the p_request form the first process) to get the value of the other measure.

Is this clear?

best and thanxs,

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAC4R6%2Bb6SyLcXpRoYTLy1WKzQoHdbyw8j4ZoSBJ_BD5CcfRxEA%40mail.gmail.com.

[Bidisha Das]

Hi,

I couldnot get what exactly you want? Measure is basically used to perform filter on WI/Process report. What I could get is you are storing 2 measures in your process and you want to retrieve one on basis of another using a Web Interface. You can use WI report for this. Go to WI report,add filter on the first measure and add the second measure as column,then search results.It will generate a report based on the measure added to filter and the second measure would be in the columns in report.

I hope you are clear.

Thanks & Regards

Bidisha

[RunMyProcess herramienta]

Hi, what I really need to do is use data that is going to be inputed by a user in a WI to filter a WI report. Is this possible? The other question is can i use the value of one of the columns in the WI report as a measure or variable on an other part of the WI report.

Best,

--

Fujitsu - RunMyProcess
---
You received this message because you are subscribed to a topic in the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/UfOdM2wkYAQ/unsubscribe.
To unsubscribe from this group and all its topics, 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/CAMGV9zsrsQm6s2%3Db5E1WuA%3D%2BJhRcbXUM2fEvCCbsyu9QMk6xew%40mail.gmail.com.