• Which is the best way to use ISqlFormatter with version 9.3?

    Hi everyone,

    We are working on an implementation for a process that will, in the Pre-Script, make a Select SQL Query to the DB to retrieve few data to then perform an Insert.

    We were still looking at how to use IColDBObject but it looks like it's deprecated…

  • Query in a scrip with order by condition

    Hi everyone,

    I'm creating a custom scrip in which I need to execute a query with the order by clause. I specified it in the where caluse but there is a default "order by cn" in the final query. Here you can see the two queries.

    Where clasue…

  • Orderby quering the database with script

    Hi all,

     

    I need to get the reasonHead from Decisiontype Unsubscribe on a Request but if on that request are started more Unsubscribe I need to get the last one made.

    Basically I need the orderby on Connection.getSingleValue or Connection.getSingleRow.