QgsQueryBuilder Class Reference

Query Builder for layers. More...

#include <qgsquerybuilder.h>

Public Slots
void	accept () override
void	clear ()
void	on_btnAnd_clicked ()
void	on_btnEqual_clicked ()
void	on_btnGetAllValues_clicked ()
void	on_btnGreaterEqual_clicked ()
void	on_btnGreaterThan_clicked ()
void	on_btnILike_clicked ()
void	on_btnIn_clicked ()
void	on_btnLessEqual_clicked ()
void	on_btnLessThan_clicked ()
void	on_btnLike_clicked ()
void	on_btnNot_clicked ()
void	on_btnNotEqual_clicked ()
void	on_btnNotIn_clicked ()
void	on_btnOr_clicked ()
void	on_btnPct_clicked ()
void	on_btnSampleValues_clicked ()
void	on_buttonBox_helpRequested ()
void	on_lstFields_clicked (const QModelIndex &index)
void	on_lstFields_doubleClicked (const QModelIndex &index)
void	on_lstValues_doubleClicked (const QModelIndex &index)
void	reject () override
void	setDatasourceDescription (QString uri)
void	setSql (QString sqlStatement)
QString	sql ()
void	test ()

Public Member Functions
	QgsQueryBuilder (QgsVectorLayer *layer, QWidget *parent=0, Qt::WindowFlags fl=QgisGui::ModalDialogFlags)
	~QgsQueryBuilder ()
void	showEvent (QShowEvent *event) override

Detailed Description

Query Builder for layers.

The query builder allows interactive creation of a SQL for limiting the features displayed in a database layer. The fields in the table are displayed and sample values (or all values) can be viewed to aid in constructing the query. A test function returns the number of features that will be returned.

Definition at line 40 of file qgsquerybuilder.h.

Constructor & Destructor Documentation

QgsQueryBuilder::QgsQueryBuilder	(	QgsVectorLayer *	layer,
		QWidget *	parent = 0,
		Qt::WindowFlags	fl = QgisGui::ModalDialogFlags
	)

This constructor is used when the query builder is called from the vector layer properties dialog

Parameters

layer	existing vector layer
parent	Parent widget
fl	dialog flags

Definition at line 27 of file qgsquerybuilder.cpp.

QgsQueryBuilder::~QgsQueryBuilder

(

)

Definition at line 58 of file qgsquerybuilder.cpp.

Member Function Documentation

void QgsQueryBuilder::accept ( )

overrideslot

Definition at line 224 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::clear ( )

slot

Definition at line 378 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_btnAnd_clicked ( )

slot

Definition at line 360 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_btnEqual_clicked ( )

slot

Definition at line 256 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_btnGetAllValues_clicked ( )

slot

Get all distinct values for the field. Values are inserted into the value list box

Definition at line 167 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_btnGreaterEqual_clicked ( )

slot

Definition at line 348 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_btnGreaterThan_clicked ( )

slot

Definition at line 268 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_btnILike_clicked ( )

slot

Definition at line 385 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_btnIn_clicked ( )

slot

Definition at line 280 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_btnLessEqual_clicked ( )

slot

Definition at line 342 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_btnLessThan_clicked ( )

slot

Definition at line 262 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_btnLike_clicked ( )

slot

Definition at line 292 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_btnNot_clicked ( )

slot

Definition at line 366 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_btnNotEqual_clicked ( )

slot

Definition at line 354 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_btnNotIn_clicked ( )

slot

Definition at line 286 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_btnOr_clicked ( )

slot

Definition at line 372 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_btnPct_clicked ( )

slot

Definition at line 274 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_btnSampleValues_clicked ( )

slot

Get sample distinct values for the selected field. The sample size is limited to an arbitrary value (currently set to 25). The values are inserted into the values list box.

Definition at line 140 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_buttonBox_helpRequested ( )

inlineslot

Definition at line 81 of file qgsquerybuilder.h.

void QgsQueryBuilder::on_lstFields_clicked ( const QModelIndex &  index )

slot

Definition at line 308 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_lstFields_doubleClicked ( const QModelIndex &  index )

slot

Definition at line 321 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::on_lstValues_doubleClicked ( const QModelIndex &  index )

slot

Definition at line 327 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::reject ( )

overrideslot

Definition at line 248 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::setDatasourceDescription ( QString  uri )

slot

Definition at line 391 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::setSql ( QString  sqlStatement )

slot

Definition at line 303 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::showEvent ( QShowEvent *  event )

override

Definition at line 64 of file qgsquerybuilder.cpp.

QString QgsQueryBuilder::sql ( )

slot

Definition at line 298 of file qgsquerybuilder.cpp.

void QgsQueryBuilder::test ( )

slot

Test the constructed sql statement to see if the database likes it. The number of rows that would be returned is displayed in a message box. The test uses a "select count(*) from ..." query to test the SQL statement.

Definition at line 194 of file qgsquerybuilder.cpp.

---

The documentation for this class was generated from the following files:

• /tmp/buildd/qgis-2.8.2+12wheezy/src/gui/qgsquerybuilder.h
• /tmp/buildd/qgis-2.8.2+12wheezy/src/gui/qgsquerybuilder.cpp