ACD100 Exam QuestionsBrowse all questions from this exam

ACD100 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?

Show Answer
Correct Answer: AB

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

3 comments
Sign in to comment
KapilR
May 9, 2023

A or B which should be ans?

ark143Option: A
Aug 1, 2023

A is the answer

XfrankXOption: B
Oct 27, 2023

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