Exam ACD100 All QuestionsBrowse all questions from this exam
Question 11

You need to query some data from the database using more than one filter.

Which parameter for a!query() should you use to define your filters?

    Correct Answer: A

    When querying data from the database using multiple filters, you should use the 'filter' parameter in the function a!query(). This parameter allows you to define one or more conditions that the data must meet, enabling the application of multiple filters efficiently in a query.

Discussion
XfrankXOption: B

The answer is B. Just a bit of code to prove that it should be LogicalExpression: a!queryEntity( entity: cons!EntityName, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "configurationItemId", operator: "=", value: ri!configurationItemId ), a!queryFilter( field: "accessLevelId", operator: "=", value: ri!accessLevelId ), etc. The FILTER answer is good if you want to filter on the output of the query, but in this case that's not the question. Answer is B

ark143Option: A

A is the answer

KapilR

A or B which should be ans?