Point location on a map

[Fernando84]

Does anybody how can I locate a signal point on a map using a query? I mean, only the point without alarms.

[BevanWeiss]

Do you have the query that shows it 'with' the alarms?
If so, you should just be able to remove the fields that reference the Alarms.
It's generally just a case of having the query return the geolocation of the object, along with some text that you want displayed, and potentially a value for the icon you want.

[Fernando84]

Hi!! I'm attaching my query, can you tell me what part should I delete??

SELECT 

FULLNAME, FULLNAME || '    Alarmas Activas: ' ||  FormatValue (ALARMSETCOUNT using '0') as "TOOLTIP", GISLOCATION->LATITUDE, GISLOCATION->LONGITUDE, CASE WHEN ALARMSETCOUNT > 0 THEN 255  WHEN ALARMACCEPTEDCOUNT > 0 THEN 255 WHEN ALARMCLEAREDCOUNT > 0 THEN 150*256 ELSE 0 END AS "FOREGROUND", BACKGROUND, CASE WHEN ALARMSETCOUNT > 0 THEN 1 WHEN ALARMCLEAREDCOUNT > 0 THEN 1 ELSE 0 END AS "BLINK", ALARMSETCOUNT,  ALARMACCEPTEDCOUNT, ALARMCLEAREDCOUNT

FROM 

CGROUP 

WHERE 

FULLNAME LIKE 'ECOGAL%' AND GISLOCATIONSOURCE=1

ORDER BY AlarmSetCount, AlarmAcceptedCount, AlarmClearedCount

[tfranklin · Accepted solution]

If your goal is to just simply view the points on the map with no alarm conditions, then your query gets fairly simplified.  Remove any and all alarm, foreground, background, and blink columns. 

SELECT
FULLNAME, FULLNAME || ' Alarmas Activas: ' || FormatValue (ALARMSETCOUNT using '0') as "TOOLTIP", GISLOCATION->LATITUDE, GISLOCATION->LONGITUDE
FROM
CGROUP
WHERE
FULLNAME LIKE 'ECOGAL%' AND GISLOCATIONSOURCE=1

More aligned with your original question, if all you care about is a specific point or points (ex: just pressure points) then you can edit the query for:

SELECT
FULLNAME, FULLNAME || '<br>Alarm State: ' || ALARMSTATEDESC  as "TOOLTIP", GISLOCATION->LATITUDE, GISLOCATION->LONGITUDE
FROM
CDBPOINT
WHERE
FULLNAME LIKE 'ECOGAL%' AND GISLOCATIONSOURCE=1 AND NAME IN ('point name1','point name 2')

Lastly -- if you want to add some line breaks in your tooltip, use <br>. 

[Fernando84]

Thank you, it's very helpful.