TFD
ThoughtSpot For Developers•4mo ago
Lexi Wagner

RuntimeFilterOp

hello how do I pass a null into runtime filters? https://visual-embed-sdk.vercel.app/docs/Enumeration_RuntimeFilterOp#_lt we have tried many variations but we cannot pass a filter to show records where a column is NULL
RuntimeFilterOp
A map of the supported runtime filter operations
2 Replies
shikharTS
shikharTS•4mo ago
Is the value coming from the datawarehouse null or is it showing up in TS as null? What is the use case for filtering null values? Also this seems to be working for me : 
runtimeFilters: [{
          columnName: 'colName', // eg: color
          operator: RuntimeFilterOp.EQ,
          values: ['{Null}'] // eg: red
     }],
runtimeFilters: [{
          columnName: 'colName', // eg: color
          operator: RuntimeFilterOp.EQ,
          values: ['{Null}'] // eg: red
     }],
You might need to check how NULL values are coming up in the TS UI and use that value in the values field here.
Lexi Wagner
Lexi WagnerOP•4mo ago
Thank you very much - we did not add quotes around it since it is not a string, but we will try that!

Did you find this page helpful?