Author Topic: Call a procedure in a custom search? (Read 506 times)

ryeradio · February 06, 2013, 06:06:37 am

Hi I have a custom search that I am trying to create. The SQL has a union statement, so I wasn't sure how to put that type of code into the php file. So I thought I would create a stored procedure. I created the stored procedure with a parameter and it works great, but can I call a stored procedure in a custom search file? If so where would I put that?

Thanks!

Donald Lobo · February 06, 2013, 08:40:25 am

the custom search interface does not impose restrictions on the type of sql statement used. I think the only restriction is it returns one sql statement, and you can accomplish this by using temp tables and return a select * on the temp table as the final result (in case of complex searches)

check:

CRM/Contact/Form/Search/Custom/Group.php

for a more complex query search

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: Call a procedure in a custom search? (Read 506 times)

ryeradio

Call a procedure in a custom search?

Donald Lobo

Re: Call a procedure in a custom search?