View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000080 | Oberon Platform | OOQL language | public | 2012-09-20 19:33 | 2012-09-30 17:54 |
| Reporter | g_prajeesh | Assigned To | administrator | ||
| Priority | high | Severity | feature | Reproducibility | N/A |
| Status | resolved | Resolution | fixed | ||
| Target Version | 4.0 - DB build 0070 | Fixed in Version | 4.0 - DB build 0070 | ||
| Summary | 0000080: Like to have variable substitution in query | ||||
| Description | It will be nice to have variable substitution feature in query like sql prepare. While define the query, I can define the query as follows query define "TestQuery" Branch Branch-* '-' filter(field[x]!= $my_var); while executing the query query execute "TestQuery" get{id fieldValues} input{$my_var='prajeesh'} token xml; | ||||
| Tags | No tags attached. | ||||
|
|
Query definition: query define "TestQuery" object Branch Branch-* '-' filter (field[x] != $var1 && field[y] == $var2); Query execution: query execute "TestQuery" vars $var1 = 100 $var2 = "my value" get {id fieldValues} token xml; |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-09-20 19:33 | g_prajeesh | New Issue | |
| 2012-09-21 14:05 | administrator | Assigned To | => administrator |
| 2012-09-21 14:05 | administrator | Status | new => assigned |
| 2012-09-30 17:50 | administrator | Fixed in Version | => 3.1 - DB build 0068 |
| 2012-09-30 17:50 | administrator | Target Version | => 3.1 - DB build 0068 |
| 2012-09-30 17:53 | administrator | Note Added: 0000154 | |
| 2012-09-30 17:54 | administrator | Status | assigned => resolved |
| 2012-09-30 17:54 | administrator | Resolution | open => fixed |
