Subselect in report widget

273 views
Skip to first unread message

serc...@gmail.com

unread,
Oct 23, 2013, 9:38:18 AM10/23/13
to suppor...@runmyprocess.com
I wonder if there is any way to make a subselect (such as mySQL) in a report widget

Richard Manga

unread,
Oct 23, 2013, 9:46:05 AM10/23/13
to suppor...@runmyprocess.com
Hi!

Please, can you give more details about what you want to do?

Which data you report widget contains and what do you want to select.

Best regards,

Richard Manga



--
Fujitsu - RunMyProcess
---
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/89913a5f-68e6-4977-9cd7-9783f4933a3f%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/groups/opt_out.

serc...@gmail.com

unread,
Oct 23, 2013, 10:08:43 AM10/23/13
to suppor...@runmyprocess.com
Attached to the tables you want to use and how I would like it to be the result of the report.

Regards.

REPORT.png
TABLAS.png

Richard Manga

unread,
Oct 23, 2013, 10:49:09 AM10/23/13
to suppor...@runmyprocess.com
Hi!

If your data are not dynamic (you make a sql request once to get all the data), you can put them into a collection.
Once you have all your data inside the collection, you can use the widget report to select the data you are interested on.

Regards,

Richard Manga


2013/10/23 <serc...@gmail.com>
Attached to the tables you want to use and how I would like it to be the result of the report.

Regards.
--
Fujitsu - RunMyProcess
---
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/.

serc...@gmail.com

unread,
Oct 23, 2013, 10:58:12 AM10/23/13
to suppor...@runmyprocess.com
the problem is that my data is stored in two collections and not display them together in a report.

In the widget report only gives the option to select a unique collection.

config_report.png

Richard Manga

unread,
Oct 23, 2013, 11:49:55 AM10/23/13
to suppor...@runmyprocess.com
Hi!

You cannot use two collections with the same report widget.

What you can do in this case is to build a dynamic HTML table that will contain the data you want to put in your report widget.

It is also possible to create a third collection that will contain data coming from the other two collections. So, you can use this 

third collection with the report widget.

Best regards,

Richard Manga


2013/10/23 <serc...@gmail.com>
the problem is that my data is stored in two collections and not display them together in a report.

In the widget report only gives the option to select a unique collection.
--
Fujitsu - RunMyProcess
---
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/.
Reply all
Reply to author
Forward
0 new messages