Skip to main content
shalinid0001
Known Participant
Oct 14, 2022 8:03 AM UTC
Question

Execute Query

Hi, I want to execute a SQL query, is there any function like executestoredprocedure that is used to execute an sp?

I am trying to run a SQL query through the process model and trying to see the result of that query, so is there a way how to get the result of that select statement?

Can anyone please help?

    6 replies

    ujjwalr0002
    Participating Frequently
    Oct 14, 2022 8:05 AM UTC

    Yes we have a smart service for that https://docs.appian.com/suite/help/22.3/Execute_Stored_Procedure_Smart_Service.html

    If you want to query using SP  https://docs.appian.com/suite/help/22.1/fnc_system_a_executestoredprocedureforquery.html

    shalinid0001Author
    Known Participant
    Oct 14, 2022 8:39 AM UTC

    No i dont want to query using SP

    ujjwalr0002
    Participating Frequently
    Oct 14, 2022 10:07 AM UTC

    Why you are not using the cloud database or Appian query directly?

    ravis5657
    Inspiring
    Oct 14, 2022 9:05 AM UTC

    Hi,

    You can run your query but your output will be exported in the Excel sheet.
    For this you can use "Export SQL To Excel" smart service.

    Thank You.

    ravis5657
    Inspiring
    Oct 14, 2022 9:06 AM UTC

    And then you can use that excel anywhere in the system you want.

    mikes0011
    mikes0011
    Brainy
    Oct 14, 2022 2:54 PM UTC

    Can you explain what your use case is that you can't use the standard Query Entity query?

    In any case, you could always look into the Query Database Smart Service, though I personally really dislike it and only use it when absolutely necessary (which is very rarely, in my experience).

    The Expression Guru
    Terms & ConditionsAccessibility statement