how to get style from layer in geoserver












1















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



























    1















    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

























      1












      1








      1








      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 '18 at 6:38









      demdemdemdem

      7311




      7311
























          1 Answer
          1






          active

          oldest

          votes


















          0














          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 '18 at 18:12











          • that would make the parser very hard though

            – Ian Turton
            Nov 29 '18 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',
          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%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









          0














          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 '18 at 18:12











          • that would make the parser very hard though

            – Ian Turton
            Nov 29 '18 at 8:50
















          0














          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 '18 at 18:12











          • that would make the parser very hard though

            – Ian Turton
            Nov 29 '18 at 8:50














          0












          0








          0







          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 '18 at 15:03









          Ian TurtonIan Turton

          4,61611834




          4,61611834













          • I know it can be done by assinging individual value but if it exists it would be good feature.

            – demdem
            Nov 26 '18 at 18:12











          • that would make the parser very hard though

            – Ian Turton
            Nov 29 '18 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 '18 at 18:12











          • that would make the parser very hard though

            – Ian Turton
            Nov 29 '18 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 '18 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 '18 at 18:12













          that would make the parser very hard though

          – Ian Turton
          Nov 29 '18 at 8:50





          that would make the parser very hard though

          – Ian Turton
          Nov 29 '18 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.




          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

          android studio warns about leanback feature tag usage required on manifest while using Unity exported app?

          SQL update select statement

          'app-layout' is not a known element: how to share Component with different Modules