2/19/2025 3:58:13 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss general T-SQL questions and help with queries related to SalesLogix data. View the code of conduct for posting guidelines.
|
|
|
|
Got the query, now what is the best way to display the data?
Posted: 18 May 07 3:57 PM
|
fiogf49gjkf0d We have a specific lead report that we want to run. Unfortunately they want to see the notes from the opportunity. I can create a group and even a Crystal report with all the info, but the notes, simply enough. But when adding the notes (history) we want to exclude Database Changes. So we came up with a query (see below) that works fine in ADO Explorer and the SQL checker in the Admin client, but now we aren't sure how to implement it. We really don't care how the report is generated, it could be a group, straight to Excel, Crystal, etc. Can anyone give us some suggestions here?
(the selected columns are fewer than the actual report for the sake of simplicity)
select o.description, l.description, h.category, h.notes
from opportunity o left join
(
select h.opportunityid, h.category, h.notes
from history h
where (h.category not like 'Database Change' or h.category is null)
) h on o.opportunityid = h.opportunityid
join leadsource l on o.leadsourceid = l.leadsourceid
where l.description = 'ICBA Bancard'
|
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|