[Lizmap] Lizmap PostgreSQL search

G. Wagner, Wagner-IT info at wagner-it.de
Mon May 30 13:45:45 PDT 2022





database=xxxx       # here is the table lizmap_search included





The database is located on the same server



Von: G. Wagner, Wagner-IT <info at wagner-it.de> 
Gesendet: Montag, 30. Mai 2022 22:38
An: 'Etienne Trimaille' <etienne.trimaille at gmail.com>
Cc: 'Lizmap at lists.osgeo.org' <Lizmap at lists.osgeo.org>
Betreff: AW: [Lizmap] Lizmap PostgreSQL search


no, the users are not stored in a PG database. Access data to the DB are still in the QGIS file.


Von: Etienne Trimaille <etienne.trimaille at gmail.com <mailto:etienne.trimaille at gmail.com> > 
Gesendet: Montag, 30. Mai 2022 22:33
An: G. Wagner, Wagner-IT <info at wagner-it.de <mailto:info at wagner-it.de> >
Cc: Lizmap at lists.osgeo.org <mailto:Lizmap at lists.osgeo.org> 
Betreff: Re: [Lizmap] Lizmap PostgreSQL search




How is done the access to the database ? (is your Lizmap users stored in PG already or not)



Le lun. 30 mai 2022 à 22:19, G. Wagner, Wagner-IT <info at wagner-it.de <mailto:info at wagner-it.de> > a écrit :



I still miss the very simple and perfomant search with the "QuickFinder Plugin" from QGIS 2.x. That's why I still have some projects running with QGIS Server 2.18 and Lizmap 3.3.


Now I try again with the SQL search. The creation of the extension, function and the entries in the profiles.ini.php are clear.

Then I create a database with the specified columns [1]. But is this only one database for all possible searches of different projects? And there are all geometries included?


A "SELECT * FROM lizmap_search LIMIT 1;" is indeed successful from the PgAdmin or also from the QGIS DB management. But in the Lizmap client I get no search results.

Is there an example, maybe even with sample database?


Or is there still hope for a new QuickFinder plugin? I would also like to participate financially.






[1] https://docs.lizmap.com/3.5/en/publish/configuration/spatial_search.html




Lizmap mailing list
Lizmap at lists.osgeo.org <mailto:Lizmap at lists.osgeo.org> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/lizmap/attachments/20220530/019b6557/attachment.htm>

More information about the Lizmap mailing list