sisense-nuna
Cloud Apps
Joined 3 years ago
User Profile
User Widgets
Contributions
Pagination
What is the Sisense-recommended way for implementing pagination? We've seen a collection of community-suggested ways to "get pagination to work" in dashboards, BloX, etc – but they frankly look like workarounds. We're looking for the official "Sisense Way" to ensure we're able to leverage our cloud data warehouse's native pagination / offset implementation. Thanks. Kat moti1.1KViews1like0CommentsRe: Connecting to Clickhouse
MySQL worked for you? We get an error - "text": "{\"error\":{\"moreInfo\":{\"why\":{\"name\":\"InvalidParametersException\",\"message\":\"InvalidParametersException\",\"errorCode\":8,\"errorMessage\":\"Code: 47. DB::Exception: Missing columns: 'TABLE_COMMENT' while processing query: 'SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, multiIf(TABLE_TYPE = 'BASE TABLE', multiIf((TABLE_SCHEMA = 'mysql') OR (TABLE_SCHEMA = 'performance_schema'), 'SYSTEM TABLE', 'TABLE'), TABLE_TYPE = 'TEMPORARY', 'LOCAL_TEMPORARY', TABLE_TYPE) AS TABLE_TYPE, TABLE_COMMENT AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION FROM (SELECT \",\"wrongParameter\":null,\"dbSourceErrorMessage\":null,\"trace\":null}},\"code\":22002,\"message\":\"Cannot establish connection with provided parameters.\",\"status\":400,\"httpMessage\":\"Bad Request\"}}"5.5KViews0likes0CommentsRe: Is there any official documentation for Custom Filters?
Apparently you use JAQL for the custom filters. It would be great if there was a link from the Advanced Filters page over to the JAQL docs. Also - the screenshots for Advanced Filters are SUPER blurry. Really recommend that the Sisense team replaces with samples like we see on sisense.dev.2KViews0likes0CommentsIs there any official documentation for Custom Filters?
I'm trying to apply a simple `AND` filter instead of the default `OR` filter in a Widget, and in a Dashboard. I can see the option for Advanced filters in the filter submenu (see attached image), but I'm not able to find any useful documentation that explains the available options for advanced filters. Where might I find that documentation?2KViews0likes2CommentsRe: Connecting to Clickhouse
We'll share what we can once we have this sorted out. Ideally we get updated instructions published on the Sisense docs vs. community threads. According to Sisense's website, Clickhouse is a "certified connector" – however it's listed as requiring use of the generic JDBC driver elsewhere in the Sisense docs here. Still waiting on the official response / support for getting properly connected to Clickhouse.5.6KViews0likes1Comment