StrataFrame Forum » StrataFrame Database Deployment Toolkit » Issues » Search Panel Not Functional

Search Panel Not Functional

William Fields — Fri, 25 Oct 2013 13:28:22 GMT

Hello,

I can't remember if the search feature in the DDT ever worked for me, but when I type something into the Find field and click on the search button, nothing happens... and all of the search options are checked.

???

RE: Search Panel Not Functional

StrataFrame Team — Fri, 25 Oct 2013 13:28:22 GMT

Oh yes. The search on the next DDT will be vastly expanded. The search on the current version was more of an afterthought.

RE: Search Panel Not Functional

William Fields — Fri, 25 Oct 2013 11:40:59 GMT

Thanks for the reply.

Will this be incorporated into the next DDT version?

RE: Search Panel Not Functional

StrataFrame Team — Fri, 25 Oct 2013 11:29:02 GMT

I just checked the dbo.Search_Query sproc, and it certainly doesn't check triggers. It only checks sprocs, functions, views, and deploy scripts. That's the bad news. The good news is that you can easily modify the stored procedure to return the extra results if necessary. You won't be able to double-click a trigger from the list and open it for editing, but at least it would return it in the results. You would need to edit the Search_Query sproc and add this before the "RESULT SET #1" comment at the bottom of the procedure:

INSERT INTO

@results

SELECT

5 search_Type,

TR.tr_pk search_PrimaryKey,

T.tbl_schema search_Schema,

T.tbl_name + '.' + TR.tr_Name search_Name,

D.[db_name] search_Database

FROM

dbo.DBETriggers TR

INNER JOIN dbo.DBETables T ON TR.tr_tbl_pk = T.tbl_pk

INNER JOIN dbo.DBEDatabases D ON T.tbl_db_pk = D.db_pk

INNER JOIN dbo.DBEProfile P ON d.db_dbe_pk = P.dbe_pk

WHERE

P.dbe_pk = @profilePk

AND

(

@includeCodeBody = 1

AND

(

TR.tr_ProcedureCode LIKE @queryText

TR.tr_PreCreate LIKE @queryText

)

(

@includeNamesAndDescriptions = 1

AND

(

TR.tr_Name LIKE @queryText

TR.tr_Description LIKE @queryText

)

);

RE: Search Panel Not Functional

William Fields — Fri, 25 Oct 2013 11:14:09 GMT

Table names - nothing

Field names - nothing

Code within triggers - nothing

Code within stored procs - results

Funny thing, if I clear out the search term after results from stored procs are found and search again, I get the stored proc results again, and user defined functions.

RE: Search Panel Not Functional

StrataFrame Team — Fri, 25 Oct 2013 08:14:47 GMT

Will the search find other things, or is it just RAISEERROR that isn't being found? If you search for a field name or part of a field name does it find anything?

RE: Search Panel Not Functional

William Fields — Thu, 24 Oct 2013 12:25:39 GMT

Yes, I confirmed that in my original post.

Thanks.

RE: Search Panel Not Functional

Edhy Rijo — Thu, 24 Oct 2013 10:27:22 GMT

Hi William,

Make sure you have checked all the options in the "Search Options" as shown in my previous thread.

RE: Search Panel Not Functional

William Fields — Thu, 24 Oct 2013 09:44:15 GMT

I'm using v7.6.0 of the DDT, and I'm searching on RAISEERROR.

I have a ton of code in our database with the old RAISEERROR syntax which no longer works in SQL 2012, so I was hoping the find feature would be a quick and easy way to see how many lines of code that need to be touched.

But, when I search, nothing happens at all...

What search term can I use to verify if the find feature is working at all?

RE: Search Panel Not Functional

Ivan George Borges — Thu, 24 Oct 2013 07:47:17 GMT

Hey Edhy!

Yep, that could be it.

Abraços.

RE: Search Panel Not Functional

Edhy Rijo — Thu, 24 Oct 2013 07:36:29 GMT

Hi Ivan,

I don't think it is designed to look into table fields, at least that is not one of the options in the "Search Options"

Hmmm, I believe I never had the need to search for a field name, all the time for view names, a field in a view, stored procedure, etc. Anyway, very useful feature.

RE: Search Panel Not Functional

Ivan George Borges — Thu, 24 Oct 2013 06:46:43 GMT

Funny, I had never seen this Search feature. :blush:

Anyway, I tried it over here and could reproduce it. It did work on my own Views and Stored Procedures, but wouldn't find anything on the Tables, for example.

RE: Search Panel Not Functional

Edhy Rijo — Wed, 23 Oct 2013 22:24:50 GMT

Hi William,

I use that functionality all the time with VS2012 and MS-SQL2012. Make sure you are using the SF version 1.7.6.0.