OS

 

Hello,   i need to create a report with more than one queries to retrieve diferent types of objects, to show in the same table.   How i can do this ?   Thanks for your help.
by M. Duitshof
Posted on Tue, 03/19/2013 - 11:04

The queries have to be nested. You have to find a way to build your Query 2 within Query 1.

Query 2 can be defined in a data table or in a separate query, as shown below.

In the table you can show data fields from superior queries next to data fields from the current query.

example of combining objects from different queries in one table



good luck,

Matthijs

0
by Odinei Silva Author
Posted on Tue, 03/19/2013 - 17:54

Thanks for your reply Matthijs.

I tried to use nested queries but i didn't had success!!

To solve this necessity, i changed the code of the standard report, and added a my customized code.

Thanks for your help.

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks
  • SS
  • MZ
  • Profile picture for user kbiront
  • Profile picture for user Tony Iliev
  • Profile picture for user amandeep.7.singh
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock