[GRASS-dev] [GRASS GIS] #2766: it is not possible to set other column when working with v.db.join from gui

#2766: it is not possible to set other column when working with v.db.join from gui
---------------------------+-------------------------
Reporter: lfurtkevicova | Owner: grass-dev@…
     Type: defect | Status: new
Priority: blocker | Milestone: 7.1.0
Component: Database | Version: 7.0.1
Keywords: | CPU: x86-64
Platform: Linux |
---------------------------+-------------------------
Problem with joinig database table to a vector map table using v.db.join
from gui:
parameters `map`, `column` and `other_table` are OK, but it isn't possible
to set `other_column`

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2766&gt;
GRASS GIS <https://grass.osgeo.org>

#2766: GUI not able to create dropdown lists of columns for more than one map or
table
----------------------------+--------------------------
  Reporter: lfurtkevicova | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone: 7.2.0
Component: wxGUI | Version: 7.0.1
Resolution: | Keywords: column lists
       CPU: x86-64 | Platform: Linux
----------------------------+--------------------------
Changes (by mlennert):

* keywords: => column lists
* priority: blocker => normal
* component: Database => wxGUI

Comment:

Replying to [ticket:2766 lfurtkevicova]:
> Problem with joinig database table to a vector map table using v.db.join
from gui:
> parameters `map`, `column` and `other_table` are OK, but it isn't
possible to set `other_column`

This is a more general problem than only in v.db.join (see column and
to_column in v.distance or points_column option in v.vect.stats for
example): whenever you need to specify columns in two different maps, the
GUI cannot handle this. Only the columns of one map are in the list. I'm
no expert in the GUI, but I imagine the G_OPT_DB_COLUMN standard parser
option looks for columns in the map defined by G_OPT_V_MAP or
G_OPT_V_INPUT, but it can only handle one defined in this way.

This needs some fundamental solution in the wxgui, not a specific module.

In any case, the does not render the module unusable, even in the GUI, as
one can always type the column name.

So, I'm downgrading this to normal and changing the title of the bug.

Moritz

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2766#comment:2&gt;
GRASS GIS <https://grass.osgeo.org>

#2766: GUI not able to create dropdown lists of columns for more than one map or
table
----------------------------+--------------------------
  Reporter: lfurtkevicova | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone: 7.2.0
Component: wxGUI | Version: 7.0.1
Resolution: | Keywords: column lists
       CPU: x86-64 | Platform: Linux
----------------------------+--------------------------

Comment (by mlennert):

Replying to [comment:2 mlennert]:
> Replying to [ticket:2766 lfurtkevicova]:
> > Problem with joinig database table to a vector map table using
v.db.join from gui:
> > parameters `map`, `column` and `other_table` are OK, but it isn't
possible to set `other_column`
>
> This is a more general problem than only in v.db.join (see column and
to_column in v.distance or points_column option in v.vect.stats for
example): whenever you need to specify columns in two different maps, the
GUI cannot handle this. Only the columns of one map are in the list. I'm
no expert in the GUI, but I imagine the G_OPT_DB_COLUMN standard parser
option looks for columns in the map defined by G_OPT_V_MAP or
G_OPT_V_INPUT, but it can only handle one defined in this way.
>
> This needs some fundamental solution in the wxgui, not a specific
module.

IIUC the code, the issue is in the UpdateThread class in
gui/wxpython/gui_core/forms.py, where only one map is handled. But I don't
have enough expertise of that code to go much further.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2766#comment:3&gt;
GRASS GIS <https://grass.osgeo.org>

#2766: GUI not able to create dropdown lists of columns for more than one map or
table
----------------------------+--------------------------
  Reporter: lfurtkevicova | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone: 7.2.4
Component: wxGUI | Version: 7.0.1
Resolution: | Keywords: column lists
       CPU: x86-64 | Platform: Linux
----------------------------+--------------------------

Comment (by pvanbosgeo):

Just was bitten by this issue. Just as a further specification, this is
not only a problem if one wants to specify columns in two different maps,
but also when one wants to select two columns (as two separate variables)
from the same map.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2766#comment:9&gt;
GRASS GIS <https://grass.osgeo.org>