search

kalenjordan / custom-reports

Custom Magento reports using SQL
http://magemail.co/free-custom-reports-module-for-magento/
Other
143 stars 65 forks source link

Clickable url and customreport rename #46

Closed peterjaap closed 8 years ago

peterjaap commented 8 years ago

Usage of clickable URL;

SELECT entity_id, `main_table`.increment_id,'*/sales_order/view/order_id/entity_id' as clickable_url FROM `sales_flat_order` AS `main_table`

The clickable_url column will be skipped while generating the grid.

The '*/sales_order/view/order_id/entity_id' part will be used to generate the grid. The last part behind the / will be used to look for the column name in the query (entity_id). The part before that (id) will be used as the field parameter in the get query. The rest will be used for the first argument for getUrl().

kalenjordan commented 8 years ago

I'm sure I don't need to test this given that the great @peterjaap did it!

peterjaap commented 8 years ago

Lol that might be too much credit but we'll see :sunglasses:

MarcusWolschon commented 8 years ago

So 1 clickable URL is possible but there is no way to make more columnd clickable? A good step forward.

MarcusWolschon commented 8 years ago

Your exact example doesn't seem to work here. Is there some specific version of "custom-reports" required?

peterjaap commented 8 years ago

Nope it's in the master. Make sure you're not using an alias for the field referenced in clickable_url.

MarcusWolschon commented 8 years ago

Yes, I needed a special version. I needed to update to the latest git master. There was no new (stable) release of the "custom-reports" project.

The URLs are clickable but a right click to open them in a new tab doesn't work because they are not regular HTML links.