TFD
ThoughtSpot For Developers•4mo ago
seansy-archy

seansy-archy - I'm having trouble applying a ru...

I'm having trouble applying a runtime filter to an answer that is referencing two different models. When I apply the runtime filter when only one model is selected, it works. However, once multiple models are selected, the runtime filter no longer works. I'm guessing we have to somehow reference the model for which we are applying the filter? Is that possible, I haven't been able to find any documentation on this.
No description
No description
3 Replies
seansy-archy
seansy-archyOP•4mo ago
When I apply the filter directly in the answer, I can see in the TML it creates filters like [Operational Model_1::Month Last Day] = 'this month'". If I try to pass a runtime filter like Operational Model_1::Month Last Day to offer more specificity, it doesn't work
shikharTS
shikharTS•4mo ago
Can you try adding "Operational Model_1"::"Month Last Day"? I think this should work Actually I tried internally, this does not work. This might be due to the way runtime filters are used. We pass runtime filters in url. So they cannot use this form. But normal filters can use this form, maybe you can use something like 
embed.trigger(HostEvent.UpdateRuntimeFilters, {
 filters: [{
     column: "retail sheet::city",
     oper: 'IN',
     values: ["atlanta"]
 }]
});
embed.trigger(HostEvent.UpdateRuntimeFilters, {
 filters: [{
     column: "retail sheet::city",
     oper: 'IN',
     values: ["atlanta"]
 }]
});
Does that help with your use case? Also what is the column name for which you want to apply runtime filter for? Is the name same or different?
jbc
jbc•4mo ago
Runtimefilters are supported only with single worksheet use-cases. You could create a new worksheet combining your multiple models as a workaround for this

Did you find this page helpful?