7/5/2025 3:30:46 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 the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
|
|
|
| |
| |
| |
|
Re: SLX 7.51 How to add custom functionality to filters? Need to filter accounts where account "greater than" for instance...
Posted: 30 Jun 09 1:57 PM
|
Ok, i'm taking a look at those files, and I must say I'm quite puzzled...i don't even know where to start. Maybe someone could help me on this.
Lets say that I want to filter the current account group by only showing those accounts that have contacts whose firstname starts with "a" (a silly example, but it does the job). Since Contact is not in a 1-1 relationship with Account, I cannot just create a standard filter in Account Entity. So, I'll probably have to add some custom fields in the FiltersTasklet.ascx, let's say a Textbox called TxtContactFirstNameStartsWith, where the user enters "a" (or whatever).
So the query for displaying accounts should be something like:
select *
from account
where (current group filter conditions) and (filtertasklet out of box filter conditions)
and accountid in --New customized filter
(
select accountid
from contact
where firstname like 'a%' --or whatever string the user entered
)
How would I make the current account group filter based on this new condition?
NOTE: I know something very similar can be done by editing the current group's query in query builder, but the client specifically asked this to be a filter functionality, so I'm out of luck with telling them to just create a new group.- |
|
|
|
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!
|
|
|
|
|
|
|
|