Score:0

How to sort the views by a column from a custom database table?

kr flag

I have a custom database table my_apps.

This table has nid and uid columns.

I have created a view, which is displaying some nodes. I want to sort this view from that custom table.

Like ORDER BY COUNT(uid from my_apps) where nid={nid from my_apps}

Is this possible?

I tried this module Views custom table but then you have to create the view based on that table instead of a content view. And I don't want that.

unusedspoon avatar
aq flag
Probably to create a custom field for views (you can create your own field to be used within views). Have a google for that, there are lots of examples out there
kr flag
Can you share a link please?
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.