Access to SIGADW Query through Static Link
Functionality specific to publish queries without accessing SIGADW or Smart Client. This access can be either through a static link in corporate intranet or extranet, or even published directly in the Internet.
Configuring
By default, this functionality is disabled. Besides, to enable the access to queries from a link (available in any page, for example), the following configurations are required:
| 1) | Define a user for this type of access (the privileges of this user are checked). |
| 2) | After configuration above, you must define which queries can be accessed this way. For this, enable the option Enable Access Through URL in each one of the queries provided through static link. |
After these configurations, the access to perform queries from an URL is available, without being inside SIGADW or inside the Smart Client.
Accessing
To make the access, you must follow a standard to create the URL to be run, according to the explanation below:
http://<WEBHOST>/w_sigadw3.apw?action=queryExec&dwacesss=dwexecurl&dw=<DwName>&id=<ConsultaID>&oper=6&info=<ConsultaTipo>&cache=0
Where the parameters that must be changed are:
| • | <WEBHOST> = SIGADW Webhost (add virtual directory, if there is any). Ex: http://bi-totvs:8090/dw/ |
| • | <DwName> = DW Name |
| • | <QueryID> = ID/identifier of query |
| • | <QueryType> = Type of Query: 1(table) or 2(chart) |
Example:
http://bi-totvs:8090/dw/dw/w_sigadw3.apw?action=queryExec&dwacesss=dwexecurl&dw=NATIVOS&id=1142&oper=6&info=1&cache=0
To identify the ID of a query, access the editing of query properties, then, an ID field is displayed. |
