Book a Demo

Author Topic: Parameterized custom SQL search & model document  (Read 3180 times)

Max Widen

  • EA Novice
  • *
  • Posts: 15
  • Karma: +0/-0
    • View Profile
Parameterized custom SQL search & model document
« on: July 23, 2014, 04:43:15 pm »
Dear All,

Faced this issue while trying EA11, build 1107:

1. Create custom SQL search "MySearch" with the statement
Code: [Select]
SELECT ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE, Name FROM t_object WHERE t_object.Name='<Search Term>'
2. Add Requirement element to project. Name new element 'MY_SEARCH_TEST'

3. Create new master document 'TEST MASTER DOC'

4. Add new model document to 'TEST MASTER DOC', fill model document's tagged values as follows:
Code: [Select]
SearchName=MySearch
SearchValue=MY_SEARCH_TEST

5. Run RTF report on 'TEST MASTER DOC'

6. No report is generated. Message 'SQL Search selected or zero results returned' is displayed in the output window.

On running the same search manually with the same search term I get no error and 'MY_SEARCH_TEST' element is selected.

Using non-parameterized search as model document data source returns no errors and report is generated as expected.

Reproducing steps 1-6 in EA8 returns no errors and report is generated as expected

What am I doing wrong? Isn't it a kind of bug?

Thank you!