Search Panel Not Functional


Author
Message
William Fields
William Fields
StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)
Group: StrataFrame Users
Posts: 80, Visits: 239
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.

???
Replies
William Fields
William Fields
StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)
Group: StrataFrame Users
Posts: 80, Visits: 239
Yes, I confirmed that in my original post.

Thanks.
StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
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?
William Fields
William Fields
StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)
Group: StrataFrame Users
Posts: 80, Visits: 239
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.
StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
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 
               OR
               TR.tr_PreCreate LIKE @queryText
            )
         
         OR
        (
            @includeNamesAndDescriptions = 1 
            AND 
            (
               TR.tr_Name LIKE @queryText 
               OR 
               TR.tr_Description LIKE @queryText
            )
         )
      );
William Fields
William Fields
StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)StrataFrame User (326 reputation)
Group: StrataFrame Users
Posts: 80, Visits: 239
Thanks for the reply.

Will this be incorporated into the next DDT version?
StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Oh yes.  The search on the next DDT will be vastly expanded.  The search on the current version was more of an afterthought.  
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
William Fields - 12 Years Ago
Edhy Rijo - 12 Years Ago
Ivan George Borges - 12 Years Ago
Edhy Rijo - 12 Years Ago
                 Hey Edhy! Yep, that could be it. Abraços.
Ivan George Borges - 12 Years Ago
William Fields - 12 Years Ago
                         Hi William, Make sure you have checked all the options in the...
Edhy Rijo - 12 Years Ago
                             Yes, I confirmed that in my original post. Thanks.
William Fields - 12 Years Ago
                                 Will the search find other things, or is it just RAISEERROR that isn't...
StrataFrame Team - 12 Years Ago
                                     Table names - nothing Field names - nothing Code within triggers -...
William Fields - 12 Years Ago
                                         I just checked the dbo.Search_Query sproc, and it certainly doesn't...
StrataFrame Team - 12 Years Ago
                                             Thanks for the reply. Will this be incorporated into the next DDT...
William Fields - 12 Years Ago
                                                 Oh yes. The search on the next DDT will be vastly expanded. The search...
StrataFrame Team - 12 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search