Skip to main content
S
shalinid0001
October 14, 2022
Question

Execute Query

  • October 14, 2022
  • 6 replies
  • 0 views

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

    U
    ujjwalr0002
    October 14, 2022

    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

    S
    shalinid0001Author
    October 14, 2022

    No i dont want to query using SP

    U
    ujjwalr0002
    October 14, 2022

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

    R
    ravis5657
    October 14, 2022

    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.

    R
    ravis5657
    October 14, 2022

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

    mikes0011
    mikes0011
    Brainy
    October 14, 2022

    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).

    Terms & ConditionsAccessibility statement