• A Retrieve all records and then use an if-else block in X++ to filter the results programmatically.
  • B Create multiple versions of the query; one for each set of conditions, and execute them conditionally.
  • C Implement X++ variable scoping and use the QueryFilter class to add conditional filters to the query.
  • D Hard-code the filter conditions directly into the select statement of the query.