StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Database Deployment Toolkit
»
Issues
»
Search Panel Not Functional
Search Panel Not Functional
Post Reply
Like
1
Prev
1
2
Jump To Page
Search Panel Not Functional
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
StrataFrame Team
S
StrataFrame Team
posted 11 Years Ago
ANSWER
Post Details
Share Post
S
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
)
)
);
Reply
Like
1
William Fields
William Fields
posted 11 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Users
Posts: 80,
Visits: 239
Thanks for the reply.
Will this be incorporated into the next DDT version?
Reply
Like
1
StrataFrame Team
S
StrataFrame Team
posted 11 Years Ago
ANSWER
Post Details
Share Post
S
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.
Reply
Like
1
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Post Reply
Like
1
Prev
1
2
Jump To Page
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search