Hfrhyu

Do I really need recursive chmod to restrict access to a folder?

51k Euros annually for a family of 4 in Berlin: Is it enough?

At the end of Thor: Ragnarok why don't the Asgardians turn and head for the Bifrost as per their original plan?

How would the world control an invulnerable immortal mass murderer?

What exactly is a "Meth" in Altered Carbon?

Denied boarding although I have proper visa and documentation. To whom should I make a complaint?

Why did the rest of the Eastern Bloc not invade Yugoslavia?

Why was the term "discrete" used in discrete logarithm?

Sci-Fi book where patients in a coma ward all live in a subconscious world linked together

How to tell that you are a giant?

Resolving to minmaj7

Is it true that "carbohydrates are of no use for the basal metabolic need"?

How discoverable are IPv6 addresses and AAAA names by potential attackers?

String `!23` is replaced with `docker` in command line

The logistics of corpse disposal

Is pollution the main cause of Notre Dame Cathedral's deterioration?

How to bypass password on Windows XP account?

How does the particle を relate to the verb 行く in the structure「A を + B に行く」?

How do I stop a creek from eroding my steep embankment?

Can a USB port passively 'listen only'?

What LEGO pieces have "real-world" functionality?

Dating a Former Employee

How do database operations (write, update, alter) on particular cell in a table are written to disk without overwriting entire file?

Is there a node or combination of nodes that can take an average colour out of a single image?

Run database query based on selection in QGIS

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

2

1

I'm trying to figure out the best approach to achieve the following:

1. A user selects a single or group of features.


2. Option to access a popup box with a set of dropdowns populated by DB query.


3. The user saves, and a database query is run.


4. PostGIS layers are refreshed.

One thing to note is that the PostGIS layer the user will be selecting features from is a view query, so the update needs to be made to different tables.

Could anyone point me in the right direction of what to research/look at? I'm wondering if I would have to write a plugin?

postgis qgis-3

share|improve this question

edited Apr 9 at 17:33

Vince

14.8k32850

asked Apr 9 at 17:24

user3412user3412

111

add a comment | 

2

1

I'm trying to figure out the best approach to achieve the following:

1. A user selects a single or group of features.


2. Option to access a popup box with a set of dropdowns populated by DB query.


3. The user saves, and a database query is run.


4. PostGIS layers are refreshed.

One thing to note is that the PostGIS layer the user will be selecting features from is a view query, so the update needs to be made to different tables.

Could anyone point me in the right direction of what to research/look at? I'm wondering if I would have to write a plugin?

postgis qgis-3

share|improve this question

edited Apr 9 at 17:33

Vince

14.8k32850

asked Apr 9 at 17:24

user3412user3412

111

add a comment | 

I'm trying to figure out the best approach to achieve the following:

1. A user selects a single or group of features.


2. Option to access a popup box with a set of dropdowns populated by DB query.


3. The user saves, and a database query is run.


4. PostGIS layers are refreshed.

One thing to note is that the PostGIS layer the user will be selecting features from is a view query, so the update needs to be made to different tables.

Could anyone point me in the right direction of what to research/look at? I'm wondering if I would have to write a plugin?

postgis qgis-3

share|improve this question

edited Apr 9 at 17:33

Vince

14.8k32850

asked Apr 9 at 17:24

user3412user3412

111

share|improve this question

edited Apr 9 at 17:33

Vince

14.8k32850

asked Apr 9 at 17:24

user3412user3412

111

share|improve this question

edited Apr 9 at 17:33

Vince

14.8k32850

asked Apr 9 at 17:24

user3412user3412

111

edited Apr 9 at 17:33

Vince

14.8k32850

edited Apr 9 at 17:33

Vince

14.8k32850

asked Apr 9 at 17:24

user3412user3412

111

asked Apr 9 at 17:24

user3412user3412

111

1 Answer
1

active

oldest

votes

2

Without coding a plugin (although it can do exactly what is wanted in terms of algorithm, query and design), I think it's possible to achieve what you want with the QGIS interface for just one feature selected. For a group of features, I think the only way (for have a dialog with comboboxes that update selected datas) is a PyQGIS plugin.

If you want to develop a QGIS plugin, take a look at useful plugins :

• Plugin Builder (for create with few clicks base files for a working plugin)


• Plugin Reloader (reload the developed plugin without quit QGIS)

For software :

• Qt Creator for edit the .ui dialog interface file (software package with QGIS installation)


• Qt Assistant for documentation of Qt object classes

For code :

• Python 3 and QGIS Python API
  


• PyQt (for connection with database, I recommand you to look at QSqlQuery Qt class.

share|improve this answer

answered Apr 9 at 21:10

J. MonticoloJ. Monticolo

1,952319

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f318272%2frun-database-query-based-on-selection-in-qgis%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

2

Without coding a plugin (although it can do exactly what is wanted in terms of algorithm, query and design), I think it's possible to achieve what you want with the QGIS interface for just one feature selected. For a group of features, I think the only way (for have a dialog with comboboxes that update selected datas) is a PyQGIS plugin.

If you want to develop a QGIS plugin, take a look at useful plugins :

• Plugin Builder (for create with few clicks base files for a working plugin)


• Plugin Reloader (reload the developed plugin without quit QGIS)

For software :

• Qt Creator for edit the .ui dialog interface file (software package with QGIS installation)


• Qt Assistant for documentation of Qt object classes

For code :

• Python 3 and QGIS Python API
  


• PyQt (for connection with database, I recommand you to look at QSqlQuery Qt class.

share|improve this answer

answered Apr 9 at 21:10

J. MonticoloJ. Monticolo

1,952319

add a comment | 

2

Without coding a plugin (although it can do exactly what is wanted in terms of algorithm, query and design), I think it's possible to achieve what you want with the QGIS interface for just one feature selected. For a group of features, I think the only way (for have a dialog with comboboxes that update selected datas) is a PyQGIS plugin.

If you want to develop a QGIS plugin, take a look at useful plugins :

• Plugin Builder (for create with few clicks base files for a working plugin)


• Plugin Reloader (reload the developed plugin without quit QGIS)

For software :

• Qt Creator for edit the .ui dialog interface file (software package with QGIS installation)


• Qt Assistant for documentation of Qt object classes

For code :

• Python 3 and QGIS Python API
  


• PyQt (for connection with database, I recommand you to look at QSqlQuery Qt class.

share|improve this answer

answered Apr 9 at 21:10

J. MonticoloJ. Monticolo

1,952319

add a comment | 

Without coding a plugin (although it can do exactly what is wanted in terms of algorithm, query and design), I think it's possible to achieve what you want with the QGIS interface for just one feature selected. For a group of features, I think the only way (for have a dialog with comboboxes that update selected datas) is a PyQGIS plugin.

If you want to develop a QGIS plugin, take a look at useful plugins :

• Plugin Builder (for create with few clicks base files for a working plugin)


• Plugin Reloader (reload the developed plugin without quit QGIS)

For software :

• Qt Creator for edit the .ui dialog interface file (software package with QGIS installation)


• Qt Assistant for documentation of Qt object classes

For code :

• Python 3 and QGIS Python API
  


• PyQt (for connection with database, I recommand you to look at QSqlQuery Qt class.

share|improve this answer

answered Apr 9 at 21:10

J. MonticoloJ. Monticolo

1,952319

share|improve this answer

answered Apr 9 at 21:10

J. MonticoloJ. Monticolo

1,952319

answered Apr 9 at 21:10

J. MonticoloJ. Monticolo

1,952319

answered Apr 9 at 21:10

J. MonticoloJ. Monticolo

1,952319