[Mapbender-users] Custom element that displays the result of a SQL query

[Astrid Emde]

Hello.

query-manager is a nice element, that is not part of Mapbender 3.0.6.1 
and will come in a future feature release.

Here you can have a look on how it looks like (slide 38 - "Analyse von 
Daten über den Query Manager"):
http://www.where2b-conference.com/sites/default/files/07_Where2B_Mapbender3_Features_in_Wesseling_AEmde.compressed.pdf
(Slides from last years presentation at Where2B in Bonn 
http://www.where2b-conference.com/)

So as you can see it maybe too much for your needs - you only want to 
display a short info "The value is:"  ([value]). It could make sense to 
write a new Mapbender element that runs your query and displays the 
value. An element like this does not exist yet.

Back to your question how you can integrate new repositories
* You can integrate other repositories via composer.json
* You should to follow the git based installation

Read more at:
https://github.com/mapbender/mapbender-starter/blob/release/3.0.6/CONTRIBUTING.md
* see part Create composer package

You find the composer.json here
* 
https://github.com/mapbender/mapbender-starter/blob/release/3.0.6/application/composer.json

     "require": {
          ...
         "mapbender/query-builder": "1.0.1",
     },

Read CONTRIBUTING.md to lear how to update repositories with

../composer.phar update -o or sh bootstrap

Please note that the documentation for query-builder is not online yet.

Best regards Astrid

Am 2017-05-31 01:37, schrieb Abrabacabra:
> I am a little confused on how to install the bundle and add the
> element in one of my applications.
> 
> I downloaded the source from the git repo and put it in
> _/vendor/mapbender/query-builder_.
> 
> Then I ran  _/composer.phar require __"mapbender/query-builder"._
> 
> It installed a few dependencies but failed near the end (I didn't
> wrote down the error :/). I ran the previous command another time and
> now it says that nothing was installed, nothing was updated and there
> is no error message.
> 
> Still can't see the element though..
> 
> I backed up the whole Mapbender folder before doing it, so I could do
> it again and provide more information if needed.
> 
> Anyway, am I missing something? Is it that simple to install the
> bundle?
> 
> On 2017-05-30 1:05 AM, Schepers, Benjamin wrote:
> 
>> Hi Pat,
>> 
>> mabybe this is what you want:
>> 
>> https://github.com/mapbender/query-builder
>> 
>> To be honest, I didn’t try it by myself. But I’d appreciate it,
>> if you try it and share your experiences ;-)
>> 
>> Regards
>> 
>> Ben
>> 
>> VON: Mapbender_users
>> [mailto:mapbender_users-bounces at lists.osgeo.org] IM AUFTRAG VON
>> Abrabacabra
>> GESENDET: Donnerstag, 25. Mai 2017 04:34
>> AN: mapbender_users at lists.osgeo.org
>> BETREFF: Re: [Mapbender-users] Custom element that displays the
>> result of a SQL query
>> 
>> I simply need to display, maybe in the toolbar or something, a
>> single dynamic numeric value based on the result of a query made to
>> the PostgreSQL database we use for the daily operations of the
>> organization.
>> 
>> It would be preceded by a string like: "The value is:"  ([value])
>> 
>> Is there a currently available element/bundle that allows us to do
>> that?
>> 
>> On 2017-05-24 4:30 AM, Uwe Seher wrote:
>> 
>>> Hello!
>>> 
>>> You should provide a little more information what you want to do.
>>> You can use different approches to solve this. In mapbender i
>>> think, you can use something like the search or the digitizer
>>> element. These can use a sql-query direct from mapbender. You only
>>> have to configure the database connection. But when you use a wms
>>> layer in the behind, a getfeatureinfo is maybe the better
>>> approach.
>>> 
>>> best regards
>>> Uwe Seher
>>> 
>>> _______________________________________________
>>> 
>>> Mapbender_users mailing list
>>> 
>>> Mapbender_users at lists.osgeo.org
>>> 
>>> https://lists.osgeo.org/mailman/listinfo/mapbender_users
>> 
>> _______________________________________________
>> Mapbender_users mailing list
>> Mapbender_users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/mapbender_users
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapbender_users

-- 
Mit freundlichen Grüßen

Astrid Emde
GIS-Consultant

---------------------------------------
Aufwind durch Wissen!
Qualifizierte OpenSource-GIS-Schulungen
bei der www.foss-academy.com
---------------------------------------

  Astrid Emde
  WhereGroup GmbH & Co.KG
  Eifelstraße 7
  53119 Bonn
  Germany

  Fon: +49(0)228 90 90 38 - 22
  Fax: +49(0)228 90 90 38 - 11

  astrid.emde at wheregroup.com
  www.wheregroup.com

  Folgen Sie der WhereGroup auf twitter: 
http://twitter.com/WhereGroup_com

Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
-------------------------------