This condition forms the "where" clause in the SQL statement.Ī description of the rule. The condition that you create based on the table name, the field name, and a conditional operator. Update the selected rule or expression in the list in the Rule collection pane. An expression creates an "or" condition in the "where" clause of the SQL statement.Īdd the new rule or expression to the list in the Rule collection pane. An expression is a condition that is added to an existing rule. When you have multiple rules in the Purge Object or Archive Object, they form the "and" condition in the "where" clause of the SQL statement.Ĭreate a new expression. You are prompted to confirm the close or save your changes if you try to close the window without saving your changes.Ĭreate a new rule. Save the changes that you made to the list in the Rule collection pane to the database.Ĭlose the Add/Edit rules window. Lets you specify conditions, or the selection criteria, for the Purge Object. Also provides commands to add the rule to, or update it in, the list in the Rule collection pane. Provides an area to enter or modify the rule name, description, and conditions. Panes PaneĬontains a list of the rules in the Purge Object or Archive Object, and commands to create a new rule, add an expression to the existing rule, or delete a rule or an expression. The following tables provide descriptions for the controls in the Add/Edit rules window. On the toolbar, click Add/Edit rules to open the Add/Edit rules window. You must understand the effect of your rule on the Purge Object or Archive Object before applying any rule. Regardless of how you create these rules, the "where" clause always applies to the driver table. For example, the Purge Object ProdJournalTable includes a rule for the ProdTable, which is not the driver table. The rules generally apply to the driver table, but can also be applied to a related child table. This command lets you work with rules in a Purge Object or an Archive Object. Add/Edit rulesĪ rule is the criterion that is used to filter records when a purge task or an archive task runs. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans. For the latest documentation, see Microsoft Dynamics 365 product documentation. This content is archived and is not being updated.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |