Iterate layerScope.variableDisplaying QGIS layer after loading with PythonShow feature count of layer via Python console / PyQGISGetting list of valid layers in TOC using PyQGIS?PyQGIS Set Extent for loaded layers - Refresh problemDuplicating layer and applying filter using PyQGIS?Empty a layer for each QGIS projectPyQGIS QgsVectorLayer.uniqueValues() override active object filteringFilter Layerlist in Snapping Options DialogHow to change the order of layers in a Leaflet map?Testing for vector joins in PyQGIS 3

How to draw lines on a tikz-cd diagram

Opposite of a diet

Balance Issues for a Custom Sorcerer Variant

What is the intuitive meaning of having a linear relationship between the logs of two variables?

What Brexit proposals are on the table in the indicative votes on the 27th of March 2019?

Closest Prime Number

Detecting if an element is found inside a container

CREATE opcode: what does it really do?

Is this apparent Class Action settlement a spam message?

Was Spock the First Vulcan in Starfleet?

Fine Tuning of the Universe

Trouble understanding the speech of overseas colleagues

Purchasing a ticket for someone else in another country?

Integer addition + constant, is it a group?

For a non-Jew, is there a punishment for not observing the 7 Noahide Laws?

What is paid subscription needed for in Mortal Kombat 11?

How can we prove that any integral in the set of non-elementary integrals cannot be expressed in the form of elementary functions?

How does Loki do this?

Implement the Thanos sorting algorithm

How can I kill an app using Terminal?

How to safely derail a train during transit?

How does buying out courses with grant money work?

How do I go from 300 unfinished/half written blog posts, to published posts?

Risk of infection at the gym?



Iterate layerScope.variable


Displaying QGIS layer after loading with PythonShow feature count of layer via Python console / PyQGISGetting list of valid layers in TOC using PyQGIS?PyQGIS Set Extent for loaded layers - Refresh problemDuplicating layer and applying filter using PyQGIS?Empty a layer for each QGIS projectPyQGIS QgsVectorLayer.uniqueValues() override active object filteringFilter Layerlist in Snapping Options DialogHow to change the order of layers in a Leaflet map?Testing for vector joins in PyQGIS 3













0















I have a problem with this code :



for layer in layers :
#surcharge avec le filtre permanent
if QgsExpressionContextUtils.layerScope(layer).variable('layer_filter')!=None:
sql=u"(" + sql + u") AND " + QgsExpressionContextUtils.layerScope(layer).variable('layer_filter')


When a variable is found it is added to the sql variable. It is however kept for every layer even if there is no filter variable for them.



What can be done so the SQL filter corresponds to a single layer?










