Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000080 [Oberon Platform] OOQL language feature N/A 2012-09-20 19:33 2012-09-30 17:54
Reporter g_prajeesh View Status public  
Assigned To administrator
Priority high Resolution fixed  
Status resolved   Product Version
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;
Additional Information
Tags No tags attached.
Attached Files

- Relationships

-  Notes
(0000154)
administrator (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;

- 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
© 2008-2013 Mirko Solazzi | Website Templates by IceTemplates.com
Please Read: Privacy Policy and Terms of Use

Powered by Mantis Bugtracker
Copyright © 2000 - 2008 Mantis Group