[Special feature] Universal Content Module & SQL condition

Hi there
I have a special needing (but not too special, considering the general use it can lead to) regarding Universal Content Module.
I have built a site with mixing function coming from FC & VirtueMart v. 2.
I would like to extend the ecommerce website features: due to the fact that I use FC to show products, and use VM2 only to get ecommerce functions, I would like to implement some further modules showing, for example, additional commercial info, like "people that bougth this also bougth..." or "most selling item". But I wold like to do that using the Universal Content Module.
From that "idea" comes my special request: is there a way to include a sort of PHP/SQL filtering capabilities that could be used to filter what I would like to show in this module?
I try to better explain.
Right now there is a capability to filter items and show them using for example the "category scope". But if I had a further way to query the database and look for sold items, I could filter and display all the items assigned, for example, to one or more categories AND ordered by customers in the last month.
In a more general way, you could better filter any kind of content, and Universal Content Module will become very powerfull!
Is that option so complicated to code? Could you please add this to your "to do" queue?
Waiting for you kindly reply.
Thank you in advance

So you are thinking of a new SCOPE ?
the SQL query SCOPE

that would
-1- execute an SQL query that returns item IDs

-2- could have replacements like:
a. ID of current item
b. ID of current category of current item
c. item properties of current item, such as:
- item->catid (item's main category)
- item->created (creation date)
- item->created_by (user id of item owner?)

SteP wrote: and Universal Content Module will become very powerfull!

universal module isn't enough powerfull ?? lol

micker wrote:

SteP wrote: and Universal Content Module will become very powerfull!

universal module isn't enough powerfull ??

...who told that? :shock:

...probably I should have stated "MORE very powerfull", sorry for that mistake :lol:

OK, seriously: yes, the idea is to add SQL query to a scope to obtain special filtering.

You can for example take a look here:
www.mmcedizioni.it/it/catalogo-l ... ume-3.html

Inside the module "Altri libri di MARIA CRISTINA MARTINI" I use a scope filtering the items inside the category
All items representing a books are assigned to categories named with the Author name, so it's simple to get all items within a single category and list them there.
BUT if I had a way to catch the item SKU by SQL query (represented by the ISBN number), and match it with the item id, I could select one or more Author categories, and list a certain number of "most sold" books, or items bought togheter, and so on.
I would underline that this approach could be useful in several other occasions (not only in my "special" FC use as ecommerce data entry), to get special reports you can't get right now using existant filters

yes it's a joke ...

Hi all: any feedback about my proposal?
Thank you in advance