Gasoline Truck

V1.1
1.0 First version
1.1 Add simulation mode
Register you query, test it, and then access it via a REST API Call
List query
. Loading..
QueryID SqlQuery Datasource
{{queryinfo.id}} {{queryinfo.sql}} {{queryinfo.datasource}}

Query

QueryId: Expl:
Sql:

TIPS: use : to set a parameters, like select * from country where age = :myage and title = :title

Attention, the size of SqlRequest + Result : a custom page work in HTTP GET so limit is about 2K-8K
Datasource:
TIPS: a datasource sould be java:comp/env/NotManagedBizDataDS		 Delay: ms
Profile:
User must be registered in this profile to run the query. Empty for public query

Tests

Sql:

TIPS: use : to set a parameters, like select * from country where age = :myage and title = :title

Parameters:

TIPS : give all parameters, like myage=34&title=Mr

RestAPI:/bonita/portal/custom-page/custompage_gasolinetruck/?page=custompage_gasolinetruck&queryId={{gasolinectrl.currentquery.id}}&{{gasolinectrl.currentquery.testparameters}}

. Executing..
Executed in {{gasolinectrl.resulttestquery.stats}} ms

JSON List

{{gasolinectrl.resulttestquery.rows}}
{{col}}
{{resulttest[ col ]}}

Simulation

Mode:
Result:

Attention, the size of SqlRequest + Result : a custom page work in HTTP GET so limit is about 2K-8K
Delay: ms