I am planning to build a demo prototype for a who-knows-who database
for the legal profession. Database will consist of lawyer name, school
and year graduated. Searching by lawyer name will return other lawyers
graduated from same law school the same year. Can I build this in
Django? How long would it take me to learn enough Django to build this
myself?

On 7 Lis, 15:58, Zeynel <azeyn...@gmail.com> wrote:

http://docs.djangoproject.com/en/dev/intro/tutorial01/

is enough to build it in no longer that a few days (learning
included),
even for pre-intermediate programmer.

On Nov 7, 12:23 pm, Tomasz Zieliński

I was able to build the admin page and put a search box there:

class LawyerAdmin(admin.ModelAdmin):
    fieldsets = [
        ('Name',   {'fields': ['last', 'first', 'initial']}),
        ('School', {'fields': ['school', 'year_graduated']}),
    ]
    list_display = ('first', 'initial', 'last', 'school',
'year_graduated')
    list_filter = ['year_graduated']
    search_fields = ['last', 'first']

This search box searches only first and last names. But what i want is
a search box that finds all lawyers who went to same school. My
database now contains:

        Tom     T.      Lawyer3 Columbia School of Law  2003
        Bob             Lawyer2 NYU     2000
        John    I       Lawyer1 NYU     2000

So Lawyer1 and Lawyer2 graduated from NYU in 2000.

So I want to enter in the search box "Lawyer1" and in the result page
I want to see "Lawyer1 knows Lawyer2"

How do I do this?

Thank you so much.

On Nov 7, 12:23 pm, Tomasz Zieliński

In this document http://docs.djangoproject.com/en/dev/ref/contrib/admin/
 ModelAdmin.search_fields is explained:

"You can also perform a related lookup on a ForeignKey with the lookup
API "follow" notation.

search_fields = ['foreign_key__related_fieldname']"

I tried

search_fields = ['school__lawyer']

but I get an error message when I did a search for last name of
lawyer:

Related Field has invalid lookup: icontains

When I try

search_fields = ['school__last']

I get the error message

Cannot resolve keyword 'last' into field. Choices are: id, lawyer,
school

Maybe I don't understand what "related_fieldname" is.

What is it?

This is my model:

class School(models.Model):
    school = models.CharField(max_length=200)
    def __unicode__(self):
        return self.school

class Lawyer(models.Model):
    first = models.CharField(max_length=20)
    initial = models.CharField(blank=True, max_length=2)
    last = models.CharField(max_length=20)
    year_graduated = models.IntegerField('Year graduated')
    school = models.CharField(max_length=200)
    school = models.ForeignKey(School)
    def __unicode__(self):
        return self.first

Thank you

On Nov 10, 7:35 pm, Kenneth Gonsalves <law...@au-kbc.org> wrote:

search_fields = ['school__lawyer_last']

to specify which field on the related 'lawyer' instance you want to
search. You can add others like:

search_fields = ['school__lawyer_last', 'school__lawyer_first']

search_fields = ['school__lawyer_first']

and I get this error

Cannot resolve keyword 'lawyer_first' into field. Choices are: id,
lawyer, school

In the variations that I tried only

search_fields = ['school__school']

worked.

I followed the tutorial and arranged lawyer names as a list, so that
when I search for school, I see which lawyers went to that school and
their year of graduation. Then I have the filter by year, and when I
apply that filter, I see all the lawyers who graduated from same
school same year. This is the result that I want, but obviously not a
very elegant solution.

Thank you.

On Nov 11, 1:01 pm, "pjrhar...@gmail.com" <pjrhar...@gmail.com> wrote: