Help with Escaping Underscores in LIKE Clause in Sisense SQL Editor
Hello Sisense Community, I've encountered an issue with using the LIKE clause in the Sisense SQL editor, specifically when trying to escape underscores (_) in my search pattern. I'm attempting to filter project names that start with "E_" from a table named [Workspace_data]. However, the standard SQL ESCAPE keyword seems not to be recognized, leading to an error. Here's the query I initially tried: SELECT a.[workspc_nm] FROM [Workspace_data] a WHERE a.[workspc_nm] LIKE 'E\_%' ESCAPE '\' The error message returned by Sisense is as follows: 1 out of 1 errors Line 3 Column 33 Found 'ESCAPE' but expected '<End of Expression>'. Based on the SQL cheat sheet provided by Sisense, there's guidance on various operators and comparisons, but I couldn't find specific mention of handling escape characters within the LIKE clause, especially for escaping underscores. I've attempted to adjust the query by omitting the ESCAPE clause select a.[workspc_nm] from [Workspace_data] a where a.[workspc_nm] LIKE 'E\_%' This does not throw any error, however it gives me only partial results. In my attempt to filter project names that start with "E_" the above query filters all projects, even project names like 'Eagle', or 'Elephant'. I want only names that follow the pattern 'E_Team ABC' 'E_Team XYZ' etc Could anyone provide insights or guidance on the correct way to escape special characters like underscores in Sisense's SQL editor? Is there an alternative approach or syntax that Sisense supports for this kind of pattern matching? Any advice or examples from your own experiences would be greatly appreciated. Thank you in advance for your help! Best regards,1.8KViews0likes4Comments
Indicator Widget Custom Formula: Count unique where 5 or more exist
Hello, fellow Sisense Users I'm trying to create an indicator widget that shows the number of unique email addresses in a dataset ONLY when there are 5 or more records with that email address AFTER the dashboard's date range filter is applied. Example: My data source shows "lesson completions" where each record is one completion, with a user_email, lesson_name, and completion_date. The dashboard has a date range filter. I want my indicator widget to count the number of unique user_emails ONLY when 5 or more "lesson completions" exist in the filtered date range. Any sort of help is greatly appreciated1.6KViews0likes1CommentImporting JSON string from SQL Server datatabase
We have data fields in our SQL Server database that are in JSON format that we would like to bring into Sisense and report on some of the fields. Is Sisense able to bring in the JSON formatted data and parse it into a table and fields? If so, how can this be done? We do have the JDBC Connector drivers installed. Not sure if we can use this some how and create a customer query using SQL.Solved1.5KViews0likes1Comment
How to add a single row below the header in pivot widget.
Hi, I was working with the pivot widget in my dashboard and I needed to add a row right below the header like a description.It should be above the table content which should appear right below the header and it should be shown in the export as well. I tried using JS also but I couldn't get it to work. I have attached an image below for reference. Any help is much appreciated. Thank you.Solved1.6KViews0likes1Comment
