Gasoline Truck

Gasoline Truck V1.0
1.0 First version
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
Test

Query

QueryId:		Expl:
Sql:	TIPS: use : to set a parameters, like select from country where age = :myage and title = :title*
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 ]}}