Hello people,

First, I'm sorry for my english, but I try to express myself well. Also, I started with Pentaho and CDE since two weeks, so that i'm not professional. (I'm noob)

I want to display in the Popup, the address of a place that is located in a city. Markers are shown correctly in the city and I get that show in a Multiselect component all directions, but when to make the filter and display only the direction of the marker (city) where I click, nothing appears.

My SQL Query is:

Select CONCAT_WS(" - ",city,addressLine1,addressLine2)
from Offices
where city = ${city}
If you want more information, you ask me. I need help please!