« previous next »
Pages: [1]

Author Topic: Does Custom SQL Search support stored procedures?  (Read 2025 times)

Dave_Bullet

  • EA User
  • **
  • Posts: 295
  • Karma: +0/-0
    • View Profile
Does Custom SQL Search support stored procedures?
« on: January 26, 2009, 02:27:53 pm »
One of my users wants to be able to search on a tagged value, and return a list of elements, and for each element, a comma separated list of elements they related to.

The above cannot be done with a single / simple select statement.  It can however be done using SQL variables or via a stored procedure call.

Is there any way I can get a custom SQL Search to support calling a stored procedure? (Sparx?)

Thanks,
David.
« Last Edit: January 26, 2009, 02:28:41 pm by Dave_Bullet »
Logged
"I know I'm close to a good design, but it's like the balloon animals, squeeze in one spot and the problem moves down the line"
Pages: [1]
« previous next »