Striim 3.9.7 documentation

Populate a Dashboard map from a WActionStore

In simple.tql, replace these lines:

CREATE TARGET JoinedDataTarget
USING SysOut(name:JoinedData)
INPUT FROM JoinedDataStream;

with the following:

CREATE JUMPING WINDOW FilteredDataWindow
OVER FilteredDataStream KEEP 1 ROWS;

CREATE WACTIONSTORE MapData 
CONTEXT OF JoinedDataType
EVENT TYPES ( JoinedDataType KEY(merchantId) )
PERSIST NONE USING();

CREATE CQ PopulateMapDataCQ
INSERT INTO MapData
SELECT  f.merchantId,
        f.zip,
        z.city,
        z.state,
        z.latVal,
        z.longVal
FROM FilteredDataWindow f, ZipCache z
WHERE f.zip = z.zip; 

Reload and restart simple.tql, then create a dashboard (see Dashboard Guide and Dashboard rules and best practices), add a Vector Map, and specify this as its query's SELECT statement:

select * from MapData;

After saving the query, click the map's cog icon, and specify its properties as follows:

simple_map.png

See Visualization types and properties for more information about these values.

Leave the other properties at their defaults, save the map, click Done, and refresh the browser. You should see something like this:

simple_map_2.png