Query Management permits you to directly query your
PortalProdigy database. You can save a
query for re-use, run a query to view data, and run a query to update data.
Query Management page:
- Queries
– Import Query: click on the
icon to open Import Query page.
- Queries
– Select Query: click on the
icon to open Select Query page.
- Queries
– Update Query: click on the
icon to open Update Query page.
Import Query page:
Use to upload a query to PortalProdigy. Uploaded queries can be used in Select Query
to view data and they can be used by Reports.
- Query
Name: click on the icon to open Import Query page.
- SQL
Statement: type or paste your SQL Statement here. SQL Statement can be either a Select or
Update statement. Be sure to
explicitly type table names for all field names.
E.g. Companies.CompanyName
If you include a WHERE clause use single quotes to delimit
all non-numeric values.
E.g. WHERE Companies.CompanyName
= ‘Canon’
Warning:
Do not use double quotes.
Double quotes can cause problems with parsing of your SQL Statement.
Import
button: click to save the SQL Statement. 
Close
button: click to close the page.
Select Query page:
Use to run a Select Query to view data.
- My
Queries: use to retrieve a Select query that was loaded using Import
Query feature. When you select a
query from the list box it will automatically be retrieved and displayed
in the SQL Statement memo field.
- System
Queries: use to retrieve a Select query that is included with the
PortalProdigy system. When you
select a query from the list box it will automatically be retrieved and displayed
in the SQL Statement memo field.
- SQL
Statement: you may type or paste your Select SQL Statement here. You may also use the My Queries or
System Queries options to retrieve a stored query. Be sure to explicitly type table names
for all field names.
E.g. Companies.CompanyName
If you include a WHERE clause use single quotes to delimit
all non-numeric values.
E.g. WHERE Companies.CompanyName
= ‘Canon’
Warning:
Do not use double quotes.
Double quotes can cause problems with parsing of your SQL Statement.
View
button: click to run the Select SQL Statement. The results are displayed as follows:
-
Clear
button: click to clear the page and make new selections.
- Close
button: click to close the page.
Update Query page:
Use to run an Update Query.
This feature should be used with extreme caution.
- Update
Queries: use to retrieve an update query that was loaded using Import
Query feature. When you select a
query from the list box it will automatically be retrieved and displayed
in the SQL Statement memo field.
- SQL
Statement: you may type or paste your Update SQL Statement here. You may also use the Update Queries
option to retrieve a stored query.
Be sure to explicitly type table names for all field names.
E.g. Companies.CompanyName
If you include a WHERE clause use single quotes to delimit
all non-numeric values.
E.g. WHERE Companies.CompanyName
= ‘Canon’
Warning:
Do not use double quotes.
Double quotes can cause problems with parsing of your SQL Statement.
Run button: click to run the Update
SQL Statement. A confirmation page
will be displayed informing you that the update was either successful or
unsuccessful. - Clear
button: click to clear the page and make new selections.
- Close
button: click to close the page.