share|improve this question




























    0















    I have a problem with this code :



    for layer in layers :
    #surcharge avec le filtre permanent
    if QgsExpressionContextUtils.layerScope(layer).variable('layer_filter')!=None:
    sql=u"(" + sql + u") AND " + QgsExpressionContextUtils.layerScope(layer).variable('layer_filter')


    When a variable is found it is added to the sql variable. It is however kept for every layer even if there is no filter variable for them.



    What can be done so the SQL filter corresponds to a single layer?










    share|improve this question


























      0












      0








      0








      I have a problem with this code :



      for layer in layers :
      #surcharge avec le filtre permanent
      if QgsExpressionContextUtils.layerScope(layer).variable('layer_filter')!=None:
      sql=u"(" + sql + u") AND " + QgsExpressionContextUtils.layerScope(layer).variable('layer_filter')


      When a variable is found it is added to the sql variable. It is however kept for every layer even if there is no filter variable for them.



      What can be done so the SQL filter corresponds to a single layer?










      share|improve this question
















      I have a problem with this code :



      for layer in layers :
      #surcharge avec le filtre permanent
      if QgsExpressionContextUtils.layerScope(layer).variable('layer_filter')!=None:
      sql=u"(" + sql + u") AND " + QgsExpressionContextUtils.layerScope(layer).variable('layer_filter')


      When a variable is found it is added to the sql variable. It is however kept for every layer even if there is no filter variable for them.



      What can be done so the SQL filter corresponds to a single layer?







      pyqgis layers






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 13 hours ago









      JGH

      13.2k21139




      13.2k21139










      asked 13 hours ago









      GuenLMGuenLM

      153




      153




















          1 Answer
          1






          active

          oldest

          votes


















          0














          Add an else clause that puts an empty string in sql






          share|improve this answer






















            Your Answer








            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "79"
            ;
            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: false,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: null,
            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%2fgis.stackexchange.com%2fquestions%2f316825%2fiterate-layerscope-variable%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














            Add an else clause that puts an empty string in sql






            share|improve this answer



























              0














              Add an else clause that puts an empty string in sql






              share|improve this answer

























                0












                0








                0







                Add an else clause that puts an empty string in sql






                share|improve this answer













                Add an else clause that puts an empty string in sql







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 13 hours ago









                JGHJGH

                13.2k21139




                13.2k21139



























                    draft saved

                    draft discarded
















































                    Thanks for contributing an answer to Geographic Information Systems Stack Exchange!


                    • 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%2fgis.stackexchange.com%2fquestions%2f316825%2fiterate-layerscope-variable%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

                    រឿង រ៉ូមេអូ និង ហ្ស៊ុយលីយេ សង្ខេបរឿង តួអង្គ បញ្ជីណែនាំ

                    Crop image to path created in TikZ? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Crop an inserted image?TikZ pictures does not appear in posterImage behind and beyond crop marks?Tikz picture as large as possible on A4 PageTransparency vs image compression dilemmaHow to crop background from image automatically?Image does not cropTikzexternal capturing crop marks when externalizing pgfplots?How to include image path that contains a dollar signCrop image with left size given

                    Romeo and Juliet ContentsCharactersSynopsisSourcesDate and textThemes and motifsCriticism and interpretationLegacyScene by sceneSee alsoNotes and referencesSourcesExternal linksNavigation menu"Consumer Price Index (estimate) 1800–"10.2307/28710160037-3222287101610.1093/res/II.5.31910.2307/45967845967810.2307/2869925286992510.1525/jams.1982.35.3.03a00050"Dada Masilo: South African dancer who breaks the rules"10.1093/res/os-XV.57.1610.2307/28680942868094"Sweet Sorrow: Mann-Korman's Romeo and Juliet Closes Sept. 5 at MN's Ordway"the original10.2307/45957745957710.1017/CCOL0521570476.009"Ram Leela box office collections hit massive Rs 100 crore, pulverises prediction"Archived"Broadway Revival of Romeo and Juliet, Starring Orlando Bloom and Condola Rashad, Will Close Dec. 8"Archived10.1075/jhp.7.1.04hon"Wherefore art thou, Romeo? To make us laugh at Navy Pier"the original10.1093/gmo/9781561592630.article.O006772"Ram-leela Review Roundup: Critics Hail Film as Best Adaptation of Romeo and Juliet"Archived10.2307/31946310047-77293194631"Romeo and Juliet get Twitter treatment""Juliet's Nurse by Lois Leveen""Romeo and Juliet: Orlando Bloom's Broadway Debut Released in Theaters for Valentine's Day"Archived"Romeo and Juliet Has No Balcony"10.1093/gmo/9781561592630.article.O00778110.2307/2867423286742310.1076/enst.82.2.115.959510.1080/00138380601042675"A plague o' both your houses: error in GCSE exam paper forces apology""Juliet of the Five O'Clock Shadow, and Other Wonders"10.2307/33912430027-4321339124310.2307/28487440038-7134284874410.2307/29123140149-661129123144728341M"Weekender Guide: Shakespeare on The Drive""balcony"UK public library membership"romeo"UK public library membership10.1017/CCOL9780521844291"Post-Zionist Critique on Israel and the Palestinians Part III: Popular Culture"10.2307/25379071533-86140377-919X2537907"Capulets and Montagues: UK exam board admit mixing names up in Romeo and Juliet paper"Istoria Novellamente Ritrovata di Due Nobili Amanti2027/mdp.390150822329610820-750X"GCSE exam error: Board accidentally rewrites Shakespeare"10.2307/29176390149-66112917639"Exam board apologises after error in English GCSE paper which confused characters in Shakespeare's Romeo and Juliet""From Mariotto and Ganozza to Romeo and Guilietta: Metamorphoses of a Renaissance Tale"10.2307/37323537323510.2307/2867455286745510.2307/28678912867891"10 Questions for Taylor Swift"10.2307/28680922868092"Haymarket Theatre""The Zeffirelli Way: Revealing Talk by Florentine Director""Michael Smuin: 1938-2007 / Prolific dance director had showy career"The Life and Art of Edwin BoothRomeo and JulietRomeo and JulietRomeo and JulietRomeo and JulietEasy Read Romeo and JulietRomeo and Julieteeecb12003684p(data)4099369-3n8211610759dbe00d-a9e2-41a3-b2c1-977dd692899302814385X313670221313670221