topic Re: dataRoles / dataViewMappings fror muliple tables? in Custom Visuals Development Discussion

dataRoles / dataViewMappings fror muliple tables?

AdamWhittaker — Wed, 23 Oct 2024 22:04:49 GMT

Hello,

How would i go about designing the capabilities.json file if i want to add 3 related tables to a custom visual, at first i thought i should use tables but the api limits it to one..

I am trying to send somthing like this

Person:

personId

PersonName

Events:

personId

EventName

EventStart

EventEnd

The two tables are linked via personId.

I thought something like this:

"dataViewMappings": [

{

"categorical": {

"categories": [

{

"for": {

"in": "resourceId"

}

{

"for": {

"in": "resourceName"

}

{

"for": {

"in": "territory"

}

{

"for": {

"in": "eventColor"

}

"values": {

"select": [

{

"bind": {

"to": "eventId"

}

{

"bind": {

"to": "eventName"

}

{

"bind": {

"to": "manager"

}

{

"bind": {

"to": "appointmentNumber"

}

{

"bind": {

"to": "status"

}

{

"bind": {

"to": "description"

}

{

"bind": {

"to": "startDate"

}

{

"bind": {

"to": "endDate"

}

]

}

]

But categories cannot be an array?

Thanks

Re: dataRoles / dataViewMappings fror muliple tables?

dm-p — Thu, 24 Oct 2024 20:32:07 GMT

Hi AdamWhittaker,

Because categories can have other potential properties (like dataReductionAlgorithm), you would add a select property with an array to your existing object and include the data roles there (like you have done for values). The following should work based on your above definition (or get you close to it - it's a valid pattern that I have used in other visuals):

{ "dataViewMappings": [ { "categorical": { "categories": { "select": [ { "for": { "in": "resourceId" } }, { "for": { "in": "resourceName" } }, { "for": { "in": "territory" } }, { "for": { "in": "eventColor" } } ] }, "values": { "select": [ { "bind": { "to": "eventId" } }, { "bind": { "to": "eventName" } }, { "bind": { "to": "manager" } }, { "bind": { "to": "appointmentNumber" } }, { "bind": { "to": "status" } }, { "bind": { "to": "description" } }, { "bind": { "to": "startDate" } }, { "bind": { "to": "endDate" } } ] } } } ] }

Good luck!

Daniel

Re: dataRoles / dataViewMappings fror muliple tables?

AdamWhittaker — Fri, 25 Oct 2024 16:54:39 GMT

dm-p Thanks for the help, it worked. Looks like i just missed the select part in:

                "categories": {
                    "select": [