Skip to main content
siddhants0001
New Participant
Apr 14, 2022 9:47 AM UTC
Question

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

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

    6 replies

    harshitb6843
    Brainy
    Apr 14, 2022 11:59 AM UTC

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

    stefanhelzle0001
    Brainy
    Apr 14, 2022 12:16 PM UTC

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

    siddhants0001
    New Participant
    Apr 14, 2022 12:19 PM UTC

    as  appian developer what would you prefer ?

    stefanhelzle0001
    Brainy
    Apr 14, 2022 12:53 PM UTC

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

    christineh465186
    Participating Frequently
    Apr 20, 2022 8:20 PM UTC

    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)