Skip to main content
siddhants0001
April 14, 2022
Question

is making reports using stored procedures is good practice or using expression rule ?? which is best and why?

  • April 14, 2022
  • 6 replies
  • 0 views

is making reports using stored procedures is good practice or using expression rule ?? which is best and why?

    6 replies

    harshitb6843
    April 14, 2022

    I would always recommend using records or expression rules for reporting. 

    stefanhelzle0001
    April 14, 2022

    There is not general answer to this question. Yes / No / Maybe ...

    siddhants0001
    April 14, 2022

    as  appian developer what would you prefer ?

    stefanhelzle0001
    April 14, 2022

    The appropriate, based on the requirements. In general I try to do as much as possible inside Appian.

    christineh465186
    April 20, 2022

    I would be curious as to the needs.. It could be about what you are making the user "wait" for.

    If your report needs to dynamically create a SQL to execute and get the data - then sure a stored proc
    If your report is manipulating data - then use a view
    If your report is pulling data from a table - use a table

    Using a stored proc for a report is a maybe (but should not be often)