Querying Transaction ID

Erica Esson 2

Is there a way to create a query based on transaction ID in Luminate? I have a list of missing transaction that I want to pull and upload into Raiser's Edge.

Joanne Felci 2

I do not think you can do a query by transaction ID but what I'd recommend is doing a custom report via report writer and you can select transaction ID as part of the output, filter by date range, and include any/all information you would need to do an import into RE

Erica Esson 2

I already have that report but I just wanted to pull specific transaction. Thanks.

Romany Nassief

Since you know the transaction Id, You can navigating to Fundrasing > Transactions

Enter the Transaction ID and click "Search"

Brian Mucha

Another thing you can do is use the format of Luminate URLs. For instance the URL...


https://secure3.convio.net/abc/admin/ReceiptViewerAdmin/12345.pdf?tx_id=12345


...will open a receipt for transaction Id 12345. I use this sort of thing with Excel and the =hyperlink function often.


=hyperlink(concatonate("https://secure3.convio.net/abc/admin/ReceiptViewerAdmin/", B2, ".pdf?tx_id=", B2), "Click Me")

 

Erica Esson 2

Thank you all for your feedback and suggestions! I guess we cannot specify a list of transaction IDs to pull.