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?






pyqgis layers







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?






    pyqgis layers







    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?






      pyqgis layers







      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




      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

                    Export of reprojected layer from GEE fails Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Iterate over features and years to export images for each feature-yearEarth engine reproject: why does reprojecting a pixel at 30m scale gives me pixels with an area of ~550?Exporting slope raster for entire country in GEEGEE Landsat SR year composite // mask cloud / shadow out w/ other method than quality pixel"export region contains no valid (un-masked) pixels - Google Earth EgineGoogle Earth Engine, how to distinguish between rivers/streams and ponds/lakes in a water maskPython script tool fails when processing rainfall data from Google Earth EngineGoogle Earth Engine Error: Number of pixels requested from Image.load exceeds the maximum allowedCloudfree images in small area from Sentinel-2Using Image exportToDrive in Google Earth Engine?

                    Image
                    Do wooden building fires get hotter than 600°C? What does "lightly crushed" mean for cardamon pods? How come Sam didn't become Lord of Horn Hill? Can a party unilaterally change candidates in preparation for a General election? What's the meaning of "fortified infraction restraint"? Century handling in Pandas Is it cost-effective to upgrade an old-ish Giant Escape R3 commuter bike with entry-level branded parts (wheels, drivetrain)? Where are Serre’s lectures at Collège de France to be found? If my PI received research grants from a company to be able to pay my postdoc salary, did I have a potential conflict interest too? Maximum summed powersets with non-adjacent items What does this Jacques Hadamard quote mean? Generate an RGB colour grid Is this homebrew Lady of Pain warlock patron balanced? Withdrew £2800, but only £2000 shows as withdrawn on online banking; what are my obligations? What is the meaning of the simile “quick ...
                    Read more

                    Creating closest line along the point''s azimuth using PostgreSQL Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Drawing line between points at specific distance in PostGIS?How to efficiently find the closest point over the dateline?How to find the nearest point by using PostGIS function?PostGIS nearest point with LATERAL JOIN in PostgreSQL 9.3+Creating a table and inserting selected streets using plpgsql functionsCreating a table that stores Distances and other columnSaving select query results (year wise) from PostgreSQL/PostGIS to text filesWhat is the information behind this geometry?How to give start and end vertex ids dynamically in pgr_dijkstra?Point to Polygon nearest distance DS_distance is not using geography index & knn <-> or <#> does not give result in orderLine to point conversion with start point and end point detection?

                    Image
                    On SQL Server, is it possible to restrict certain users from using certain functions, operators or statements? Can non-competes be enforced after expiration? Can a new player join a group only when a new campaign starts? How to show element name in portuguese using elements package? Why do we bend a book to keep it straight? Around usage results When a candle burns, why does the top of wick glow if bottom of flame is hottest? How to react to hostile behavior from a senior developer? Why aren't air breathing engines used as small first stages How can I make names more distinctive without making them longer? Quick way to create a symlink? Where are Serre’s lectures at Collège de France to be found? Is it cost-effective to upgrade an old-ish Giant Escape R3 commuter bike with entry-level branded parts (wheels, drivetrain)? 8 Prisoners wearing hats How to answer "Have you ever been terminated?" Why wasn't DOSKEY integrated with command.com? ...
                    Read more

                    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

                    Image
                    Is it possible to boil a liquid by just mixing many immiscible liquids together? Why is there no army of Iron-Mans in the MCU? New Order #5: where Fibonacci and Beatty meet at Wythoff Fishing simulator Is there a canonical way to handle JSON data format changes? Why use gamma over alpha radiation? When to stop saving and start investing? How to select CMU Sans Serif Bold in XeTeX? Estimate capacitor parameters How to pronounce "criar"? If A makes B more likely then B makes A more likely" What do you call a plan that's an alternative plan in case your initial plan fails? Can inflation occur in a positive-sum game currency system such as the Stack Exchange reputation system? Are my PIs rude or am I just being too sensitive? Why don't the Weasley twins use magic outside of school if the Trace can only find the location of spells cast? Are Luton Airport to London National Express transfer hours fixed according to my reservation? How wi...
                    Read more