CODEWITHSUNDEEP
flaskjinja2flask-sqlalchemy
JustXanny
JustXanny

Reputation: 103

Querying a single field within a Jinja2 template

I'm working on an application where users can enter work requests, and subsequently go in and search for requests. The issue I'm having is building out the request summary screen. Basically, it lists the results of a search query. The snippet from the template is as such:

        {% for req in workrequests %}
            {{ req.id }} {{ req.customer }} {{ req.dateEntered }} {{ req.Contact }}
        {% endfor %}

Here's wher I get hung up. The req.customer, and req.Contact fields are just keys for the customer and contact databases. I want to display the customer name and contact name. I assume the following queries should do the trick:

        Customer.query.filter_by(req.customer).one()
        Contact.query.filter_by(req.Contact).one()

Problem is, that will return the entire record. I'm just after the name field from both of those tables to put into my template, which is where the problem is. I'm not sure how to proceed with this

Upvotes: 0

Views: 2092

Answers (1)

Audrius Kažukauskas
Audrius Kažukauskas

Reputation: 13533

Customer.query is a short form of db.session.query(Customer). Use the latter to query for specific columns:

db.session.query(Customer.name).filter_by(id=req.customer).one()

Although I think that what you really want is a single query that gets all the data at once. Something like:

db.session.query(
    WorkRequest.id,
    WorkRequest.dateEntered,
    Customer.name,
    Contact.name
).join(
    Customer,
    Contact
).filter(...)

Upvotes: 1

Related Questions