I have a Query-Chart that displays the number of contacts by month that a client has. It works fine.
I want to be able to Click on any segment of that chart and open a query that only shows the Contacts for that Month.
In my query to display each contact for a month I have tried several things but either get every record for the whole BO or no records.
Here is what I have tried for the criteria:
FIND Contacts WHERE Contacts.YearAndMonthOfContact=ThisContacts.YearAndMonthOfContact
Result is nothing.
I tried:
FIND Contacts WHERE Contacts.YearAndMonthOfContact=OtherContacts.YearAndMonthOfContact
Result is nothing.
I tried:
FIND Contacts WHERE Contacts.YearAndMonthOfContact=Contacts.YearAndMonthOfContact
Result is everything for all months comes up.
I have tried calling the query to display the list of contacts for the month from a process with the Contacts BO specified in the Input parameter, but it doesn't seem to work either.
Isn't there a way to use the same BO in a, in effect, child query, and filter based on a value from the parent?
I am sure I am missing something here.
Filtered Query from Chart
-
- Posts: 297
- Joined: Wed Apr 22, 2015 11:44 pm
Re: Filtered Query from Chart
Related to this question...
When you click on a bar in a bar chart and something has been defined in "When Chart Clicked", what actually happens?
Is the record I have clicked on placed into Context? If not, how can it get there?
When you click on a bar in a bar chart and something has been defined in "When Chart Clicked", what actually happens?
Is the record I have clicked on placed into Context? If not, how can it get there?