Hi team, I have a liveboard with a
Hi team, I have a liveboard with a filter that defaults to a specific value. Please see the screenshot. I would like to override that filter to get the correct value (not the default one).
The approach I was considering to get the right company is to use runtime filters. However, based on the documentation, "if the Liveboard already has one or more filters applied, runtime filters will act as an AND condition." Our liveboard already has a default filter for the company ID. So if I add a runtime filter for the company ID, we will have two conditions for the company ID (company ID = "default company ID" and company ID = "desired company ID"). This does not return data.
Could you please point me in the right direction? Thanks!
17 Replies
You can create a personalised View to change the filter just for you. Though you might require permission to do that
In our specific case, we are trying to set the filter to the correct value dynamically when loading the liveboard in our app. The filter value (company ID) will depend on the logged-in user. I just want to confirm that this is the recommended approach in this specific scenario?
@bill_da_golfer can you help here? I feel there might be better approaches for this..
Hi @Alfredo Can you try using HostEvents.UpdateFilters for your use case if this helps? But please note, that it will only help you to update existing filters and not add new ones.
Here is the documentation for the same - https://developers.thoughtspot.com/docs/Enumeration_HostEvent#_updatefilters
HostEvent
Event types that can be triggered by the host application to the embedded ThoughtSpot app
Thanks @Aditya that is my recommendation as well.
Thanks, I will try that.
I tried what you recommended; however, I'm getting the error shown in the screenshot, and no data is being returned. Do you have any suggestions to fix that error?
Maybe use "610"?
Yes, I tried "610" but I received a 500 error and the message: '... float cannot represent a non-numeric value: "610"' Please see the screenshot for details.
Let me check this locally and get back to you
What is the data type for "Company Id"? could that be an issue? It might be an int where as we need it to be a string/varchar?
@shikharTS thanks for the response. "Company Id" is an int and should be an int.
I think I found the issue, this is a bug on the TS side where we are not allowing to add filter value in INT for attribute type columns. And when we change it to string, it does not take that as input. I will raise this internally, meanwhile an option you can consider is making the company id as string?
Thanks for the suggestion @shikharTS ! Unfortunately changing the company id type to string is not an option for us. Do you know when this bug will get fixed?
We are having a discussion internally and are trying to fix this ASAP. But it might get fixed in further release than you are on. If this seems critical, please push for getting a patch on the ticket you created.
Thank you for all the help @shikharTS and team! We are looking into that.
Any updates on this?
I started to experience something similar to this and I’m wondering if it could be the same issue.
I think we fixed this. Which cluster version are you experiencing this on?