Hi George
We have a road map item to support using custom templates to show data bind results.
I expect it should be available for the 2021 release (December 2021)
The scope is as below:
The admin creates a custom template and data bind as now. for example:
- Creates a custom template for a non-spatial table in Analyst (for example tenants table where they may be zero, one or more tenants at a property)
- Makes the custom template the default for the tenants table in Analyst.
- Creates a data bind between the property table (spatial table) and tenants table using property ID as a link
When a user access Analyst and selects a property, they will see the same overflow menu to view the linked tenants. The tenant records are still shown under the map information results on the left panel (as in the screen shots above for the dog registrations), however they will be shown using the custom template rather than the default (key-value pair) view, and hence would show any hyperlinks, charts etc added to the template.
Let me know if this would meet the requirement.
If not, then we need to explore enhancing more fundamentally how data binds are displayed (perhaps showing them using an "Exponare style" tabbed results) or look at using extensibility to provide something bespoke (perhaps to show them in-line within the map information result for the property).
------------------------------
Mustafa
mustafa.ismail@pb.comPitney Bowes Software Inc.
Watford
------------------------------
Original Message:
Sent: 08-18-2021 23:01
From: George Corea
Subject: Is it possible to connect a infoteplate to an external lookup table
Thanks.
That works well but without being able to use custom templates it doesn't work for this case as I don't want to show all the columns and some need to be shown as href links etc. Do you know when this will be supported?
Regards,
------------------------------
George Corea
Mangoesmapping
MOOMIN QLD
Original Message:
Sent: 08-18-2021 07:57
From: Mustafa mustafa.ismail@pb.com
Subject: Is it possible to connect a infoteplate to an external lookup table
Hi George
This use case can be met by using data binds.
The documentation is here
https://docs.precisely.com/docs/sftw/spectrum/20.1/en/webhelp/Spatial/index.html#Spatial/source/Resources/resources/repoman/Project_Properties/start/data_bindings.html
A data bind can be created on a column that provides a link between a spatial table and another table (which can be spatial or non-spatial). In Analyst when the user sees map information for the spatial table, they can access the available data binds from the overflow menu to see the additional linked data.
The below four images show how the data bind is set up in Spatial Manager, referenced in the map project in Analyst Project Settings and then used in Analyst by the user. You can see that the chosen property is linked to two data binds (cat and dog pet registrations tables). The last image shows that there are 3 dogs registered at the chosen address.
By default the data bind information is shown below the original map information, and we do not yet support having a custom template for data bind results.
The data bind approach works out of the box and lets you link as many tables as needed.
If you need a different behaviour or a different way of displaying the results, extensibility can be used to create a fully custom template for the spatial table that shows the linked data in some other way. But this will need to be coded as an Angular component which fetches the data itself dynamically. I believe the APAC services team have done this for some customers.
------------------------------
Mustafa mustafa.ismail@pb.com
Pitney Bowes Software Inc.
Watford
Original Message:
Sent: 08-16-2021 00:47
From: George Corea
Subject: Is it possible to connect a infoteplate to an external lookup table
I want to create an infotemplate to include data from another file without having to merge the 2 files together.
I have a lookup table like
When I open the infotemplate for say the zones.tab file and a user clicks on say a property with the zone code "Conservation" I want the infotemplate to then show the values in the other columns in the same row.
It should look something like
I understand I can create a new table with all the data by merging the two datasets but I was hoping there's a quick way of getting the infotemplate to check the lookup table and draw the required info from there. This way I am not creating repetitive columns and I only need to keep the lookup table updated if any of the information changes.
Would using spectrum queries to build the table be a path to look down or there some other way?
Regards,
------------------------------
George Corea
Mangoesmapping
MOOMIN QLD
------------------------------