Ggtcf

Lay out the Carpet

Increase performance creating Mandelbrot set in python

Modify casing of marked letters

Time travel short story where a man arrives in the late 19th century in a time machine and then sends the machine back into the past

At which point does a character regain all their Hit Dice?

Star/Wye electrical connection math symbol

Everything Bob says is false. How does he get people to trust him?

Opposite of a diet

How does it work when somebody invests in my business?

Teaching indefinite integrals that require special-casing

Why Were Madagascar and New Zealand Discovered So Late?

Transcription Beats per minute

Coordinate position not precise

How can I replace every global instance of "x[2]" with "x_2"

What would happen if the UK refused to take part in EU Parliamentary elections?

Bash method for viewing beginning and end of file

Irreducibility of a simple polynomial

Will it be accepted, if there is no ''Main Character" stereotype?

Finding all intervals that match predicate in vector

Hide Select Output from T-SQL

How do I keep an essay about "feeling flat" from feeling flat?

Is there any reason not to eat food that's been dropped on the surface of the moon?

Hostile work environment after whistle-blowing on coworker and our boss. What do I do?

Have I saved too much for retirement so far?

how to run Select and where statement in django

How do I filter ForeignKey choices in a Django ModelForm?Getting Django admin url for an objectDoes Django scale?How to debug in Django, the good way?Where should signal handlers live in a django project?differentiate null=True, blank=True in djangoHow to show the sql django runs?ReactJS with Django - real usageHow to filter objects for count annotation in Django?how to write simple select query with where clause in django object view.py?

0

How to Select and Put Where Condition in Django? And how to print in view.py?

I am trying like this but not works.

check2 = Project_Time_Status.objects.filter(project_id=project_id).filter(finishing_time__isnull=True).all()
if check2:
 for unit in check2:
 print (unit.project_id)

select * from Project_Time_Status where project_id = projectid AND finishing_time != null

Thanks in advance.

django

share|improve this question

edited Mar 8 at 9:34

Abbas

16512

asked Mar 8 at 9:17

Muhammad SuhaibMuhammad Suhaib

11

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  change the query to this check2 = Project_Time_Status.objects.filter(project_id=project_id, finishing_time__isnull=True) print check2 and see what you get first, then you can debug further.
  
  – Sammy J
  Mar 8 at 9:23
  

  
  
  
  

add a comment | 

0

How to Select and Put Where Condition in Django? And how to print in view.py?

I am trying like this but not works.

check2 = Project_Time_Status.objects.filter(project_id=project_id).filter(finishing_time__isnull=True).all()
if check2:
 for unit in check2:
 print (unit.project_id)

select * from Project_Time_Status where project_id = projectid AND finishing_time != null

Thanks in advance.

django

share|improve this question

edited Mar 8 at 9:34

Abbas

16512

asked Mar 8 at 9:17

Muhammad SuhaibMuhammad Suhaib

11

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  change the query to this check2 = Project_Time_Status.objects.filter(project_id=project_id, finishing_time__isnull=True) print check2 and see what you get first, then you can debug further.
  
  – Sammy J
  Mar 8 at 9:23
  

  
  
  
  

add a comment | 

How to Select and Put Where Condition in Django? And how to print in view.py?

I am trying like this but not works.

check2 = Project_Time_Status.objects.filter(project_id=project_id).filter(finishing_time__isnull=True).all()
if check2:
 for unit in check2:
 print (unit.project_id)

select * from Project_Time_Status where project_id = projectid AND finishing_time != null

Thanks in advance.

django

share|improve this question

edited Mar 8 at 9:34

Abbas

16512

asked Mar 8 at 9:17

Muhammad SuhaibMuhammad Suhaib

11

check2 = Project_Time_Status.objects.filter(project_id=project_id).filter(finishing_time__isnull=True).all()
if check2:
 for unit in check2:
 print (unit.project_id)

select * from Project_Time_Status where project_id = projectid AND finishing_time != null

share|improve this question

edited Mar 8 at 9:34

Abbas

16512

asked Mar 8 at 9:17

Muhammad SuhaibMuhammad Suhaib

11

share|improve this question

edited Mar 8 at 9:34

Abbas

16512

asked Mar 8 at 9:17

Muhammad SuhaibMuhammad Suhaib

11

edited Mar 8 at 9:34

Abbas

16512

edited Mar 8 at 9:34

Abbas

16512

asked Mar 8 at 9:17

Muhammad SuhaibMuhammad Suhaib

11

asked Mar 8 at 9:17

Muhammad SuhaibMuhammad Suhaib

11

1 Answer
1

active

oldest

votes

0

If you want to filter the details based on some condition you can use filter() method.

check2 = Project_Time_Status.objects.filter(project_id=project_id,finishing_time__isnull=True)

This would be same as:

select * from Project_Time_Status where project_id = projectid AND finishing_time != null

Then you can print the results like this:

for record in check2:
 print(record)

share|improve this answer

edited Mar 8 at 9:42

answered Mar 8 at 9:27

Rajan SharmaRajan Sharma

209321

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55060032%2fhow-to-run-select-and-where-statement-in-django%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

If you want to filter the details based on some condition you can use filter() method.

check2 = Project_Time_Status.objects.filter(project_id=project_id,finishing_time__isnull=True)

This would be same as:

select * from Project_Time_Status where project_id = projectid AND finishing_time != null

Then you can print the results like this:

for record in check2:
 print(record)

share|improve this answer

edited Mar 8 at 9:42

answered Mar 8 at 9:27

Rajan SharmaRajan Sharma

209321

add a comment | 

0

If you want to filter the details based on some condition you can use filter() method.

check2 = Project_Time_Status.objects.filter(project_id=project_id,finishing_time__isnull=True)

This would be same as:

select * from Project_Time_Status where project_id = projectid AND finishing_time != null

Then you can print the results like this:

for record in check2:
 print(record)

share|improve this answer

edited Mar 8 at 9:42

answered Mar 8 at 9:27

Rajan SharmaRajan Sharma

209321

add a comment | 

If you want to filter the details based on some condition you can use filter() method.

check2 = Project_Time_Status.objects.filter(project_id=project_id,finishing_time__isnull=True)

This would be same as:

select * from Project_Time_Status where project_id = projectid AND finishing_time != null

Then you can print the results like this:

for record in check2:
 print(record)

share|improve this answer

edited Mar 8 at 9:42

answered Mar 8 at 9:27

Rajan SharmaRajan Sharma

209321

check2 = Project_Time_Status.objects.filter(project_id=project_id,finishing_time__isnull=True)

select * from Project_Time_Status where project_id = projectid AND finishing_time != null

for record in check2:
 print(record)

share|improve this answer

edited Mar 8 at 9:42

answered Mar 8 at 9:27

Rajan SharmaRajan Sharma

209321

answered Mar 8 at 9:27

Rajan SharmaRajan Sharma

209321

answered Mar 8 at 9:27

Rajan SharmaRajan Sharma

209321