Tricky way to get index of row in query rule

Actually I'd take a different approach. Leverage the power of the database and create a VIEW that selects all of the data you want returned from the row, and in the selection criteria use the MAX(Index) WHERE "ApproverDecision' IS NOT NULL AND 'ApproverDecisionDate' IS NOT NULL to select the one row you want returned. Now you have your VIEW it'll be straightforward to simply return the content of that VIEW into Appian.

Actually I'd take a different approach. Leverage the power of the database and create a VIEW that selects all of the data you want returned from the row, and in the selection criteria use the MAX(Index) WHERE "ApproverDecision' IS NOT NULL AND 'ApproverDecisionDate' IS NOT NULL to select the one row you want returned. Now you have your VIEW it'll be straightforward to simply return the content of that VIEW into Appian.

Thanks, is there a quick guide to creating a CDT from views?

It;'s pretty straightforward. Create a new CDT, select the option to create from a database object, pick the Datastore that points to your DB, then pick the VIEW. You'll then get a dialogue to set the attributes of the CDT. Things to remember:

• make sure you set the namespace to the standard one for your application
• make sure you set one column as the Primary Key - in your case this will be the PK selected in your VIEW, so make sure you've included it!
• rename the attributes according to the standards for you application

...here's the official documentation:

https://docs.appian.com/suite/help/20.1/Mapping_CDTs_to_Pre-defined_Database_Tables.html

(edited to make up for my mistake - you should select the MAX(Index) where the column(s) are NOT null!!!

Thanks again.