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
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
