Author Topic: RTF report filter / Query Builder data type mismatch in criteria expression  (Read 3802 times)

Jens Nötzold

  • EA User
  • **
  • Posts: 21
  • Karma: +0/-0
    • View Profile
Hi,

I get an error

DAO.Database [3464] Data type mismatch in criteria expression

when setting up an element filter on RTF template document options to render
- only elements having tests of testclass one of 1,2,3,4,5
- and only element test of  testclass one of 1,2,3,4,5
(otherway : want to exclude elements without tests or testclass = 6)

Setting up a filter criteria on t_objecttests.testclass is not working,
- neither from Document Options->Element Filters
- nor from Document Options->Other Filters
- nor from Find in Project->Query Builder

None of the operators EqualTo, Not Equals, One Of can be used, no chance for the user to input the correct type to avoid the problem!

The error persists in EA 12.0.1212, 12.1.1229, 13.0.1306
Its a very frustrating one as it prevents us from running test reports!

Any help on this is welcome to get around this.

Cheers,
Jens Nötzold

Jens Nötzold

  • EA User
  • **
  • Posts: 21
  • Karma: +0/-0
    • View Profile
Update:

Sparx support says:
"This has been confirmed by hte devlopers and will be fixed in a future
build of EA.

As a workaround you could create a Custom SQL Fragment template for this
purpose."