how to run Select and where statement in djangoHow 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?

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.










share|improve this question



















  • 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















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.










share|improve this question



















  • 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













0












0








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.










share|improve this question
















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















share|improve this question













share|improve this question




share|improve this question








edited Mar 8 at 9:34









Abbas

16512




16512










asked Mar 8 at 9:17









Muhammad SuhaibMuhammad Suhaib

11




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












  • 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







2




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





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












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
























    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


















    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















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    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





























      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



























        0












        0








        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















        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














        share|improve this answer



        share|improve this answer








        edited Mar 8 at 9:42

























        answered Mar 8 at 9:27









        Rajan SharmaRajan Sharma

        209321




        209321





























            draft saved

            draft discarded
















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid …


            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.

            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            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















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Can't find variable: document ReactNative Js2019 Community Moderator ElectionReactNative: how to center text?Can't find variable: navigate - ReactNative navigationReact Native error: “Can't find variable: TouchableHighlight”How to use Expo.DocumentPicker.getDocumentAsync properly. [Expo] [ReactNative]Can't find variable: regeneratorRuntime (ReactNative)Reactnative Expo It is advisable for a StartUp?Can't find variable : Self / Can't install firebaseNPM Install Error in installing ReactNative CLIContacts Displaying in App using ReactnativeFacebook login error: can't find variable: Alert

            Thal And Out Agency railway station See also References External links Navigation menuOfficial Web Site of Pakistan RailwaysArchivedOfficial Web Site of Pakistan Railwayseeexpanding ite

            Posting a File and Associated Data to a RESTful WebService preferably as JSON2019 Community Moderator ElectionREST URI convention - Singular or plural name of resource while creating itUploading both data and files in one form using Ajax?How do I upload a file with metadata using a REST web service?REST API - file (ie images) processing - best practicesSpring: JSON data and file in the same requestREST API Put large dataPosting a file and JSON data to Spring rest serviceRESTful Web Service Upload/Download Large Data With JSONREST API Design sending JSON data and a file to the api in same requestPost JSONArray to REST servicePUT vs. POST in RESTParsing values from a JSON file?JavaScript/jQuery to download file via POST with JSON dataHow do I upload a file with metadata using a REST web service?How to POST JSON data with Curl from Terminal/Commandline to Test Spring REST?Separate REST JSON API server and client?what's the correct way to send a file from REST web service to client?How do I write JSON data to a file?What is “406-Not Acceptable Response” in HTTP?REST API - file (ie images) processing - best practices