DB table to find sort on color in stacked chart

Hi Sameer,

Thanks for reaching out. I'll see if I can find this location on your behalf, will let you know how it goes.

Thanks,

Eric

Hi Sameer,

Was not able to see this specific update in DEBUG mode, unfortunately.

However I was able to find a sort code parameter referencing "alphanumeric" in the reportformat table.

You can see the field defined in ChartField, where location = colourcode -

This is where the trail goes dark for me unfortunately. You can see field / chart and series IDs in Debug mode, you may be able to link this up with another table to find the parameter. Hope this helps! Let me know if you need anything additionally here.

Thanks,

Eric

Hi Eric,

Thank you for the response.

Basically we need query to change the sorting on color from Alphanumeric to Data Order for Stacked chart.

Please help us with the query if possible, else another way is to do it manually but then also we have to find our how many reports are there with color sorting set as Alphanumeric.

Any help in this is really appreciated.

Regads,

Sameer

HI Sameer,

It looks like we have a way to get filter sort info via API -

https://developers.yellowfinbi.com/dev/api-docs/current/#operation/getReportListMetadata

I think if you could subsequently update these values, that would be a potential solution here? If so I can pass this to developers to investigate on your behalf.

Thanks,

Eric

Hi Sameer,

Just wanted to check in to see if you were interested in pursuing a developer task for this functionality.

Thanks,

Eric

Hi Sameer,

I'm going to go ahead and mark this question as Answered due to inactivity at this time. Feel welcome to reach out in the future.

Thanks,

Eric