Improve test advanced query

Outsystem MVP, Outsystems Expert developer, Senior consultant at CoolProfs

+ 14

#13

in Community Rank

Aggregates & Queries

Implemented

on 17 Feb 2014

OutSystems 8.0

The test-query fails executing when you expand a parameter as a tablename.
This is logic you *CAN* use so it should be able to work in test.
It works fine when using it runtime

@tablename = "FooBarEntity" wiuth expand-inline to true

SELECT atn.Id, atn.Name
FROM {@tablename}

Created on 28 Nov 2013

Comments (1)

Luka Jurukovksi

7 Jul 2014

Luka Jurukovksi

#19 120

in Community Rank

Hello, I am trying this out in 8.0.0.24 and it seems like it is not expanding the table name (its querying oracle with @tablename instead of the input) in either the test or at runtime. I tried writing it all different ways and none of them worked. Did you have to do anything in paticular in order to get this to work or does my version not support it?

views

521

Followers

Training

Documentation

Improve test advanced query