how to get style from layer in geoserver











up vote
1
down vote

favorite












I would like to get style (sld or css does not matter, but prefer css) from sql view layer but I couldn' t achieve this.
here is my sql view for layer



select 
value,
location,
'mark: symbol(square);mark-size: 6px;:mark {fill: #0099cc;}' STYLE
from TABLE t


And here is my style:



/* @title point */
* {
[STYLE]
}


When I preview the layer I get following error:



org.parboiled.errors.ParserRuntimeException: Error at line 3. Encountered "<EOF>" at line 1, column 5. Was expecting one of: "(" ... ":" ... <IDENTIFIER> ... "." ... "not" ... "in" ... "tequals" ... "before" ... "after" ... "during" ... "*" ... "/" ... "+" ... "-" ... "like" ... "ilike" ... "exists" ... "does-not-exist" ... "is" ... "between" ... "=" ... ">" ... "<" ... ">=" ... "<=" ... "<>" ... Parsing : STYLE.


Is there any way to get style information from database ?










share|improve this question


























    up vote
    1
    down vote

    favorite












    I would like to get style (sld or css does not matter, but prefer css) from sql view layer but I couldn' t achieve this.
    here is my sql view for layer



    select 
    value,
    location,
    'mark: symbol(square);mark-size: 6px;:mark {fill: #0099cc;}' STYLE
    from TABLE t


    And here is my style:



    /* @title point */
    * {
    [STYLE]
    }


    When I preview the layer I get following error:



    org.parboiled.errors.ParserRuntimeException: Error at line 3. Encountered "<EOF>" at line 1, column 5. Was expecting one of: "(" ... ":" ... <IDENTIFIER> ... "." ... "not" ... "in" ... "tequals" ... "before" ... "after" ... "during" ... "*" ... "/" ... "+" ... "-" ... "like" ... "ilike" ... "exists" ... "does-not-exist" ... "is" ... "between" ... "=" ... ">" ... "<" ... ">=" ... "<=" ... "<>" ... Parsing : STYLE.


    Is there any way to get style information from database ?










    share|improve this question
























      up vote
      1
      down vote

      favorite









      up vote
      1
      down vote

      favorite











      I would like to get style (sld or css does not matter, but prefer css) from sql view layer but I couldn' t achieve this.
      here is my sql view for layer



      select 
      value,
      location,
      'mark: symbol(square);mark-size: 6px;:mark {fill: #0099cc;}' STYLE
      from TABLE t


      And here is my style:



      /* @title point */
      * {
      [STYLE]
      }


      When I preview the layer I get following error:



      org.parboiled.errors.ParserRuntimeException: Error at line 3. Encountered "<EOF>" at line 1, column 5. Was expecting one of: "(" ... ":" ... <IDENTIFIER> ... "." ... "not" ... "in" ... "tequals" ... "before" ... "after" ... "during" ... "*" ... "/" ... "+" ... "-" ... "like" ... "ilike" ... "exists" ... "does-not-exist" ... "is" ... "between" ... "=" ... ">" ... "<" ... ">=" ... "<=" ... "<>" ... Parsing : STYLE.


      Is there any way to get style information from database ?










      share|improve this question













      I would like to get style (sld or css does not matter, but prefer css) from sql view layer but I couldn' t achieve this.
      here is my sql view for layer



      select 
      value,
      location,
      'mark: symbol(square);mark-size: 6px;:mark {fill: #0099cc;}' STYLE
      from TABLE t


      And here is my style:



      /* @title point */
      * {
      [STYLE]
      }


      When I preview the layer I get following error:



      org.parboiled.errors.ParserRuntimeException: Error at line 3. Encountered "<EOF>" at line 1, column 5. Was expecting one of: "(" ... ":" ... <IDENTIFIER> ... "." ... "not" ... "in" ... "tequals" ... "before" ... "after" ... "during" ... "*" ... "/" ... "+" ... "-" ... "like" ... "ilike" ... "exists" ... "does-not-exist" ... "is" ... "between" ... "=" ... ">" ... "<" ... ">=" ... "<=" ... "<>" ... Parsing : STYLE.


      Is there any way to get style information from database ?







      gis openlayers-3 geoserver openlayers-5






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 22 at 6:38









      demdem

      7311




      7311
























          1 Answer
          1






          active

          oldest

          votes

















          up vote
          0
          down vote













          I don't think it is possible (as is supported by your issue). You can of course read individual values from the database and use them wherever an expression is allowed in the style.






          share|improve this answer





















          • I know it can be done by assinging individual value but if it exists it would be good feature.
            – demdem
            Nov 26 at 18:12










          • that would make the parser very hard though
            – Ian Turton
            Nov 29 at 8:50











          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',
          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%2f53425160%2fhow-to-get-style-from-layer-in-geoserver%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








          up vote
          0
          down vote













          I don't think it is possible (as is supported by your issue). You can of course read individual values from the database and use them wherever an expression is allowed in the style.






          share|improve this answer





















          • I know it can be done by assinging individual value but if it exists it would be good feature.
            – demdem
            Nov 26 at 18:12










          • that would make the parser very hard though
            – Ian Turton
            Nov 29 at 8:50















          up vote
          0
          down vote













          I don't think it is possible (as is supported by your issue). You can of course read individual values from the database and use them wherever an expression is allowed in the style.






          share|improve this answer





















          • I know it can be done by assinging individual value but if it exists it would be good feature.
            – demdem
            Nov 26 at 18:12










          • that would make the parser very hard though
            – Ian Turton
            Nov 29 at 8:50













          up vote
          0
          down vote










          up vote
          0
          down vote









          I don't think it is possible (as is supported by your issue). You can of course read individual values from the database and use them wherever an expression is allowed in the style.






          share|improve this answer












          I don't think it is possible (as is supported by your issue). You can of course read individual values from the database and use them wherever an expression is allowed in the style.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 26 at 15:03









          Ian Turton

          4,36111732




          4,36111732












          • I know it can be done by assinging individual value but if it exists it would be good feature.
            – demdem
            Nov 26 at 18:12










          • that would make the parser very hard though
            – Ian Turton
            Nov 29 at 8:50


















          • I know it can be done by assinging individual value but if it exists it would be good feature.
            – demdem
            Nov 26 at 18:12










          • that would make the parser very hard though
            – Ian Turton
            Nov 29 at 8:50
















          I know it can be done by assinging individual value but if it exists it would be good feature.
          – demdem
          Nov 26 at 18:12




          I know it can be done by assinging individual value but if it exists it would be good feature.
          – demdem
          Nov 26 at 18:12












          that would make the parser very hard though
          – Ian Turton
          Nov 29 at 8:50




          that would make the parser very hard though
          – Ian Turton
          Nov 29 at 8:50


















          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.





          Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


          Please pay close attention to the following guidance:


          • 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%2f53425160%2fhow-to-get-style-from-layer-in-geoserver%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

          Berounka

          Fiat S.p.A.

          Type 'String' is not a subtype of type 'int' of 'index'