queryset-didn't show result.

9 views

Skip to first unread message

DjgoNy

unread,

Oct 25, 2012, 10:30:27 AM10/25/12

to django...@googlegroups.com

I have a project where i have to extract data from database whenever i click on it.

It should be shown in a table and it will be shown individually but whenever i use queryset in my view it didn't show anything

and when i commented the queryset then it will be shown all the listed data but not individually. in other word not the right data but there is a result.

what went wrong with my program.

view.py

class SolutionView(ListView):

template_name="Solution_list.html"

model = Solution

form_class = SolutionForm

context_object_name = "solutions"

def get_context_data(self, **kwargs):

context = super(SolutionView, self).get_context_data(**kwargs)

context['person_NOID']=self.kwargs['person_NOID']

tilstande =Solution.objects.filter( NOID= self.kwargs['person_NOID'])

return context

def get_queryset(self, **kwargs):

queryset =Solution.objects.filter(CPR = self.kwargs['person_NOID'])

return queryset

def form_valid(self, queryset):

queryset.save()

return HttpResponseRedirect(reverse("index"))

Solution_list.html

<html>

<head>

<body>

<h2 style="text-align: left; margin-left: 5%;">Solution</h2>

{% if solutions%}

{% csrf_token %}

<thead>

<tr>

<th>NOID {{ person_NOID }}</th>

<th>SMOKING</th>

<th>WEIGHT</th>

</tr>

</thead>

<tbody>

{% for solution in solutions %}

<tr>

<td>{{ solution.NEW_DATE }}</td>

</tr>

{% endfor %}

</tbody>

</table>

</form>

{% else %}

{% endif %}

</body>

</head>

</html>

I want it to look something like this.

NOID - 123456789	SMOKING	WEIGHT	BP
DATE	DATE	NEW DATE

whereby everytime they came a new date it will be shown in DATE-first date DATE-next date DATE-and so on.

And when user click on NEW DATE then the result will be shown on the appropriate table ei: smoking , weight, BP.