Hello Andrew,

Hope you're doing well.

What exactly is the error? :)

Did you define the Expand Inline property set to Yes for your @Input query parameter?

Kind regards,

Rui Barradas

The Expand Inline is set to yes

Here is the error

"Error executing query. Error in advanced query SQL1 in GetTransactions in RAMDataCollection (select {tbl_OUT_TRANSACTIONS}.* where {tbl_OUT_TRANSACTIONS}.[TRANSACTION_ID] NOT IN (@Input)): The multi-part identifier "RAM_MA_OUTSYSTEMS.dbo.tbl_OUT_TRANSACTIONS.TRANSACTION_ID" could not be bound.
The multi-part identifier "RAM_MA_OUTSYSTEMS.dbo.tbl_OUT_TRANSACTIONS.TRANSACTION_ID" could not be bound.
The multi-part identifier "RAM_MA_OUTSYSTEMS.dbo.tbl_OUT_TRANSACTIONS.TRANSACTION_ID" could not be bound.
The multi-part identifier "RAM_MA_OUTSYSTEMS.dbo.tbl_OUT_TRANSACTIONS.TRANSACTION_ID" could not be bound.
The multi-part identifier "RAM_MA_OUTSYSTEMS.dbo.tbl_OUT_TRANSACTIONS.TRANSACTION_ID" could not be bound.
The multi-part identifier "RAM_MA_OUTSYSTEMS.dbo.tbl_OUT_TRANSACTIONS.TRANSACTION_ID" could not be bound.
The multi-part identifier "RAM_MA_OUTSYSTEMS.dbo.tbl_OUT_TRANSACTIONS.MERCHENDISER_ID" could not be bound.
The multi-part identifier "RAM_MA_OUTSYSTEMS.dbo.tbl_OUT_TRANSACTIONS.CUSTOMER_ID" could not be bound.
The multi-part identifier "RAM_MA_OUTSYSTEMS.dbo.tbl_OUT_TRANSACTIONS.INSTALL_DATE" could not be bound.
The multi-part identifier "RAM_MA_OUTSYSTEMS.dbo.tbl_OUT_TRANSACTIONS.DISPLAYID" could not be bound.
The multi-part identifier "RAM_MA_OUTSYSTEMS.dbo.tbl_OUT_TRANSACTIONS.CASES_INSTALLED" could not be bound.
The multi-part identifier "RAM_MA_OUTSYSTEMS.dbo.tbl_OUT_TRANSACTIONS.DISPLAY_WORK_DONE" could not be bound.
The multi-part identifier "RAM_MA_OUTSYSTEMS.dbo.tbl_OUT_TRANSACTIONS.DISPLAY_TYPE" could not be bound.
The multi-part identifier "RAM_MA_OUTSYSTEMS.dbo.tbl_OUT_TRANSACTIONS.DISPLAY_LOCATION" could not be bound.
The multi-part identifier "RAM_MA_OUTSYSTEMS.dbo.tbl_OUT_TRANSACTIONS.BRAG_BOOK" could not be bound.
The multi-part identifier "RAM_MA_OUTSYSTEMS.dbo.tbl_OUT_TRANSACTIONS.REJECT_REASON" could not be bound.
The multi-part identifier "RAM_MA_OUTSYSTEMS.dbo.tbl_OUT_TRANSACTIONS.DateModified" could not be bound."

Your will try below query 

select {tbl_OUT_TRANSACTIONS}.* where {tbl_OUT_TRANSACTIONS}.[TRANSACTION_ID] <> (@Input)

Regards,

Shahaji

Hello Andrew, 

What is you Output/Structure ?

It should be it 

{tbl_OUT_TRANSACTIONS} 

if you are using 

{tbl_OUT_TRANSACTIONS}.*

Hope this will help you.