VERIFIED SOLUTION i
X

CONFIRM: Table which contains details about the Web Service of various Organisations

UPDATED: April 19, 2017


This can be easily located in the Data Dictionary provided with Confirm.

Table and Fields which contains details about the Web Service of various Organisations

Table Name:

dbo.Organisation

Field name with the web service address is: 

distrct_notify_url 

select distrct_notify_url, district_ref, * from organisation

We can further apply the conditions in where clause to limit the result set. This can help is creating a Data source.

Note: In Data Source we cannot use "*" in the query. 

 

Environment Details

Product Feature: Ad-hoc Reporting

Operating System: Windows 7

Database: SQL Server, Oracle
 

Downloads

  • No Downloads