Gasoline Truck

V1.8.1
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 {{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: ms
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}}
. .
To see the REST API, see the Test tab

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:
  • Page deploy under a profile?
    		• /bonita/portal/custom-page/custompage_gasolinetruck?action=query&queryId={{gasolinectrl.currentquery.id}}&{{gasolinectrl.testparameters}}
  • Page deploy under an application?
    		• /bonita/portal/resource/app/<APP_NAME>/<PAGE_NAME>/content/?page=custompage_gasolinetruck&action=query&queryId=bo

    This REST API works correctly in a UIDesigner page. If you like to test it from scratch, pay attention to join the X-Bonita-API-Token in the REST CALL.
    . Saving..

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

    JSON List

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

    Simulation

    Mode:
    Result:

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