I'm not sure if this is in the scope of the views project, but I think it would be nice if there was a way to add custom SQL queries on the actual page for the view. Like it would be helpful if there was a way to maybe also INNER JOIN this one other table, but use all the rest of the views data. Or maybe create some very large view, but then also ORDER BY some custom table on the database.

Just a thought I had.

Views rules!

Comments

catch’s picture

catch
he/him
Primary language English
commented
Version: 6.x-2.x-dev » 5.x-1.x-dev
Status: Active » Closed (won't fix)

won't happen in 1.x, but is coming soon in 2.x!

jozzhart’s picture

jozzhart commented

Has it come in 2.x?

I can't see it anywhere, I would very much like to use a piece of custom SQL in a view.

Thanks

martin_q’s picture

martin_q
Primary language English
Location Leipzig, Germany | Manchester, UK
commented
Version: 5.x-1.x-dev » 6.x-2.0-rc5
Status: Closed (won't fix) » Active

Echoing jozzhart's question!

merlinofchaos’s picture

merlinofchaos commented
Version: 6.x-2.0-rc5 » 5.x-1.x-dev
Status: Active » Closed (won't fix)
martin_q’s picture

martin_q
Primary language English
Location Leipzig, Germany | Manchester, UK
commented
Version: 5.x-1.x-dev » 6.x-2.x-dev
Status: Closed (won't fix) » Active

I apologise now if I anger you by activating this again, but I don't understand what #4 means. In #2, a question is asked about version 2.x, which is why I changed the version to 6.x-2.x-something. And in #1, the feature is promised in version 2.x. So why is the status put back to "won't fix"? How is "won't be fixed in version 1.x" an answer to the question "has it come in 2.x?"? Please help me to understand what is going on. Many thanks.

am22’s picture

am22 commented

Subscribing - it would be very useful simply to be able to input the SQL query manually and let the views module handle the formatting. Is there any patch around to do that already?

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Fixed

You use the word 'simply'. I do not think it means what you think it means. At least, not in this case. Such an operation would not be simple.

That said, there are various views hooks you can use and you could replace the query in one of them. Please note that I will provide absolutely no support to doing this. You have to format the query exactly the way the handlers expect it to have been created, and if you don't, it will fail.

That's really all that's ever going to happen here.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.