Need to search through several tables using one model

[Damjan Dimitrioski]

Hi,

Is there a way to make a model that links several db tables in one model, so that can be used in a change list view ?
Most importantly, I need to be able to use the search field, can this be accomplished ?

Regards.

[Vijay Khemlani]

Just using the ORM I think not

You could

1. Make a raw sql query using UNIONs for each table

2. Make a common superclass for the models with th search field

3. Use an external search engine (elasticsearch, etc) and store the entries for the required models under the same index.

Finally, you could just query each model separately

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/0fc05894-fb00-40d5-b1d9-68daa5c82841%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Damjan Dimitrioski]

Can I override the search button, so it will call the custom raw query ?
And if yes, can you show me how to override it, please ?

[Alon Nisser]

You could also create a model that foreign keys to all the relevant models, and filter on that.. 

Buy first you need to clarify (for your self..) The exact use case: is it search? if so better use haystack with some search backend (elasticsearch would be a great choice), Is it to choose something in a form? something else? 

The technical details should be derived from the problem you are trying to solve.. 

[Vijay Khemlani]

What search button are you talking about?

--

You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/235267f4-1851-4464-9426-b63dc074d671%40googlegroups.com.

[Damjan Dimitrioski]

The search filter above the change list view template, there is a button named search I think, I think it's need to overriden in order to implement custom model or something.

--
You received this message because you are subscribed to a topic in the Google Groups "Django users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/django-users/oaInfa9o4Js/unsubscribe.
To unsubscribe from this group and all its topics, send an email to django-users...@googlegroups.com.

To post to this group, send email to django...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CALn3ei0RSv4RuAyp%2BBhk5c9Qi4riF%3DFF3VXVQ_cr1rnuAxBs2g%40mail.gmail.com.

[Damjan Dimitrioski]

I wrapped something like this:
https://dpaste.de/4WTq

However, I'm not able to see any results in the changelist view, but the get_query_set method prints the query results in the STDOUT, what I'm doing wrong ?

[Vijay Khemlani]

The dpaste link is broken

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAHDCi6Rx%2BLzfsykLzBNB1RZV-7Zjg%3DowZ_yZoR4RNOZC0skQ3w%40mail.gmail.com.

[Damjan Dimitrioski]

Oh, sorry about that, it was se to an hour, here is an updated one: https://dpaste.de/q9sq

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CALn3ei1rrbSj2jmosaKrO%2Bf2BS6ofrT%3DDLVjwamtNQ%3Dx4yNKfw%40mail.gmail.com.

[Collin Anderson]

Hi,

The new link isn't working either.

Collin