Gasoline Truck

List query

. Loading..

	QueryID	SqlQuery	Datasource
	{{queryinfo.id}}	{{queryinfo.sql}}	{{queryinfo.datasource}}

Query {{gasolinectrl.currentquery.id}}

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:

Profile:

User must be registered in one of this profile to run the query. Empty for public query. Use comma to separate as "User, Voyageur, Monitor"
Existing profiles: {{gasolinectrl.listprofiles}}

. .

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&action=query&queryId={{gasolinectrl.currentquery.id}}&{{gasolinectrl.testparameters}}

. Saving..

. Executing..

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

JSON List

{{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

Gasoline Truck V1.4
1.0 First version 1.1 Add simulation mode 1.3 7.5 and Wildfly ready 1.4 BonitaProperties 1.6 for Oracle and Sqlserver & avoid BonitaCache Policy 1.5 BonitaProperties 1.6.1
Register you query, test it, and then access it via a REST API Call