Saturday, July 14, 2018

Create a Query

A workflow uses a query to define the data that is used by the workflow. It can
define one or more tables and all or selected fields on that table.


Demonstration: Creating a Query

A query defines what tables are used to determine that a workflow can be
initiated. Use a class to bind that query to the workflow type. Perform the
following steps to create a query.


1. Open the
AOT.

2. Right
-click on the Queries node and select New Query.

3. Rename the query to
SalesCreditLimitApproval.

4. Expand the newly created query.


5. Open another
AOT window.

6. Expand
Data Dictionary > Tables.

7. Find the table
SalesTable.

8. Drag the
SalesTable table to the Data Sources node of theSalesCreditLimitApproval query.

9. Expand the
SalesTable_1 node

10. Right-click on the
Fields node and select Properties.

11. Set the Dynamics property to
Yes and close the property sheet.

12. Right click on the
SalesCreditLimitApproval query and select
Save. 

Best Regards,
Hossein Karimi

No comments:

Post a Comment

Configure the Firewall on the Enterprise Portal Server

After you install Enterprise Portal, enable Web Server (HTTP) in Windows Firewall. If you do not enable the web server in Windows Firewall...