Automated Testing Framework (ATF) - Record Query with "contains" issue

[chrissquires1]

Hello everyone,

We have been having a blast testing out the capabilities of ATF.   One issue we have run into though is with Record Query and the "contains" filter option.

If we query, for example, the sys_email table looking for a result from a previous step (like an Incident number) in the subject line the query will fail.

However, if we use a server-side script to build a string that includes the result from the previous step that exactly matches the email subject line it will pass.

What's even more interesting is if we query with contains for just a string value (ie, Subject contains 'opened on your behalf') the query passes but returns a ton of results.

The goal is to limit the query to one and only one result while passing the incident number from a prior step.

The query looks something like this:

Subject contains {{Step 8: Run Server Side Script.Record}}

Where the Server Side script record_id is overridden with the display value of the incident record.   This query will fail.

If we update the server side script to pass the full subject line (Incident INC000XXXX has been opened on your behalf) then the same query above will pass.

Has anyone else run into nuances like this with ATF?

[Priya164]

Hi,

Did you find solution for the above? If yes please share it. Thank you