Allow me to create a report with columns based on SQL subqueries. Hot

by Paul Thompson on July 01, 2015

Allow me to add a column to a report using a subquery.

  • There are many times I would like to add a column to a report that requires a lookup or subquery that can't be accomplished using the standard SBM reporting tools. I can get the data using SQL queries to the AE database, but that is outside of SBM. I would like to be able to add columns using something similar to the "computed columns" but using raw SQL. Obviously this would require an intimate knowledge of the underlying schema. The ability to add subquery columns must be a restricted privilege because it can allow a report to contain information that may be restricted by the current user's privileges.

  • Please login to view any attachments.

  • This idea has not received many votes in 24 months since its submission. It has been closed (declined) due to insufficient support.
    David J. Easter Commented by David J. Easter June 04, 2018
    #1 Reviewer  -  

    This idea has not received many votes in 24 months since its submission. It has been closed (declined) due to insufficient support.

     

PrintEmail

Recent Tweets