[Bug 1496820] [NEW] Unable to create NEW sql view (allow variables) with variable in place of column name

Support - Assistance technique
1

Public bug reported:

Using v2.20 unable to create new SQL view of type "SQL query (allows for
variables)" where a variable is specified in place of table field/column
name.

Steps:
1. Create new SQL View of type "SQL query (allows for variables)"
2. use SQL statement: select * from _organisationunitgroupsetstructure where "${column1}" = '${value1}';
3. you cannot save until you replace "${column1}" with something relevant, e.g. "OrgUnitType"

Only once saved can you revert back to your original SQL statement...

** Affects: dhis2
     Importance: Undecided
         Status: New

···

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1496820

Title:
  Unable to create NEW sql view (allow variables) with variable in place
  of column name

Status in DHIS:
  New

Bug description:
  Using v2.20 unable to create new SQL view of type "SQL query (allows
  for variables)" where a variable is specified in place of table
  field/column name.

  Steps:
  1. Create new SQL View of type "SQL query (allows for variables)"
  2. use SQL statement: select * from _organisationunitgroupsetstructure where "${column1}" = '${value1}';
  3. you cannot save until you replace "${column1}" with something relevant, e.g. "OrgUnitType"

  Only once saved can you revert back to your original SQL statement...

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1496820/+subscriptions

2

This is actually fixed in trunk, will backport.

** Changed in: dhis2
    Milestone: None => 2.21

** Changed in: dhis2
     Assignee: (unassigned) => Lars Helge Øverland (larshelge)

** Changed in: dhis2
   Importance: Undecided => Medium

** Changed in: dhis2
       Status: New => Confirmed

···

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1496820

Title:
  Unable to create NEW sql view (allow variables) with variable in place
  of column name

Status in DHIS:
  Confirmed

Bug description:
  Using v2.20 unable to create new SQL view of type "SQL query (allows
  for variables)" where a variable is specified in place of table
  field/column name.

  Steps:
  1. Create new SQL View of type "SQL query (allows for variables)"
  2. use SQL statement: select * from _organisationunitgroupsetstructure where "${column1}" = '${value1}';
  3. you cannot save until you replace "${column1}" with something relevant, e.g. "OrgUnitType"

  Only once saved can you revert back to your original SQL statement...

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1496820/+subscriptions

3

** Changed in: dhis2
       Status: Confirmed => Fix Committed

** Changed in: dhis2
       Status: Fix Committed => Fix Released

···

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1496820

Title:
  Unable to create NEW sql view (allow variables) with variable in place
  of column name

Status in DHIS:
  Fix Released

Bug description:
  Using v2.20 unable to create new SQL view of type "SQL query (allows
  for variables)" where a variable is specified in place of table
  field/column name.

  Steps:
  1. Create new SQL View of type "SQL query (allows for variables)"
  2. use SQL statement: select * from _organisationunitgroupsetstructure where "${column1}" = '${value1}';
  3. you cannot save until you replace "${column1}" with something relevant, e.g. "OrgUnitType"

  Only once saved can you revert back to your original SQL statement...

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1496820/+subscriptions