Querying the question_answer table for multiple task sys_ids

[ryanho]

Is there a way to query the question_answer table for more than one "Table sys id" at a time?  We're trying to export our change request dataset to an external system, and we want to get all of the variables for a certain set of Change Requests in a single call, but for some reason the we can't use the IN operator on the "Table sys id" field.

[Elijah Aromola]

The operator shows as "is one of" but the syntax is as shown below.

sys_idIN123,123,123

[Jaspal Singh]

Hi,

Unfortunately, you can't. You can create a database view and possible try applying a filter on the report you create on the database view.