OBEROn - Bug Trace - Oberon Platform
Viewing Issue Advanced Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
80 OOQL language feature N/A 2012-09-20 19:33 2012-09-30 17:54
Reporter: g_prajeesh Platform:  
Assigned To: administrator OS:  
Priority: high OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none 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;
Steps To Reproduce:
Additional Information:
Relationships
Attached Files:
Issue History
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

Notes
(0000154)
administrator   
2012-09-30 17:53   
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;