--
-- Host: localhost    Database: BI_Issue_Tracker
-- ------------------------------------------------------


--
-- Table structure for table `issue`
--

CREATE TABLE `issue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `issueTypeId` int(11) DEFAULT NULL,
  `priorityId` int(11) DEFAULT NULL,
  `moduleId` int(11) DEFAULT NULL,
  `issueStatusId` int(11) DEFAULT NULL,
  `description` longtext,
  `developerRemark` longtext,
  `issueDate` datetime DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `resolvedBy` int(11) DEFAULT NULL,
  `resolvedDate` datetime DEFAULT NULL,
  `verifiedBy` int(11) DEFAULT NULL,
  `verifiedDate` datetime DEFAULT NULL,
  `moduleUrl` text,
  `issueImageUrl` text,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=219 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `issue`
--

INSERT INTO `issue` VALUES (1,1,2,16,1,'In data table applied fixed columns for four dimensions, while applying serial number, only 3 columns get fixed in report 12','','2025-02-11 18:52:18',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/view/DBQiNVCFMc/1','[\"1739280138173_456886840.png\"]','2025-02-11 18:52:18','2025-02-11 18:52:18'),(2,1,2,16,1,'In row chart Top 10 + Dual Axis + sort by not works ','','2025-02-11 18:58:26',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/view/DBimuWpeHT/1','[\"1739280505853_903784833.png\"]','2025-02-11 18:58:26','2025-02-11 18:58:26'),(3,1,3,18,3,'While zipcode used in datatable, data sort not works .(in report 7)','','2025-02-11 19:09:48',12,13,'2025-02-18 15:57:37',12,'2025-02-18 18:52:33','https://dev3v2.thinklytics.io/#/dashboard/view/DBRim9ZM2c/1','[\"1739281187941_222411045.png\"]','2025-02-11 19:09:48','2025-02-18 18:52:33'),(4,1,3,18,1,'Error: column reference \"shipping_cost\" is ambiguous, while using normal dimension + nested calc (${virtual_sum_test} + sum(${shipping_cost} ) +avg(${shipping_cost})), error arises','','2025-02-11 19:16:23',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/view/DBQ9LWiOAw/1','[\"1739281583407_517485370.png\"]','2025-02-11 19:16:23','2025-02-11 19:16:23'),(5,1,3,16,1,'In chart settings, While type and search the dimension name  dual axis dimension and group color like \"state\" it shows list column name matched with search bar, But while we search \"states\" and delete the \'s\' at the end it shows none.','','2025-02-12 11:55:47',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/view/DBqic4pBxE/1','[\"1739341546969_340018610.png\"]','2025-02-12 11:55:47','2025-02-12 11:55:47'),(6,1,3,5,1,'\"While applying Filters Add/Edit in Metadata for Mongodb datasource, condition not works properly\nFolder AravindNew>MLnew>\nFilter : products_id(orders)>1 AND products_id(orders)<10\"','','2025-02-12 12:01:06',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/metadata/edit/MDexiOQrTH','[\"1739341866680_771444003.png\"]','2025-02-12 12:01:06','2025-02-12 12:01:06'),(7,1,3,5,1,'While changing inner join to left or right join venn diagram symbol remains inner join type, data changed accordingly (change the join type to check the issue)','','2025-02-12 12:03:37',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/metadata/edit/MDYld99pI8','[\"1739342017529_549954887.png\"]','2025-02-12 12:03:37','2025-02-12 12:03:37'),(8,1,2,18,1,'While applied scroll limit + topn + dual axis + custom axis sorting, in custom axis sorting listed values are not mached with report 1','','2025-02-12 12:06:49',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/view/DBsRXa7aqV/1','[\"1739342208841_279025323.png\",\"1739342208843_368022525.png\"]','2025-02-12 12:06:49','2025-02-12 12:06:49'),(9,1,2,16,1,'While apply top filter in view mode, without refresh the page, click the edit mode chart changes to original format, but in legend it remains same (like applied in top filter)','','2025-02-12 12:09:00',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/view/DBTC7mNhJO/1','[\"1739342340170_736001194.png\"]','2025-02-12 12:09:00','2025-02-12 12:09:00'),(10,1,2,18,1,'\"In heat chart \' y axis\'name not fully shown, either overlapped one above another or letters hided (report 1)\n','','2025-02-12 12:11:50',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/view/DBCYUgYawX/1','[\"1739342510602_619861826.png\"]','2025-02-12 12:11:50','2025-02-12 12:11:50'),(11,1,3,15,1,'validation for virtual count,VIRTUAL LAG, VIRTUAL LEAD, VirtualSum, VirtualMin, VirtualMax if index is missing,or if aggrn is missing','','2025-02-12 15:41:48',3,NULL,NULL,NULL,NULL,'','','2025-02-12 15:41:48','2025-02-12 15:41:48'),(12,1,3,16,3,'${vir lag1}/${vir lag} gives wrong value (0) Error: division by zero(report 16)','If you get divide by zero error then you need to use case calculation','2025-02-12 15:43:41',3,13,'2025-02-18 15:21:33',3,'2025-03-10 19:37:09','https://dev3v2.thinklytics.io/#/dashboard/edit/DB6uR3CCZ7/0','\"\"','2025-02-12 15:43:41','2025-03-10 19:37:09'),(13,1,2,16,3,'${vir lead}/${vir lead1} gives wrong value (0)Error: division by zero (rep17)','If you get divide by zero error then you need to use case calculation','2025-02-12 15:45:19',3,13,'2025-02-18 15:21:55',3,'2025-03-10 19:20:04','https://dev3v2.thinklytics.io/#/dashboard/edit/DB6uR3CCZ7/0','\"\"','2025-02-12 15:45:19','2025-03-10 19:20:04'),(14,1,3,5,3,'in api md filter section the cols are not distinghuished from the table name','Filters removed','2025-02-12 15:54:06',3,2,'2025-02-20 17:30:26',3,'2025-02-21 11:36:52','https://dev3v2.thinklytics.io/#/metadata/edit/MDaRmvVRMk','\"\"','2025-02-12 15:54:06','2025-02-21 11:36:52'),(15,1,3,1,1,'when we come back from save ds to configure JSON ds, before clicking edit we are able to edit JSON name','','2025-02-12 15:55:11',3,NULL,NULL,NULL,NULL,'','','2025-02-12 15:55:11','2025-02-12 15:55:11'),(16,1,2,16,1,'validation can be added to check aggregate, start index & end index in virtual calculation(vir val calc on db)','','2025-02-12 15:56:52',3,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/edit/DB6uR3CCZ7/0','','2025-02-12 15:56:52','2025-02-12 15:56:52'),(17,1,2,5,3,'In Mongo db structure filter ,>=,<= not working ','','2025-02-12 16:00:43',3,13,'2025-02-18 15:17:14',3,'2025-02-19 15:24:15','https://dev3v2.thinklytics.io/#/metadata/edit/MDvb2cXpp6','\"\"','2025-02-12 16:00:43','2025-02-19 15:24:15'),(18,1,2,5,3,'filter not working for API md (< > =,>=,<=)','','2025-02-12 16:01:59',3,2,'2025-02-18 15:07:17',3,'2025-02-19 15:33:49','https://dev3v2.thinklytics.io/#/metadata/edit/MDZZUb3DTB','\"\"','2025-02-12 16:01:59','2025-02-19 15:33:49'),(19,1,1,16,1,'if serial num,fix header and top/bottom N is used the columns displayed on dt are not alligned','','2025-02-12 16:03:38',3,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/view/DBG6nnxySf/1','','2025-02-12 16:03:38','2025-02-12 16:03:38'),(20,1,3,16,3,'date time format in calc for date column will not get applied','That format is of database','2025-02-12 16:17:23',3,2,'2025-02-20 18:38:59',3,'2025-02-21 10:40:54','','\"\"','2025-02-12 16:17:23','2025-02-21 10:40:54'),(21,1,2,16,3,'set grand total to yes and select none on all, the columns , then chart displays grand value but no value for all column ,so validation is reguired if we set  grand value to yes then atleast select 1 measure with total','','2025-02-12 16:19:20',3,2,'2025-02-12 16:56:48',3,'2025-02-12 19:24:40','https://dev3v2.thinklytics.io/#/dashboard/edit/DBZ1gUwfCN/0','','2025-02-12 16:19:20','2025-02-12 19:24:40'),(22,1,2,16,3,'dual x axis is selected, then top 2 is filtered but custom axis sorting shows different values ( line -report 14)','','2025-02-12 16:24:26',3,13,'2025-02-20 17:21:32',3,'2025-02-21 11:39:43','https://dev3v2.thinklytics.io/#/dashboard/edit/DBZ1gUwfCN/0','\"\"','2025-02-12 16:24:26','2025-02-21 11:39:43'),(23,1,3,5,1,'in the md-select ds-pagination last page is listed twice(select sadsadas ds)','','2025-02-12 16:26:13',3,NULL,NULL,NULL,NULL,'','','2025-02-12 16:26:13','2025-02-12 16:26:13'),(24,1,2,16,3,'if measure is changed then all chart setting should be reset including dual axis , ref line etc','','2025-02-12 17:06:08',3,2,'2025-02-17 13:45:43',3,'2025-02-19 16:26:29','','\"\"','2025-02-12 17:06:08','2025-02-19 16:26:29'),(25,1,2,16,3,'validation for Y axis-1 Y axis-2 in reference line needs to be added(dual axis chart)','','2025-02-12 17:07:12',3,2,'2025-02-17 11:20:41',3,'2025-02-19 16:31:52','','\"\"','2025-02-12 17:07:12','2025-02-19 16:31:52'),(26,1,3,18,1,'message is getting diaplyed only if console is open, cross filter then sort \"First remove cross filter then apply sorting\"','','2025-02-12 17:14:48',3,NULL,NULL,NULL,NULL,'','','2025-02-12 17:14:48','2025-02-12 17:14:48'),(27,1,3,5,1,'if the last page has only 1 value then next 10 tables icon should be disabled(select June4thMysql ds in md)','','2025-02-12 17:23:43',3,NULL,NULL,3,'2025-02-12 17:24:15','','','2025-02-12 17:23:43','2025-02-12 17:24:15'),(28,1,3,5,1,'abc pvt ltd this ds shows only 10 tables but still previous and next 10 tables icon enabled','','2025-02-12 17:25:02',3,NULL,NULL,NULL,NULL,'','','2025-02-12 17:25:02','2025-02-12 17:25:02'),(29,1,1,14,3,'after api api blending, if I try to create dashboard then it gives error.(Syntax error during \'cube test\' parsing: Unexpected token, expected \",\" (1:234):)\nselect test api api blend metaddata on cube ','Validation added at metadata level that column name should not contain special characters, you need to create new & then test','2025-02-12 17:27:21',3,2,'2025-02-21 11:46:13',3,'2025-02-21 12:18:52','https://dev3v2.thinklytics.io/#/dashboard/cube','\"\"','2025-02-12 17:27:21','2025-02-21 12:18:52'),(30,1,2,2,3,'append data after selecting the table and sheet the modal does not close .and the response is empty','','2025-02-12 18:40:26',3,2,'2025-02-17 11:06:16',3,'2025-03-10 19:39:11','','\"\"','2025-02-12 18:40:26','2025-03-10 19:39:11'),(31,1,2,2,3,'if error code is 0, message from backend should be displayed I think.-append data','','2025-02-12 18:40:55',3,2,'2025-02-20 16:10:23',3,'2025-03-10 19:37:28','','\"\"','2025-02-12 18:40:55','2025-03-10 19:37:28'),(32,1,2,16,3,'once we edit and save grp category then underscore is added to the name if there are 2 words','','2025-02-12 18:43:03',3,2,'2025-02-13 16:26:37',3,'2025-02-19 19:18:03','https://dev3v2.thinklytics.io/#/dashboard/edit/DBcEfx2PIu/0','\"\"','2025-02-12 18:43:03','2025-02-19 19:18:03'),(33,1,2,18,1,'when top N is set the report set in not shown properly for calculated column in report set (Aravind issue)','','2025-02-12 18:49:03',3,NULL,NULL,NULL,NULL,'','','2025-02-12 18:49:03','2025-02-12 18:49:03'),(34,1,2,18,3,'cant revert back the cross fitler applied','Yes working correct only','2025-02-12 18:49:34',3,2,'2025-02-20 16:09:34',3,'2025-02-21 11:39:57','https://dev3v2.thinklytics.io/#/dashboard/view/DBm40NGhCh/1','\"\"','2025-02-12 18:49:34','2025-02-21 11:39:57'),(35,1,2,18,1,'cross filter single value from first chart then the previous and next page shows some vales blued out some not blued ','','2025-02-12 18:50:51',3,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/view/DBm40NGhCh/1','','2025-02-12 18:50:51','2025-02-12 18:50:51'),(37,2,2,16,1,'Have to add date sort feature for data table in dev3v2','','2025-02-13 16:40:02',12,NULL,NULL,NULL,NULL,'','','2025-02-13 16:40:02','2025-02-13 16:40:02'),(38,1,1,16,3,'exclude include shows empty list after report set is set(report 2)','Correct Logic as report set is there, so you can add custom value','2025-02-17 13:19:46',3,2,'2025-02-17 14:27:28',3,'2025-02-18 12:54:42','https://dev3v2.thinklytics.io/#/dashboard/edit/DBFdA6dCLL/0','\"\"','2025-02-17 13:19:46','2025-02-18 12:54:42'),(39,1,1,18,3,'cross filter and top filter will display tooltip of box plot as undefined and bubble chart as variable name only','','2025-02-17 19:15:12',3,2,'2025-02-18 13:09:55',3,'2025-02-21 11:43:39','https://dev3v2.thinklytics.io/#/dashboard/view/DBpkZGD0rh/1','\"\"','2025-02-17 19:15:12','2025-02-21 11:43:39'),(40,1,2,18,3,'filter only alaska from top filter then the chart does not display anything','','2025-02-18 13:03:18',3,13,'2025-02-18 14:44:10',3,'2025-02-21 12:31:05','https://dev3v2.thinklytics.io/#/dashboard/view/DBCYOrOat6/1','\"\"','2025-02-18 13:03:18','2025-02-21 12:31:05'),(41,1,2,16,3,'If top/bottom N is reset to 0 then custom axis sorting has to be set to no.','','2025-02-20 18:19:25',3,2,'2025-02-20 18:21:38',3,'2025-02-21 11:36:31','https://dev3v2.thinklytics.io/#/dashboard/view/DBpUosKI1N/1','\"\"','2025-02-20 18:19:25','2025-02-21 11:36:31'),(42,1,1,31,1,'no direct option to create Report group for User Group','','2025-02-20 19:33:36',3,NULL,NULL,NULL,NULL,'','','2025-02-20 19:33:36','2025-02-20 19:33:36'),(43,1,2,21,1,'there is no option to format the value of text image chart ','','2025-02-20 19:34:39',3,NULL,NULL,NULL,NULL,'','','2025-02-20 19:34:39','2025-02-20 19:34:39'),(44,1,2,18,1,'cross filter on choropleth map will not gray out other states','','2025-02-20 19:35:25',3,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/view/DBxKPHHnM3/1','','2025-02-20 19:35:25','2025-02-20 19:35:25'),(45,2,2,16,3,'exclude include option not there for bubble chart','','2025-02-20 19:35:54',3,2,'2025-03-24 10:32:03',3,'2025-03-26 11:07:25','','\"\"','2025-02-20 19:35:54','2025-03-26 11:07:25'),(46,1,3,16,1,'If I add more filter to existing filters list then filters  will reorder back alphabitacally','','2025-02-20 19:36:37',3,NULL,NULL,3,'2025-04-29 13:10:02','','\"\"','2025-02-20 19:36:37','2025-04-29 13:10:02'),(47,1,3,18,3,'cross filter does not work in view mode','','2025-02-20 19:37:19',3,2,'2025-02-21 11:32:16',3,'2025-02-21 11:35:24','','\"\"','2025-02-20 19:37:19','2025-02-21 11:35:24'),(48,1,3,16,3,'formatting gets reset on date column once serial no is applied','','2025-02-20 19:40:05',3,2,'2025-02-21 11:32:07',3,'2025-02-21 11:35:41','','\"\"','2025-02-20 19:40:05','2025-02-21 11:35:41'),(49,1,1,21,3,'aggr reference line is showing as false in sv edit chart setting','','2025-02-21 18:00:05',3,2,'2025-02-24 17:23:32',3,'2025-03-10 19:27:35','https://dev3v2.thinklytics.io/#/sharedview/edit/SVaWLpHGaw/1','\"\"','2025-02-21 18:00:05','2025-03-10 19:27:35'),(50,1,1,15,3,'minDate maxDate col does not work with bubble chart','','2025-02-24 16:32:00',3,2,'2025-02-24 17:25:05',3,'2025-03-26 12:10:20','https://dev3v2.thinklytics.io/#/dashboard/view/DBgcx4Yht7/1','\"\"','2025-02-24 16:32:00','2025-03-26 12:10:20'),(51,1,1,16,1,'minDate maxDate col does not work with pivot table chart','','2025-02-24 16:32:43',3,NULL,NULL,3,'2025-02-24 16:48:04','https://dev3v2.thinklytics.io/#/dashboard/view/DBX4511YDh/1','\"\"','2025-02-24 16:32:43','2025-02-24 16:48:04'),(52,1,1,16,1,'minDate maxDate col does not work with map chart','','2025-02-24 16:33:38',3,NULL,NULL,3,'2025-02-24 16:50:20','https://dev3v2.thinklytics.io/#/dashboard/view/DBSeUUh7Th/1','\"\"','2025-02-24 16:33:38','2025-02-24 16:50:20'),(53,1,1,16,1,'minDate maxDate col does not work with male female chart','','2025-02-24 16:34:39',3,NULL,NULL,NULL,NULL,'','','2025-02-24 16:34:39','2025-02-24 16:34:39'),(54,2,2,15,3,'exclude include option not there for filler chart','','2025-02-24 19:34:32',3,2,'2025-03-20 13:37:35',3,'2025-03-24 13:23:56','','\"\"','2025-02-24 19:34:32','2025-03-24 13:23:56'),(55,2,2,16,3,'exclude include option not there for tree map','Implemented as of now for only single dimension','2025-02-24 19:34:56',3,2,'2025-03-18 15:46:34',3,'2025-03-24 13:23:32','','\"\"','2025-02-24 19:34:56','2025-03-24 13:23:32'),(56,1,1,18,3,'After sync the added new data is not shown for virtual chart  \n\nmetadata name - test mysql feb26\ndashboard name - test mysql feb26\n\n(One data with orderid - 32 is missing & not added in druid) ','','2025-02-26 12:47:00',3,13,'2025-03-07 16:31:35',3,'2025-03-07 17:23:21','https://dev3v2.thinklytics.io/#/dashboard/view/DBjZQuLcHi/1','\"\"','2025-02-26 12:47:00','2025-03-07 17:23:21'),(57,1,1,18,1,'1. Dashboard Created With normal and Virtual columns \n2.Sv Created \n3.Pre- Aggregation Created For that dashboard\n4.Added one row in existing table\n5.Incremental sync metadata blend \n\nIssue :\n1.Pre Aggregation count not updated after sync applied\n2.Data count not updated in dashboard\n\nDashboard Name : Blend_Test_28_02\nMetadata Blend Name : Bled_new_1 ','','2025-02-28 11:39:44',12,NULL,NULL,12,'2025-02-28 12:06:22','https://dev3v2.thinklytics.io/#/dashboard/view/DB1tYWRxjR/1','\"\"','2025-02-28 11:39:44','2025-02-28 12:06:22'),(58,1,1,19,1,'Applied Hard Sync (Edit Metadata Blend + saved ) \nError Arises in Pre Aggregation level\n\nPre Aggregation Name : Blend_Test_28_02\nMetadata Blend Name : Bled_new_1','','2025-02-28 12:14:55',12,NULL,NULL,12,'2025-02-28 12:16:28','https://dev3v2.thinklytics.io/#/preAggregation','[\"1740725094331_239362850.png\"]','2025-02-28 12:14:55','2025-02-28 12:16:28'),(59,1,1,18,3,'Add New Data + Incremental Sync (Metadata Blend) + Pre Aggregation Remains in error \n1.Count Increased \n2.Data Reflected in normal measure used Report\n3. Virtual column value remains \'0\' in Report for newly added row\n\nMetadata Blend Name : Bled_new_1\nDashboard :  Blend_Test_28_02\nPreAggregation Name : Blend_Test_28_02','','2025-02-28 12:39:19',12,13,'2025-03-03 11:54:03',12,'2025-03-03 11:58:40','https://dev3v2.thinklytics.io/#/dashboard/view/DB1tYWRxjR/1','[\"1740726558747_753491532.png\"]','2025-02-28 12:39:19','2025-03-03 11:58:40'),(60,1,1,18,3,'1.Added row + Updated Existing row (Update date & time column changed) \nIssue :\n1.Count Mismatched \n2. Name repeated Twice (Both updated name and previous customer name)\nEx :\nChandran\nChandran_New','','2025-02-28 13:20:46',12,13,'2025-03-03 11:54:23',12,'2025-03-03 11:59:03','https://dev3v2.thinklytics.io/#/dashboard/view/DB1tYWRxjR/1','[\"1740729046274_224355335.png\"]','2025-02-28 13:20:46','2025-03-03 11:59:03'),(61,1,1,18,3,'While adding new record + updating existing record + Incremental sync metadata , Checked the count in dashboard\nCount not get updated  , but , applied changes in mysql table reflected in dashboard.\nMetadata Name : New_Blend_Test_1\nDashboard Name : DB_Without_Blend','','2025-02-28 16:35:10',12,13,'2025-03-03 11:54:34',12,'2025-03-03 11:58:52','https://dev3v2.thinklytics.io/#/dashboard/view/DBQKwUOo2d/1','\"\"','2025-02-28 16:35:10','2025-03-03 11:58:52'),(62,1,1,30,1,'Added one row + Updated One row\n1.Applied Incremental sync Without pre-Aggregation time in data management , (Data count not updated)\n2.Applied Hard sync + Incremental sync without pre Aggregation time in data management (Data count updated , But Virtual Value remains in 0 and Virtual calc based reports not get updated)\n','','2025-02-28 18:37:42',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/view/DB1tYWRxjR/1','[\"1740748061894_937584937.png\"]','2025-02-28 18:37:42','2025-02-28 18:37:42'),(63,1,1,18,3,'Dashboard - pre aggtn feb28 virtual db\nMetadata -preaggtn feb28 veda\nSV - preaggtn feb28 virtual db\n\nAfter deleting record from database and hard sync , the virtuual charts still shows the deleted record \n','','2025-02-28 18:51:11',3,13,'2025-03-07 16:31:45',3,'2025-03-07 17:22:58','https://dev3v2.thinklytics.io/#/sharedview/view/9tvNXVJXpIrCo2do2aasizoIXzoMb26N/1','\"\"','2025-02-28 18:51:11','2025-03-07 17:22:58'),(64,1,3,19,3,'after hard sync or inc sync from data management the build status shows empty','','2025-02-28 19:35:36',3,13,'2025-03-10 18:27:19',3,'2025-03-10 18:37:49','https://dev3v2.thinklytics.io/#/preAggregation','[\"1740751536204_814376547.png\"]','2025-02-28 19:35:36','2025-03-10 18:37:49'),(65,1,2,6,1,'sync data in the drop down shows \"data is ysncing so you cant update\"   even though the data is not syncing','','2025-02-28 19:37:53',3,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/metadata/list','','2025-02-28 19:37:53','2025-02-28 19:37:53'),(66,1,1,16,3,'In QA3V2 when I plot the bar chart then take top 5/top 20 the value which has 0 value is plotted on the chart also.\nDashboard - Retail Analysis Dashboard 2\nReport name  -Top 20 Customers By Amount\nhttps://qa3v2.thinklytics.io/','','2025-03-04 15:06:25',3,13,'2025-03-10 18:30:50',3,'2025-03-10 18:37:37','https://qa3v2.thinklytics.io/#/dashboard/view/DBB8fFo5iS/1','\"\"','2025-03-04 15:06:25','2025-03-10 18:37:37'),(67,2,2,15,1,'From 1 metadata max to max 10 dashboards can only be created ','','2025-03-05 13:19:25',3,NULL,NULL,3,'2025-03-05 13:19:45','','\"\"','2025-03-05 13:19:25','2025-03-05 13:19:45'),(68,2,2,20,1,' If you want to create realtime sv then metadata, dashboard & shared view should be single ','','2025-03-05 13:20:19',3,NULL,NULL,NULL,NULL,'','','2025-03-05 13:20:19','2025-03-05 13:20:19'),(69,1,1,5,1,' metadata edit query granularity and with time and without time not coming ','','2025-03-05 13:21:00',3,NULL,NULL,NULL,NULL,'','','2025-03-05 13:21:00','2025-03-05 13:21:00'),(70,1,1,6,1,'Incremental sync success coming but process not completed ','','2025-03-05 13:21:54',3,NULL,NULL,NULL,NULL,'','','2025-03-05 13:21:54','2025-03-05 13:21:54'),(71,1,1,16,3,'While edit the existing calculation (Substr()), report not refreshed and updated','','2025-03-10 11:57:54',12,2,'2025-03-13 16:43:25',12,'2025-03-19 12:49:11','https://dev3v2.thinklytics.io/#/dashboard/edit/DB45lssQ8X/0','[\"1741588074004_607516352.png\"]','2025-03-10 11:57:54','2025-03-19 12:49:11'),(72,1,1,16,1,'case when ${ctn with trans id}=0 then \'null\' else ${Name} end  when using this calc it gives Aggregate column with non aggregate column not possible\n\ndb name:Retail Analysis Dashboard 2 in demo >demo folder','','2025-03-11 13:34:42',3,NULL,NULL,NULL,NULL,'https://qa3v2.thinklytics.io/#/dashboard/edit/DBB8fFo5iS/0','','2025-03-11 13:34:42','2025-03-11 13:34:42'),(73,1,1,16,1,'Include/exclude list keeps loading for calc dim col\ndb name:Retail Analysis Dashboard 2\n\nreport name:Report 44\ncol name: cust witn trans Id 1','','2025-03-11 13:41:09',3,NULL,NULL,3,'2025-03-11 13:42:02','https://qa3v2.thinklytics.io/#/dashboard/edit/DBB8fFo5iS/0','\"\"','2025-03-11 13:41:09','2025-03-11 13:42:02'),(74,1,2,16,3,'Pivot Collapsible report shows 0 , which has data , that shown in pivot customized ','','2025-03-12 16:51:27',12,13,'2025-03-17 18:12:08',12,'2025-03-19 12:46:38','https://dev3v2.thinklytics.io/#/dashboard/view/DBMKLmachk/1','[\"1741778487346_512431348.png\",\"1741778487347_133363442.png\"]','2025-03-12 16:51:27','2025-03-19 12:46:38'),(75,1,2,16,3,'While using 2 dimension row * 2 dimension column * 1 measure , Shows ) in pivot customized , data shows in pivot table for the same condition ','','2025-03-12 17:11:45',12,13,'2025-03-17 18:26:00',12,'2025-03-19 12:45:41','https://dev3v2.thinklytics.io/#/dashboard/view/DBgZ99bTGm/1','[\"1741779704818_368830534.png\",\"1741779704818_754172968.png\"]','2025-03-12 17:11:45','2025-03-19 12:45:41'),(76,1,2,16,3,'Non aggr ref line is not getting plotted on charts\ndbname- ref line','','2025-03-12 19:53:46',3,2,'2025-03-13 11:20:58',3,'2025-03-24 18:40:34','https://dev3v2.thinklytics.io/#/dashboard/edit/DBQpXIVNmy/0','\"\"','2025-03-12 19:53:46','2025-03-24 18:40:34'),(77,1,2,18,3,'after top filter the bottom description comes in center of chart for collapsible chart','','2025-03-13 14:55:18',3,2,'2025-03-13 17:22:29',3,'2025-03-24 13:38:02','http://164.52.193.151:5100/#/dashboard/view/DB7pxlhRao/1','\"\"','2025-03-13 14:55:18','2025-03-24 13:38:02'),(78,1,2,16,3,'In Kongovi Server , While apply Border color , header border color not changed','','2025-03-17 11:04:16',12,2,'2025-03-17 12:52:45',12,'2025-03-19 12:47:28','http://164.52.212.181/#/dashboard/edit/DBzmOLTOq0/0','[\"1742189656511_982340793.png\"]','2025-03-17 11:04:16','2025-03-19 12:47:28'),(79,1,2,16,3,'SubTotal value shows 0 instead of value','','2025-03-17 18:30:40',12,13,'2025-03-18 11:22:54',12,'2025-03-18 11:25:42','http://164.52.193.151:5100/#/dashboard/view/DBlqNCnAYg/1','[\"1742216439803_176676296.png\"]','2025-03-17 18:30:40','2025-03-18 11:25:42'),(80,1,2,18,3,'1 dimension row + 2 dimension column + 1 measure, Subtotal value misplaced in next column instead of current column in report 4','','2025-03-18 11:31:51',12,13,'2025-03-27 11:41:55',12,'2025-03-27 12:15:50','https://dev3v2.thinklytics.io/#/dashboard/view/DBzGruMh3T/1','[\"1742277711195_101841686.png\"]','2025-03-18 11:31:51','2025-03-27 12:15:50'),(81,1,2,16,3,'In Pivot collapsible report , 2 rows + 1 column + 2 measure , sub total value mismatched in report 2\nReport name : 2*1*2','','2025-03-19 17:03:46',12,13,'2025-03-27 11:42:08',12,'2025-03-27 12:15:33','https://dev3v2.thinklytics.io/#/dashboard/view/DBxKjZswdS/1','[\"1742384026304_970346244.png\"]','2025-03-19 17:03:46','2025-03-27 12:15:33'),(82,1,2,18,3,'In Pivot collapsible based report, 2 rows +2columns +2 measure, In subtotal value shows shows zero for particular column.\n\nNote : As Per Report : In kerala state contains, 4 customer names  that 4th customer excluded in sub total calculation.\nDashboard : Pivot_collapsible_2\nReport : 2*2*2','','2025-03-19 17:15:15',12,13,'2025-03-27 11:42:20',12,'2025-03-27 12:15:21','https://dev3v2.thinklytics.io/#/dashboard/view/DB8iJVV9kC/1','[\"1742384827521_951051691.png\"]','2025-03-19 17:15:15','2025-03-27 12:15:21'),(83,1,2,16,1,'In Pivot Collapsible based report , While select two dimensions and unselect any one from them , both get unselected .\nDashboard Name : Pivot_collapsible_2\nReport Name  : 2*2*3','','2025-03-19 17:58:14',12,NULL,NULL,12,'2025-03-20 16:52:52','https://dev3v2.thinklytics.io/#/dashboard/view/DBZJEC1m7D/1','[\"1742387294118_675543034.png\"]','2025-03-19 17:58:14','2025-03-20 16:52:52'),(84,1,2,18,3,'In Pivot Collapsible , Used 2 Dimension calc in row + 2 normal dimension (Same) in column + 2 aggregated measure and 1 normal measure in data , shows empty column for particular state and name.\nDashboard :Pivot_collapsible_3\nReport : 2*2*2','','2025-03-20 11:30:09',12,13,'2025-03-27 11:42:32',12,'2025-03-27 12:14:09','https://dev3v2.thinklytics.io/#/dashboard/view/DBA5rs7phH/1','[\"1742450409178_532994322.png\"]','2025-03-20 11:30:09','2025-03-27 12:14:09'),(85,1,2,18,1,'In Pivot Table collapsible, 2 dimension calc in row + 2 normal dimension in column + 2 aggregated measure and 1 normal measure gives more than 2 decimal places  in avg calc.\nDashboard : Pivot_collapsible_3\nReport : 2*2*3','','2025-03-20 11:39:15',12,NULL,NULL,12,'2025-03-20 16:25:31','https://dev3v2.thinklytics.io/#/dashboard/view/DBLKC3i16c/1','[\"1742450955678_260432063.png\"]','2025-03-20 11:39:15','2025-03-20 16:25:31'),(86,1,2,18,3,'In Pivot Collapsible, Grand total not works properly while using virtual calculation\nReport Name : Vir_Pivot_collaps\nDashboard : Pivot_collapsible_3','','2025-03-20 12:04:34',12,13,'2025-03-27 11:42:48',12,'2025-03-27 12:13:48','https://dev3v2.thinklytics.io/#/dashboard/view/DB2KoKwZgl/1','[\"1742452474359_876839671.png\"]','2025-03-20 12:04:34','2025-03-27 12:13:48'),(87,1,2,18,3,'In Pivot Collapsible , 1 dimension row + 1 measure column + 2 virtual calc , grand total shows wrong value , and initial state it shows 0 for all columns , after edit save multiple times than only it shows value  in Pivot.\nDashboard : Pivot Collapsible_4\nReport : Vir_pivot_collaps','','2025-03-20 13:10:36',12,13,'2025-03-27 11:42:59',12,'2025-03-27 12:12:48','https://dev3v2.thinklytics.io/#/dashboard/view/DB8vzC4q7E/1','[\"1742456436042_713884942.png\",\"1742456436043_519034113.png\"]','2025-03-20 13:10:36','2025-03-27 12:12:48'),(88,1,2,18,3,'If we apply top filter + cross filter + top filter, report  not get updated, it remains in same what we applied in cross filter\nDashboard name : Pivot_With_Top_cross\n\n\nNote : Have to remove cross filter before apply top filter','Explained the logic working correct','2025-03-21 12:40:55',12,2,'2025-03-21 13:02:58',12,'2025-03-21 18:27:28','https://dev3v2.thinklytics.io/#/dashboard/view/DBpU1stBRv/1','[\"1742541055123_944069745.png\"]','2025-03-21 12:40:55','2025-03-21 18:27:28'),(89,1,2,18,3,'In filler chart, Excluded value shows, when we apply same value in top filter.','','2025-03-21 18:31:20',12,2,'2025-03-24 13:08:55',12,'2025-03-24 15:37:20','https://dev3v2.thinklytics.io/#/dashboard/view/DBtiqQhDRg/1','[\"1742562079822_574043018.png\"]','2025-03-21 18:31:20','2025-03-24 15:37:20'),(90,1,2,18,3,'In filler chart, while apply cross filter for the excluded value, it reflects in filler charts based reports','','2025-03-21 18:34:13',12,2,'2025-03-24 13:08:48',12,'2025-03-24 15:37:32','https://dev3v2.thinklytics.io/#/dashboard/view/DBtiqQhDRg/1','[\"1742562252849_953784501.png\"]','2025-03-21 18:34:13','2025-03-24 15:37:32'),(91,1,2,16,1,'If  taken top 6 in tree map then exclude include should show those 6 values only  instead it shows all the dim values\nreport 3','','2025-03-24 12:20:18',3,NULL,NULL,3,'2025-04-29 13:00:56','https://dev3v2.thinklytics.io/#/dashboard/edit/DBLjHta5t2/0','\"\"','2025-03-24 12:20:18','2025-04-29 13:00:56'),(92,1,3,16,3,'Lot of space in the top of of exclude include list treemap chart','','2025-03-24 13:02:21',3,2,'2025-03-24 15:17:22',3,'2025-03-26 11:18:04','https://dev3v2.thinklytics.io/#/dashboard/edit/DBLjHta5t2/0','[\"1742801541341_335476952.png\"]','2025-03-24 13:02:21','2025-03-26 11:18:04'),(93,1,2,16,3,'Sometime include exclude list is empty for filler chart. Or Sometime list loads very late.\nreport 5','','2025-03-24 13:22:19',3,2,'2025-04-29 13:20:42',3,'2025-05-06 18:24:00','https://dev3v2.thinklytics.io/#/dashboard/edit/DBLjHta5t2/0','\"\"','2025-03-24 13:22:19','2025-05-06 18:24:00'),(94,1,2,16,3,'Once the measure is changed for bubble chart the top/Botton N measure validation is not applied - report 14','','2025-03-24 19:37:41',3,2,'2025-03-25 10:26:35',3,'2025-03-26 11:00:04','https://dev3v2.thinklytics.io/#/dashboard/view/DBQpXIVNmy/1','\"\"','2025-03-24 19:37:41','2025-03-26 11:00:04'),(95,1,2,16,3,'In bubble chart settings, lot of space in the top portion of the exclude/include list','','2025-03-24 19:38:58',3,2,'2025-03-25 10:26:12',3,'2025-03-26 11:05:38','https://dev3v2.thinklytics.io/#/dashboard/view/DBQpXIVNmy/1','\"\"','2025-03-24 19:38:58','2025-03-26 11:05:38'),(97,2,3,16,3,'The specific parent folder->sub folder or public folder  where the dashboard is located has to be mentioned. ','','2025-03-25 11:02:42',3,2,'2025-04-16 13:44:57',3,'2025-04-28 13:18:15','','\"\"','2025-03-25 11:02:42','2025-04-28 13:18:15'),(98,2,3,18,3,'The specific parent folder->sub folder or public folder  where the Dashboard is located has to be mentioned. ','','2025-03-25 11:05:48',3,2,'2025-04-24 12:30:36',3,'2025-04-28 13:02:29','','\"\"','2025-03-25 11:05:48','2025-04-28 13:02:29'),(99,2,3,21,3,'The specific parent folder->sub folder or public folder where the sharedview is located has to be mentioned.','','2025-03-25 11:08:49',3,2,'2025-05-01 10:49:51',3,'2025-05-06 17:58:36','','\"\"','2025-03-25 11:08:49','2025-05-06 17:58:36'),(100,1,2,16,3,'Prefix set for measure column (from measure setting) used in  pivot collapsible is not getting applied','','2025-03-26 11:40:09',3,2,'2025-03-26 19:38:36',3,'2025-04-11 10:55:47','https://dev3v2.thinklytics.io/#/dashboard/edit/DByp323uKX/0','\"\"','2025-03-26 11:40:09','2025-04-11 10:55:47'),(101,1,2,16,3,'Suffix set for measure column (from measure setting) used in pivot collapsible is not getting applied','','2025-03-26 11:41:06',3,2,'2025-03-26 19:38:42',3,'2025-04-11 12:52:24','https://dev3v2.thinklytics.io/#/dashboard/edit/DByp323uKX/0','\"\"','2025-03-26 11:41:06','2025-04-11 12:52:24'),(102,1,2,16,3,'Decimal places set for measure column (from measure setting) used in pivot collapsible is not getting applied','','2025-03-26 11:42:20',3,2,'2025-03-26 11:50:41',3,'2025-04-11 13:04:02','https://dev3v2.thinklytics.io/#/dashboard/edit/DByp323uKX/0','\"\"','2025-03-26 11:42:20','2025-04-11 13:04:02'),(103,1,2,16,3,'Thousand Separators set for measure column (from measure setting) used in pivot collapsible is not getting applied','','2025-03-26 11:43:12',3,2,'2025-03-26 19:38:29',3,'2025-04-11 13:03:23','https://dev3v2.thinklytics.io/#/dashboard/edit/DByp323uKX/0','\"\"','2025-03-26 11:43:12','2025-04-11 13:03:23'),(104,1,2,16,3,'Display units set for measure column (from measure setting) used in pivot collapsible is not getting applied','','2025-03-26 11:43:48',3,2,'2025-03-26 19:38:21',3,'2025-04-11 13:03:44','https://dev3v2.thinklytics.io/#/dashboard/edit/DByp323uKX/0','\"\"','2025-03-26 11:43:48','2025-04-11 13:03:44'),(105,1,2,16,1,'top N on data table will remove the sort icon for the measure columns. ','','2025-03-26 13:26:01',3,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/edit/DB4e92zi9Y/0','','2025-03-26 13:26:01','2025-03-26 13:26:01'),(106,1,2,18,1,'In Pivot collapsible, Sub total value shows wrong .\nDashboard Name : test_pivot_measure\nReport :  Report 2\ncustomer_name : Rajana Ram','','2025-03-27 11:59:40',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/view/DBMCCsDLgB/1','[\"1743056980213_753361287.png\"]','2025-03-27 11:59:40','2025-03-27 11:59:40'),(107,2,2,18,3,'Have to add 2 decimal places as default in pivot collapsible.','','2025-03-27 13:04:56',12,2,'2025-03-27 13:20:56',12,'2025-04-01 19:40:47','','\"\"','2025-03-27 13:04:56','2025-04-01 19:40:47'),(108,2,2,16,1,'For pivot collapsible chart,  total tab needs to be included ','','2025-03-31 10:59:00',3,NULL,NULL,3,'2025-03-31 11:06:09','https://dev3v2.thinklytics.io/#/dashboard/edit/DBQpXIVNmy/0','\"\"','2025-03-31 10:59:00','2025-03-31 11:06:09'),(109,2,2,16,1,'For pivot collapsible chart, include/exclude  tab needs to be added ','','2025-03-31 10:59:59',3,NULL,NULL,3,'2025-03-31 11:05:53','https://dev3v2.thinklytics.io/#/dashboard/edit/DBQpXIVNmy/0','\"\"','2025-03-31 10:59:59','2025-03-31 11:05:53'),(110,2,2,16,1,'For pivot collapsible chart, reorder header tab needs to be added','','2025-03-31 11:01:12',3,NULL,NULL,3,'2025-03-31 11:05:32','https://dev3v2.thinklytics.io/#/dashboard/edit/DBQpXIVNmy/0','\"\"','2025-03-31 11:01:12','2025-03-31 11:05:32'),(111,2,2,16,1,'For Pivot collapasible chart, formatting tab needs to be added','','2025-03-31 11:01:47',3,NULL,NULL,3,'2025-03-31 11:05:07','https://dev3v2.thinklytics.io/#/dashboard/edit/DBQpXIVNmy/0','\"\"','2025-03-31 11:01:47','2025-03-31 11:05:07'),(112,2,2,16,3,'For pivot collapsible chart, style tab needs to be added','','2025-03-31 11:03:25',3,2,'2025-03-31 12:33:31',3,'2025-04-11 12:42:23','https://dev3v2.thinklytics.io/#/dashboard/edit/DBQpXIVNmy/0','\"\"','2025-03-31 11:03:25','2025-04-11 12:42:23'),(113,2,2,16,1,'For pivot collapsible chart, description tab needs to be added','','2025-03-31 11:04:13',3,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/edit/DBQpXIVNmy/0','','2025-03-31 11:04:13','2025-03-31 11:04:13'),(114,1,3,3,1,'No option to add new sheet into excel data source , using apend data','','2025-04-01 14:09:35',3,NULL,NULL,NULL,NULL,'','','2025-04-01 14:09:35','2025-04-01 14:09:35'),(115,1,2,15,3,'save dashbaord from dashboard add will not replace dashbaord name and still dsahbaord add is only visible instead of dashbaord edit\nif you click on dashbaord savea gain new name is asked.','','2025-04-01 16:24:16',3,2,'2025-04-01 16:53:48',3,'2025-04-10 18:21:02','','\"\"','2025-04-01 16:24:16','2025-04-10 18:21:02'),(116,1,2,38,1,'User role assign i have access of some folders , but when i try to save the data source it shows only IT folder  in dev3v2.','','2025-04-03 15:36:12',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/administration/user-role-assign','[\"1743674772631_776794084.png\",\"1743674772633_329153062.png\"]','2025-04-03 15:36:12','2025-04-03 15:36:12'),(117,1,2,5,1,'In Prod4, while change the limit, in saved metadata, some columns are not showed ','','2025-04-03 16:52:41',12,NULL,NULL,NULL,NULL,'https://prod4.thinklytics.io/#/metadata/edit/MDxyOUKlfu','[\"1743679361060_419459876.png\"]','2025-04-03 16:52:41','2025-04-03 16:52:41'),(118,1,2,16,1,'validation need to add for formatDate(${Begin Date},\'MMM\')(for comma)','','2025-04-04 14:32:37',3,NULL,NULL,NULL,NULL,'https://prod4.thinklytics.io/#/dashboard/edit/DB5N2cy8dX/0','','2025-04-04 14:32:37','2025-04-04 14:32:37'),(119,1,2,16,1,'Error arises while use this calc \" NVL(${shipping_cost},false)\"  \nError: Error: Parameters must be of the same type (line [2], column [7])\nReport - Report17 in prod4','','2025-04-04 15:31:21',12,NULL,NULL,NULL,NULL,'https://prod4.thinklytics.io/#/dashboard/edit/DBdehfQVMp/0','','2025-04-04 15:31:21','2025-04-04 15:31:21'),(120,1,2,16,1,'In Prod4, Error arises \"Error: Parameters must be of the same type (line [2], column [1667])\" While use this calc\nRunningSum(sum(${shipping_cost}))\nIn Report 25','','2025-04-04 16:01:16',12,NULL,NULL,NULL,NULL,'https://prod4.thinklytics.io/#/dashboard/edit/DBdehfQVMp/0','','2025-04-04 16:01:16','2025-04-04 16:01:16'),(121,1,2,18,1,'Calculations included in report, While apply top filter all reports turn to null','','2025-04-04 16:21:49',12,NULL,NULL,NULL,NULL,'https://prod4.thinklytics.io/#/dashboard/view/DBdehfQVMp/1','[\"1743763909188_440272485.png\"]','2025-04-04 16:21:49','2025-04-04 16:21:49'),(122,1,2,16,3,'While using Gantt chart in dev3v2, applied timeline format as dd-mm-yyyy ,but , it shows report like MM-yyyy.\nin report 7\n\nNote : It because of space issue , while apply x axis rotation angle as 45 /10/0 it overlapped one above another.\n\nSpace issue','','2025-04-08 12:25:11',12,2,'2025-04-10 12:11:53',12,'2025-04-10 15:09:25','https://dev3v2.thinklytics.io/#/dashboard/edit/DBII4Wrxzr/0','[\"1744095311505_897802608.png\"]','2025-04-08 12:25:11','2025-04-10 15:09:25'),(123,1,2,16,3,'In gantt chart , time line applied as MM-yyyy , instead of showing month number, it shows month name .\nIn report 6\n\nNote : dd-mm-yyyy -- 01-01-2025\nmm-yyyy -- 01-2025\nMMM-yyyy -- Jan-2025','','2025-04-08 12:30:42',12,2,'2025-04-09 15:16:09',12,'2025-04-09 16:17:33','https://dev3v2.thinklytics.io/#/dashboard/edit/DBII4Wrxzr/0','[\"1744095642002_752754858.png\"]','2025-04-08 12:30:42','2025-04-09 16:17:33'),(124,1,3,16,3,'In Gantt chart , In timeline format , qaurter name mistyped , have to change it as Quarter .','','2025-04-08 12:41:41',12,2,'2025-04-09 09:55:22',12,'2025-04-09 15:03:01','','[\"1744096301297_565308747.png\"]','2025-04-08 12:41:41','2025-04-09 15:03:01'),(125,1,2,16,1,'In gantt chart based report while hover the data points , tool tip was not shown for all  data co-ordinates','','2025-04-08 12:52:27',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/edit/DBjLn1cvkg/0','[\"1744096947245_183772486.png\"]','2025-04-08 12:52:27','2025-04-08 12:52:27'),(126,1,3,2,1,'The excel ds , after append data should show the last time the data was appended.','','2025-04-08 13:29:54',3,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/datasource/list','','2025-04-08 13:29:54','2025-04-08 13:29:54'),(127,1,3,16,1,'While type the dimension name in gantt chart , selected timeline and selected group color turns unselected upto select the dimension.','','2025-04-08 15:51:55',12,NULL,NULL,NULL,NULL,'','[\"1744107714700_422081244.png\"]','2025-04-08 15:51:55','2025-04-08 15:51:55'),(128,1,3,16,1,'for gantt chart  the description is coming on the x axis','','2025-04-09 12:32:53',3,NULL,NULL,NULL,NULL,'','','2025-04-09 12:32:53','2025-04-09 12:32:53'),(129,1,3,16,3,'quarter format for timeline format in general settings for gantt chart does not get applied. Any format is not getting applied.\n\n','','2025-04-09 12:43:18',3,2,'2025-04-10 11:09:39',3,'2025-04-10 18:32:22','https://dev3v2.thinklytics.io/#/dashboard/edit/DBFz03jinr/0','\"\"','2025-04-09 12:43:18','2025-04-10 18:32:22'),(130,1,3,16,1,'quarter format for timeline format in general settings for gantt chart does not get applied\n','','2025-04-09 12:43:18',3,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/edit/DBFz03jinr/0','','2025-04-09 12:43:18','2025-04-09 12:43:18'),(131,1,2,16,1,'we cant change the colour of the segments of gantt chart','','2025-04-09 13:41:23',3,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/edit/DBFz03jinr/0','','2025-04-09 13:41:23','2025-04-09 13:41:23'),(132,1,2,16,1,'axis name gets overlaped with axis labels(report 4 gantt chart)','','2025-04-09 13:53:51',3,NULL,NULL,3,'2025-04-29 12:40:49','https://dev3v2.thinklytics.io/#/dashboard/edit/DBFz03jinr/0','\"\"','2025-04-09 13:53:51','2025-04-29 12:40:49'),(133,1,2,16,1,'In gantt chart, While apply aggregated calc in duration , chart turns to empty. In report 3\nsum(${daysdiff}) - sum_test\ndateDiff(DAY,${Begin_Date_spm1_COM101},${Actual_End_Date_spm1_COM101}) - daysdiff\n','','2025-04-09 15:18:33',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/edit/DBx24yFkqV/0','[\"1744192113534_775399850.png\",\"1744192113535_353393558.png\"]','2025-04-09 15:18:33','2025-04-09 15:18:33'),(134,1,3,16,1,'In gantt chart, While selecting virtual calculation in duration, it not listed in dropdown, while type the calc name it shows and enable us to select the virtual measure.\nNote: After select the vir_calc nothing  get selected','','2025-04-09 16:15:31',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/edit/DBx24yFkqV/0','[\"1744195531185_848266509.png\"]','2025-04-09 16:15:31','2025-04-09 16:15:31'),(135,1,2,16,3,'In gantt chart, Validation requires, without selecting dimension settings get saved and report turns to empty.','','2025-04-09 16:26:56',12,2,'2025-04-09 17:12:27',12,'2025-04-10 15:16:00','https://dev3v2.thinklytics.io/#/dashboard/edit/DBx24yFkqV/0','[\"1744196216149_573633491.png\"]','2025-04-09 16:26:56','2025-04-10 15:16:00'),(136,1,2,16,1,'scroll is coming for gantt chart in db edit and db view','','2025-04-09 18:17:31',3,NULL,NULL,3,'2025-04-09 18:20:37','https://dev3v2.thinklytics.io/#/dashboard/edit/DBFz03jinr/0','\"\"','2025-04-09 18:17:31','2025-04-09 18:20:37'),(137,1,2,16,3,'In gantt chart , Validation requires without selecting dimension and duration , it saved , and shows empty report in report 8','','2025-04-10 10:46:28',12,2,'2025-04-10 12:10:45',12,'2025-04-10 15:15:36','https://dev3v2.thinklytics.io/#/dashboard/edit/DBx24yFkqV/0','[\"1744262187805_378006769.png\"]','2025-04-10 10:46:28','2025-04-10 15:15:36'),(138,1,2,16,1,'Measure setting not applied to grand total col for pivot collapsible chart(report 11)','','2025-04-11 10:59:26',3,NULL,NULL,3,'2025-04-11 11:06:10','https://dev3v2.thinklytics.io/#/dashboard/edit/DB6Z5FuRFy/0','[\"1744349769310_960967630.png\"]','2025-04-11 10:59:26','2025-04-11 11:06:10'),(139,1,2,16,1,'pivot collapsible chart style , data bg colour not getting applied ','','2025-04-11 11:37:58',3,NULL,NULL,3,'2025-04-11 13:11:50','https://dev3v2.thinklytics.io/#/dashboard/edit/DB6Z5FuRFy/0','[\"1744351677148_400934664.png\",\"1744351677149_279645516.png\"]','2025-04-11 11:37:58','2025-04-11 13:11:50'),(140,1,2,18,3,'While apply average in measure , donut progress chart shows huge value than number widget.','','2025-04-14 11:50:01',12,2,'2025-04-15 13:22:34',12,'2025-04-15 19:17:45','https://dev3v2.thinklytics.io/#/dashboard/view/DBBl7TRfV8/1','[\"1744611601336_619372643.png\"]','2025-04-14 11:50:01','2025-04-15 19:17:45'),(141,1,2,18,3,'In donut progress chart , while use case calc , it shows high decimal values .','','2025-04-14 12:33:02',12,2,'2025-04-14 16:37:56',12,'2025-04-14 16:58:43','https://dev3v2.thinklytics.io/#/dashboard/view/DBBl7TRfV8/1','[\"1744614182261_388497139.png\"]','2025-04-14 12:33:02','2025-04-14 16:58:43'),(142,1,2,18,3,'In donut progress chart , In measure setting applied decimal place as 1 , it shows more decimal places .','Measure setting is not required for donut Progress chart','2025-04-14 12:44:14',12,2,'2025-04-14 19:12:19',12,'2025-04-14 19:20:10','https://dev3v2.thinklytics.io/#/dashboard/edit/DBBl7TRfV8/0','[\"1744614853842_908365777.png\"]','2025-04-14 12:44:14','2025-04-14 19:20:10'),(143,1,2,16,3,'In donut Progress chart , while using normal measure + virtual calc , it shows empty chart .\nIn Report 15\nDashboard Name : Testing_Donut\n\nNote : If virtual calc not works with Donut progress chart , requires validation / alert message.\nAlert Message added','','2025-04-14 16:41:09',12,2,'2025-04-15 13:28:23',12,'2025-04-15 19:16:24','https://dev3v2.thinklytics.io/#/dashboard/edit/DBBl7TRfV8/0','[\"1744629068723_448536199.png\"]','2025-04-14 16:41:09','2025-04-15 19:16:24'),(144,1,2,16,3,'In donut Progress chart , After exclude values in settings , Report 17 shows huge decimal count.','','2025-04-14 16:48:45',12,2,'2025-04-14 18:58:15',12,'2025-04-14 19:17:53','https://dev3v2.thinklytics.io/#/dashboard/edit/DBBl7TRfV8/0','[\"1744629525347_624109765.png\"]','2025-04-14 16:48:45','2025-04-14 19:17:53'),(145,1,2,16,1,'In data table , While apply exclude and include the values , and clicked save , changes not reflected in excluded values .\nIn Report 19','','2025-04-14 16:58:26',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/edit/DBBl7TRfV8/0','[\"1744630106480_903763528.png\"]','2025-04-14 16:58:26','2025-04-14 16:58:26'),(146,1,2,16,3,'In Donut Progress Chart , While applied Normal measure + Normal dimension , It listed created group values below , exclude/include \nReport :20\n\nNote : After clear the cookie and cache , it not shows','','2025-04-14 17:05:16',12,2,'2025-04-15 13:22:55',12,'2025-04-15 19:17:33','https://dev3v2.thinklytics.io/#/dashboard/edit/DBBl7TRfV8/0','[\"1744630515990_370563461.png\"]','2025-04-14 17:05:16','2025-04-15 19:17:33'),(147,1,3,16,3,'exclude inlcude is not implemented for donut progress chart','','2025-04-14 18:29:34',3,2,'2025-04-15 11:18:22',3,'2025-04-28 13:16:06','http://164.52.193.151:5100/#/dashboard/edit/DB7qgpkK4H/0','\"\"','2025-04-14 18:29:34','2025-04-28 13:16:06'),(148,1,3,18,3,'In donut Progress chart , applied measure settings not reflected in report 21.\n\nNote : If it is default , requires validation.','Measure setting is not required for donut Progress chart','2025-04-14 18:37:58',12,2,'2025-04-14 18:58:50',12,'2025-04-14 19:11:59','https://dev3v2.thinklytics.io/#/dashboard/edit/DBBl7TRfV8/0','[\"1744636077856_176850410.png\"]','2025-04-14 18:37:58','2025-04-14 19:11:59'),(149,1,2,16,3,'In donut progress chart , Tooltip and legend not shown\nReport 25\nNote : Not required for donut progress chart','Not required for donut progress chart','2025-04-14 19:19:50',12,2,'2025-04-15 12:08:57',12,'2025-04-15 12:41:25','https://dev3v2.thinklytics.io/#/dashboard/edit/DBBl7TRfV8/0','[\"1744638590337_465219047.png\"]','2025-04-14 19:19:50','2025-04-15 12:41:25'),(150,1,2,18,3,'In donut progress chart , While selecting normal dimension + virtual calc , it generates popup message , while i try to select different chart type it shows error. ','','2025-04-15 13:38:12',12,13,'2025-04-28 11:33:58',12,'2025-04-28 11:37:26','http://164.52.193.151:5100/#/dashboard/edit/DBjyMyqmCv/0','\"\"','2025-04-15 13:38:12','2025-04-28 11:37:26'),(151,1,2,16,3,'Decimal values should be displayed only if they exist or else decimal places with 0 should not be shown(report7)','','2025-04-15 14:11:03',3,2,'2025-04-15 14:13:02',3,'2025-04-28 13:17:57','http://164.52.193.151:5100/#/dashboard/edit/DBL6arD5Zu/0','\"\"','2025-04-15 14:11:03','2025-04-28 13:17:57'),(152,1,3,1,1,'Allowed to access some usergroups , but unable to access the assigned group while saving the datasource.\nLogin : Sivaneshwari@gmail.com\nSivaneshwari@123','','2025-04-16 12:51:18',12,NULL,NULL,NULL,NULL,'','[\"1744788078334_472773572.png\",\"1744788078335_603546076.png\"]','2025-04-16 12:51:18','2025-04-16 12:51:18'),(153,1,2,16,3,'While Selecting donut progress chart , instruction is like select one max  dimension and min 1 measure , while selecting more than measure error arises.','','2025-04-17 12:42:29',12,2,'2025-04-17 12:54:16',12,'2025-04-17 17:29:01','https://dev3v2.thinklytics.io/#/dashboard/edit/DBPC7gcbxF/0','[\"1744873949353_377346795.png\",\"1744873949354_377893198.png\"]','2025-04-17 12:42:29','2025-04-17 17:29:01'),(154,1,3,17,1,'Login id : Sivaneshwari@gmail.com\nPassword : Sivaneshwari@123\nWhile save the dashboard in specific floder , it not listed in particular login.\n\nNote : That dashboards listed in other logins','','2025-04-17 17:43:46',12,NULL,NULL,NULL,NULL,'','','2025-04-17 17:43:46','2025-04-17 17:43:46'),(155,1,2,16,3,'In tree map , while used vir calc along with normal dimension , In settings Apply cross filter radio button enable user to enable and disable the option.\nWhile save the settings it turns to disable automatically \n\nNote : Have to disable the enable and disable option','','2025-04-17 17:57:02',12,2,'2025-04-17 18:05:14',12,'2025-04-21 10:46:15','https://dev3v2.thinklytics.io/#/dashboard/edit/DBj5GAqaH9/0','[\"1744892821876_570709713.png\"]','2025-04-17 17:57:02','2025-04-21 10:46:15'),(156,1,2,18,3,'While 2 vir calc based measures + 2 normal dimensions in data table , it shows empty report ','','2025-04-17 18:04:30',12,13,'2025-04-28 11:33:01',12,'2025-04-28 11:37:39','https://dev3v2.thinklytics.io/#/dashboard/edit/DBj5GAqaH9/0','[\"1744893270384_391102783.png\"]','2025-04-17 18:04:30','2025-04-28 11:37:39'),(157,1,2,16,1,'While add 2dim+2 vir calc , pivot table shows empty report','','2025-04-17 18:05:46',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/edit/DBj5GAqaH9/0','[\"1744893346285_474764331.png\"]','2025-04-17 18:05:46','2025-04-17 18:05:46'),(158,1,2,17,1,'While using Pivot collapsible with 2norm dim + 2 vir calc , it shows all column value as 0','','2025-04-17 18:09:22',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/edit/DBj5GAqaH9/0','[\"1744893562620_895332571.png\"]','2025-04-17 18:09:22','2025-04-17 18:09:22'),(159,1,2,18,1,'In pivot customized , Using 1 row pivot+ 1 column pivot + 1 normal measure , it shows empty report in view mode , while apply filter it shows value.','','2025-04-17 18:20:47',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/view/DBj5GAqaH9/1','[\"1744894246746_188204397.png\",\"1744894246747_318313120.png\"]','2025-04-17 18:20:47','2025-04-17 18:20:47'),(160,1,2,18,1,'While applied top filter bubble chart , composite chart ,etc some of the charts shows empty report.','','2025-04-17 18:31:11',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/view/DBj5GAqaH9/1','[\"1744894871240_234752035.png\"]','2025-04-17 18:31:11','2025-04-17 18:31:11'),(161,1,2,16,3,'While disable the cross filter and try to save the dashboard error arises.\nNote : any changes applied in the settings , Same error arises','','2025-04-21 11:12:09',12,2,'2025-04-25 16:58:14',12,'2025-04-25 17:05:00','https://dev3v2.thinklytics.io/#/dashboard/edit/DBPC7gcbxF/0','[\"1745214129456_430451081.png\"]','2025-04-21 11:12:09','2025-04-25 17:05:00'),(162,1,2,16,3,'tostring() error arisies while using in chart(report 13)','','2025-04-21 16:00:44',3,13,'2025-04-24 11:52:23',3,'2025-04-28 13:05:24','https://dev3v2.thinklytics.io/#/dashboard/edit/DBr7DgLi1T/0','\"\"','2025-04-21 16:00:44','2025-04-28 13:05:24'),(163,1,2,16,3,'chart pivot and customizable gives empty chart','','2025-04-21 16:12:38',3,2,'2025-04-24 11:28:47',3,'2025-04-28 13:18:50','https://dev3v2.thinklytics.io/#/dashboard/edit/DBr7DgLi1T/0','\"\"','2025-04-21 16:12:38','2025-04-28 13:18:50'),(164,1,1,16,3,'speedo meter chart nt plotted (rep 26)','','2025-04-21 16:50:14',3,2,'2025-04-24 11:28:28',3,'2025-04-28 13:17:10','https://dev3v2.thinklytics.io/#/dashboard/edit/DBr7DgLi1T/0','\"\"','2025-04-21 16:50:14','2025-04-28 13:17:10'),(165,1,2,16,1,'In qa3v2 , Using Normal dimension+ Normal measure+ Save report , After try to edit the report settings in edit mode , it shows empty with save and close button\n\nNote : Before save Chart related settings shown\n','','2025-04-22 13:37:03',12,NULL,NULL,NULL,NULL,'https://qa3v2.thinklytics.io/#/dashboard/edit/DBzcVa1bZD/0','[\"1745309222983_730145848.png\"]','2025-04-22 13:37:03','2025-04-22 13:37:03'),(166,1,2,16,1,'if we import dashbard into qa3v2 which was exported from dev3v2 gives error (note that one f the chart in dev3v2 had tostring() calc error)','','2025-04-22 16:35:54',3,NULL,NULL,NULL,NULL,'','','2025-04-22 16:35:54','2025-04-22 16:35:54'),(167,1,1,16,3,'choropleth map not getting plotted .','','2025-04-23 13:48:55',3,2,'2025-04-24 11:24:19',3,'2025-04-28 13:18:26','https://dev3v2.thinklytics.io/#/dashboard/edit/DBr7DgLi1T/0','\"\"','2025-04-23 13:48:55','2025-04-28 13:18:26'),(168,1,2,18,1,'if we filter this month for date filter(Cascade) the same value is not shown for next date filter (cascade) ','','2025-04-24 11:44:19',3,NULL,NULL,3,'2025-04-24 11:48:22','http://164.52.193.151:5100/#/dashboard/view/DBr7DgLi1T/1','\"\"','2025-04-24 11:44:19','2025-04-24 11:48:22'),(169,1,2,18,3,'gantt chart does not highlight the filterd value when filterd any value from itself','','2025-04-24 11:48:10',3,2,'2025-04-24 15:08:13',3,'2025-04-28 13:19:42','http://164.52.193.151:5100/#/dashboard/view/DBr7DgLi1T/1','\"\"','2025-04-24 11:48:10','2025-04-28 13:19:42'),(170,1,2,18,3,'\ndonut progress chart will displlay with decimal places when filterd from gantt chart(auke bay)','','2025-04-24 12:01:24',3,2,'2025-04-24 12:20:04',3,'2025-04-28 13:04:43','https://dev3v2.thinklytics.io/#/dashboard/view/DBz28eJduI/1','\"\"','2025-04-24 12:01:24','2025-04-28 13:04:43'),(171,1,2,18,3,'\nfiltered value not highlighted in pivot collapsible chart. \n\nObserved on reverifying the issue: The COLUMN value which is cross filtered is not  highlighted only ROW value is highlighted','','2025-04-24 12:02:32',3,2,'2025-04-29 15:28:33',3,'2025-05-06 18:11:13','http://164.52.193.151:5100/#/dashboard/view/DBr7DgLi1T/1','\"\"','2025-04-24 12:02:32','2025-05-06 18:11:13'),(172,1,3,16,3,'pivot table collapsible setting has name as pivot table only','','2025-04-24 13:06:27',3,2,'2025-04-24 13:26:44',3,'2025-04-28 13:00:56','https://dev3v2.thinklytics.io/#/dashboard/edit/DBz28eJduI/0','\"\"','2025-04-24 13:06:27','2025-04-28 13:00:56'),(173,1,2,18,3,'If the col and its copy column is selected on pivot collapsible chart then if the row  is selected then col is highlighted','','2025-04-24 16:48:29',3,2,'2025-04-29 15:28:17',3,'2025-05-06 18:22:38','http://164.52.193.151:5100/#/dashboard/view/DBz28eJduI/1','\"\"','2025-04-24 16:48:29','2025-05-06 18:22:38'),(174,1,2,18,1,'Choropleth map cross fitlered value not highlighted','','2025-04-25 11:23:07',3,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/view/DBr7DgLi1T/1','','2025-04-25 11:23:07','2025-04-25 11:23:07'),(175,1,2,23,2,'same condition as shown in image set on sv without tab gives no value . but on db and sv with tab gives values.','','2025-04-25 12:23:13',3,2,'2025-04-29 12:23:29',3,'2025-05-08 13:43:57','https://dev3v2.thinklytics.io/#/sharedview/view/68iSwn5ijkc3wXIvYHuu4xP4QobxpyIt/1','[\"1745563993620_605869599.png\"]','2025-04-25 12:23:13','2025-05-08 13:43:57'),(176,1,2,16,3,'Using , Normal dimension + Virtual_calc + sort by applied , chart turns to empty\n\nDashboard Name : New_calc_Check\nReport : 4','','2025-04-25 12:41:34',12,13,'2025-04-25 16:57:55',12,'2025-04-25 17:05:12','https://dev3v2.thinklytics.io/#/dashboard/edit/DBg5P8J28r/0','[\"1745565093775_387397808.png\"]','2025-04-25 12:41:34','2025-04-25 17:05:12'),(177,1,2,16,3,'Using , Dimension calc + virtual calc , it shows empty report\nDashboard : New_calc_Check\nReport : Report 5','','2025-04-25 12:48:11',12,13,'2025-04-25 16:57:11',12,'2025-04-25 17:05:37','https://dev3v2.thinklytics.io/#/dashboard/edit/DBg5P8J28r/0','[\"1745565490800_601763985.png\"]','2025-04-25 12:48:11','2025-04-25 17:05:37'),(178,1,2,16,3,'Using , Aggregated Calc + Virtual_Calc + Format date (To fetch week) , virtual measure not included in report.\nDashboard : New_calc_Check\nReport : Report 6','','2025-04-25 12:58:41',12,13,'2025-04-25 16:56:28',12,'2025-04-25 17:05:57','https://dev3v2.thinklytics.io/#/dashboard/edit/DBg5P8J28r/0','[\"1745566121298_339911645.png\"]','2025-04-25 12:58:41','2025-04-25 17:05:57'),(179,1,2,16,3,'Using , normal dimension + running sum + dimension calc , chart did not shows proper coordinates .\nReport : Report 8','','2025-04-25 13:39:37',12,13,'2025-04-25 16:56:15',12,'2025-04-25 17:06:13','https://dev3v2.thinklytics.io/#/dashboard/edit/DBg5P8J28r/0','[\"1745568576938_875798926.png\"]','2025-04-25 13:39:37','2025-04-25 17:06:13'),(180,1,2,23,3,' Cannot read properties of undefined (reading \'data\')  when cross filterd is applied on wc and cross filter is removed .filter type is tabbed and cascade and  non cascade','','2025-04-25 13:46:41',3,2,'2025-04-28 11:24:10',3,'2025-05-08 16:01:12','https://dev3v2.thinklytics.io/#/sharedview/view/gl0fYlKZs6bOWP9wmKG0nMBkrJVxkNKB/1','[\"1745569001476_529852091.png\"]','2025-04-25 13:46:41','2025-05-08 16:01:12'),(181,1,2,23,3,'please wait data is loading msg displayed for tabed sv when cross filterd is aplied on wc and corss filter is removed .filter type is tabbed and cascade and  non cascade','','2025-04-25 13:49:45',3,2,'2025-04-29 12:17:23',3,'2025-05-08 14:15:26','https://dev3v2.thinklytics.io/#/sharedview/view/gl0fYlKZs6bOWP9wmKG0nMBkrJVxkNKB/1','\"\"','2025-04-25 13:49:45','2025-05-08 14:15:26'),(182,1,2,23,3,' Cannot read properties of undefined (reading \'data\')  when cross filterd is applied on map and cross filter is removed .filter type is tabbed and cascade and  non cascade','','2025-04-25 13:58:36',3,2,'2025-04-28 11:24:52',3,'2025-04-29 12:03:27','https://dev3v2.thinklytics.io/#/sharedview/view/gl0fYlKZs6bOWP9wmKG0nMBkrJVxkNKB/1','\"\"','2025-04-25 13:58:36','2025-04-29 12:03:27'),(183,1,2,23,3,'filter type is tabbed and cascade and  non cascade , the selected cross filtered  value for gantt chart  is deselected when switched to other tabs ','','2025-04-25 14:02:28',3,2,'2025-04-28 12:20:52',3,'2025-05-08 15:57:55','https://dev3v2.thinklytics.io/#/sharedview/view/gl0fYlKZs6bOWP9wmKG0nMBkrJVxkNKB/1','\"\"','2025-04-25 14:02:28','2025-05-08 15:57:55'),(184,1,2,23,3,'Cannot read properties of undefined (reading \'data\') when cross filterd is applied on choropleth map and cross filter is removed. filter type is tabbed and cascade and  non cascade','','2025-04-25 14:11:47',3,2,'2025-04-28 11:28:13',3,'2025-04-29 12:02:12','https://dev3v2.thinklytics.io/#/sharedview/view/gl0fYlKZs6bOWP9wmKG0nMBkrJVxkNKB/1','\"\"','2025-04-25 14:11:47','2025-04-29 12:02:12'),(185,1,2,16,3,'Using , Format date dimension calc + vir_calc in radar chart, it turns into empty.\nReport : 12','','2025-04-25 15:04:42',12,13,'2025-04-25 16:55:55',12,'2025-04-25 17:06:45','https://dev3v2.thinklytics.io/#/dashboard/edit/DBg5P8J28r/0','[\"1745573681770_232174272.png\"]','2025-04-25 15:04:42','2025-04-25 17:06:45'),(186,1,2,16,3,'While using , Day calc  + virtual calc in pie chart , it shows empty report.\nReport : report14','','2025-04-25 15:11:47',12,13,'2025-04-25 16:55:44',12,'2025-04-25 17:06:24','https://dev3v2.thinklytics.io/#/dashboard/edit/DBg5P8J28r/0','[\"1745574107117_942996802.png\"]','2025-04-25 15:11:47','2025-04-25 17:06:24'),(187,1,2,16,3,'vir sum with bubble chart des not work(report 8)','','2025-04-25 19:48:45',3,2,'2025-04-28 11:13:16',3,'2025-04-28 12:34:07','https://dev3v2.thinklytics.io/#/dashboard/edit/DB2tfeHoCk/0','\"\"','2025-04-25 19:48:45','2025-04-28 12:34:07'),(188,1,2,16,3,'pivot collapsible with virtual doesnot work(gives only zero values)','','2025-04-28 16:29:12',3,2,'2025-04-29 12:14:02',3,'2025-05-08 14:04:30','https://dev3v2.thinklytics.io/#/dashboard/edit/DB2tfeHoCk/0','\"\"','2025-04-28 16:29:12','2025-05-08 14:04:30'),(189,1,2,16,3,'While apply date calc+ virtual calc , shows empty report in dev3v2.','','2025-04-28 18:01:41',12,NULL,NULL,12,'2025-04-28 18:13:05','https://dev3v2.thinklytics.io/#/dashboard/edit/DBTqjq7XLp/0','[\"1745843501640_723154925.png\"]','2025-04-28 18:01:41','2025-04-28 18:13:05'),(190,1,3,16,3,'While applied sort in report and changes applied in measure settings , report changes to original state','','2025-04-28 18:46:27',12,2,'2025-04-29 13:19:24',12,'2025-04-30 12:50:51','https://dev3v2.thinklytics.io/#/dashboard/edit/DBTqjq7XLp/0','\"\"','2025-04-28 18:46:27','2025-04-30 12:50:51'),(191,1,2,16,3,'In Donut chart , While using Week calc + virtual calc it shows empty report \nDashboard Name : Vir_Date_Calc\nReport : Report 15','','2025-04-29 12:06:53',12,NULL,NULL,12,'2025-04-29 12:08:54','https://dev3v2.thinklytics.io/#/dashboard/edit/DBTqjq7XLp/0','[\"1745908613640_145429456.png\"]','2025-04-29 12:06:53','2025-04-29 12:08:54'),(192,1,2,16,3,'in dev3v2 sort on vir calc charts is not working (area,compo, line bar)','','2025-04-29 15:10:18',3,13,'2025-05-01 18:29:27',3,'2025-05-06 17:02:57','https://dev3v2.thinklytics.io/#/dashboard/edit/DB2tfeHoCk/0','\"\"','2025-04-29 15:10:18','2025-05-06 17:02:57'),(193,1,2,18,3,'While apply top filter it not reflected in data table sir.','','2025-04-29 15:57:00',12,2,'2025-05-05 18:11:57',12,'2025-05-06 10:53:53','https://dev3v2.thinklytics.io/#/dashboard/view/DBTqjq7XLp/1','[\"1745922420146_655756470.png\"]','2025-04-29 15:57:00','2025-05-06 10:53:53'),(194,1,2,16,3,'While using Nested calc along with date calc , it shows empty report \nReport : Report 1\nDashboard : Nested_Calc_Date_Calc','','2025-04-29 16:09:19',12,13,'2025-05-05 18:11:43',12,'2025-05-06 10:54:44','https://dev3v2.thinklytics.io/#/dashboard/edit/DBbf1znZeK/0','[\"1745923158602_235006813.png\"]','2025-04-29 16:09:19','2025-05-06 10:54:44'),(195,1,2,16,1,'While using 2 measures (Vir , sum) + normal dimension , and applied sort in any one measure , not reflected in both measures\nReport : Report 1\n\nNote : In dev3v2 if we apply sorting in any one measure t reflected on other too\nhttps://dev3v2.thinklytics.io/#/dashboard/edit/DBg5P8J28r/0  - report 1','','2025-04-29 17:00:22',12,NULL,NULL,NULL,NULL,'https://qa3v2.thinklytics.io/#/dashboard/edit/DBpugpObfo/0','[\"1745926221596_896107675.png\"]','2025-04-29 17:00:22','2025-04-29 17:00:22'),(196,1,2,16,3,'in male female chart same value should not be allowed to be selected for male and female format  -validation added','','2025-04-29 17:04:24',3,2,'2025-04-30 11:54:12',3,'2025-05-06 18:01:50','https://dev3v2.thinklytics.io/#/dashboard/edit/DB2tfeHoCk/0','\"\"','2025-04-29 17:04:24','2025-05-06 18:01:50'),(197,1,2,16,1,'Compared Virtual calc+normal dimension , value differs in dev3v2 than qa3v2\n\nNote : IN qa3v2 it shows correct value ','','2025-04-29 18:24:11',12,NULL,NULL,NULL,NULL,'https://qa3v2.thinklytics.io/#/dashboard/edit/DBpugpObfo/0','[\"1745931251331_769635740.png\",\"1745931251335_841743612.png\"]','2025-04-29 18:24:11','2025-04-29 18:24:11'),(198,1,2,16,3,'Value mismatched withmysql table \nUsed Aggregated calc and Virtual calc as measure and normal dimension \n\nCheck report 1 along with other 2 reports \n\n\nNote : After applied and removed sort , value matched with mysql table','','2025-04-30 12:54:35',12,13,'2025-04-30 14:47:47',12,'2025-04-30 15:01:50','https://dev3v2.thinklytics.io/#/dashboard/edit/DBCeljh38G/0','[\"1745997874737_766173641.png\",\"1745997874738_182783115.png\"]','2025-04-30 12:54:35','2025-04-30 15:01:50'),(199,1,2,16,3,'data table vir min max along with normal col does not work ','','2025-04-30 19:30:45',3,13,'2025-05-01 18:29:18',3,'2025-05-06 17:03:28','https://dev3v2.thinklytics.io/#/dashboard/edit/DB2tfeHoCk/0','\"\"','2025-04-30 19:30:45','2025-05-06 17:03:28'),(201,1,2,16,3,'vir sum and vir cnt with sort does not work ','','2025-04-30 19:42:21',3,13,'2025-05-06 10:53:09',3,'2025-05-06 16:39:03','https://dev3v2.thinklytics.io/#/dashboard/edit/DB2tfeHoCk/0','\"\"','2025-04-30 19:42:21','2025-05-06 16:39:03'),(202,1,2,5,3,'The specific parent folder->sub folder or public folder where the metadata is located  has to be mentioned.','','2025-05-01 10:48:42',3,2,'2025-05-01 10:50:39',3,'2025-05-06 17:58:23','','\"\"','2025-05-01 10:48:42','2025-05-06 17:58:23'),(203,1,2,16,3,'While using virtual calc in pivot table , it not shows value for all the columns in dev3v2\nReport : Report 17','','2025-05-01 12:12:05',12,13,'2025-05-05 18:11:13',12,'2025-05-06 10:54:34','https://dev3v2.thinklytics.io/#/dashboard/edit/DBmQqd404Y/0','[\"1746081724922_750842710.png\",\"1746081724924_804138794.png\",\"1746081724924_372162808.png\"]','2025-05-01 12:12:05','2025-05-06 10:54:34'),(204,1,2,16,3,'While adding normal measure along with , virtual calc in pivot customized table , it shows empty column for normal measure \nReport : Report 18','','2025-05-01 12:43:23',12,13,'2025-05-05 18:11:05',12,'2025-05-06 10:54:23','https://dev3v2.thinklytics.io/#/dashboard/edit/DBmQqd404Y/0','[\"1746083603373_309952350.png\"]','2025-05-01 12:43:23','2025-05-06 10:54:23'),(205,1,2,16,3,' While using  normal dimension + 1 aggregated measure , 1 normal measure and 1 virtual measure , it shows 0 for all column except virtual calc used column.\nReport : Report 20','','2025-05-01 15:15:19',12,NULL,NULL,12,'2025-05-01 15:37:24','https://dev3v2.thinklytics.io/#/dashboard/edit/DBmQqd404Y/0','[\"1746092719240_248798695.png\"]','2025-05-01 15:15:19','2025-05-01 15:37:24'),(206,1,2,16,3,'in cube edit + * / - are not needed instead <,>,<=,>=,=  can be added','','2025-05-01 19:36:57',3,2,'2025-05-02 12:43:33',3,'2025-05-06 16:42:32','','\"\"','2025-05-01 19:36:57','2025-05-06 16:42:32'),(207,1,2,16,3,'on cube add> add filter getting query validate error.','','2025-05-01 19:51:22',3,13,'2025-05-02 12:26:51',3,'2025-05-06 17:01:15','https://dev3v2.thinklytics.io/#/dashboard/cube','\"\"','2025-05-01 19:51:22','2025-05-06 17:01:15'),(209,1,2,16,3,'filter added in cube add will not be displayed when we edit cube from dashboard edit.','','2025-05-02 12:46:55',3,2,'2025-05-02 15:48:47',3,'2025-05-06 16:41:36','https://dev3v2.thinklytics.io/#/dashboard/view/DBxt5RqyyO/1','\"\"','2025-05-02 12:46:55','2025-05-06 16:41:36'),(210,1,2,16,3,'error msg displayed in edit cube . Double quotes not allowed outside of single quotes','','2025-05-02 13:34:14',3,2,'2025-05-02 15:48:23',3,'2025-05-06 16:42:11','http://164.52.193.151:5100/#/dashboard/edit/DBaamHahMx/0','\"\"','2025-05-02 13:34:14','2025-05-06 16:42:11'),(211,1,2,16,3,'In edit cube modal from db edit the case statement gives error \"WHERE clause must be a condition (line [1], column [61])\"','','2025-05-02 15:44:49',3,2,'2025-05-06 10:52:17',3,'2025-05-06 16:40:07','http://164.52.193.151:5100/#/dashboard/edit/DBkGGCUthF/0','\"\"','2025-05-02 15:44:49','2025-05-06 16:40:07'),(212,1,2,16,3,'In edit cube modal from db edit , when the filter condition is changed , the charts shows no data','','2025-05-02 15:47:21',3,2,'2025-05-06 10:52:26',3,'2025-05-06 16:40:51','http://164.52.193.151:5100/#/dashboard/edit/DBkGGCUthF/0','\"\"','2025-05-02 15:47:21','2025-05-06 16:40:51'),(213,1,2,23,3,'While applied and removed cross filter in data table, selected column turns to background color what we applied.\n','','2025-05-05 17:25:33',12,2,'2025-05-05 18:10:12',12,'2025-05-06 10:54:12','https://dev3v2.thinklytics.io/#/sharedview/view/vuW4rPI941JFVVyUzxuSWcPdPwSq61gT/1','[]','2025-05-05 17:25:33','2025-05-06 10:54:12'),(214,1,2,16,2,'vir col value with grp cat is showing decimal places for first value in that category(report8)','','2025-05-06 11:40:43',3,2,'2025-05-09 18:26:36',3,'2025-05-06 11:57:24','https://dev3v2.thinklytics.io/#/dashboard/edit/DB3fyvMujo/0','[\"1746512283787_181417291.png\"]','2025-05-06 11:40:43','2025-05-09 18:26:36'),(215,1,2,23,1,'While applied and removed cross filter in data table font type changed to default.\nReport :General data','','2025-05-06 14:12:17',12,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/sharedview/view/vuW4rPI941JFVVyUzxuSWcPdPwSq61gT/1','[\"1746520937377_923331970.png\"]','2025-05-06 14:12:17','2025-05-06 14:12:17'),(216,1,2,16,2,'The specific parent folder->sub folder or public folder where the metadata is located which is displayed does not appear properly ','','2025-05-06 17:56:07',3,2,'2025-05-09 17:09:01',3,'2025-05-09 16:29:18','https://dev3v2.thinklytics.io/#/metadata/edit/MD7atxJrnd','\"\"','2025-05-06 17:56:07','2025-05-09 17:09:01'),(217,1,1,14,2,'The column names are not listed in the cube edit(excel ds,api ds)','','2025-05-12 13:30:56',3,2,'2025-05-12 15:27:24',3,'2025-05-12 14:32:38','https://dev3v2.thinklytics.io/#/dashboard/edit/DBq5mnaVjk/0','\"\"','2025-05-12 13:30:56','2025-05-12 15:27:24'),(218,1,2,16,1,'parse date gives nulll value(report 7)','','2025-05-12 17:38:24',3,NULL,NULL,NULL,NULL,'https://dev3v2.thinklytics.io/#/dashboard/edit/DBCzHy8b9w/0','','2025-05-12 17:38:24','2025-05-12 17:38:24');

--
-- Table structure for table `issueStatus`
--

CREATE TABLE `issueStatus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` varchar(200) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `issueStatus`
--

INSERT INTO `issueStatus` VALUES (1,'Open','2024-12-30 12:37:45','2024-12-30 12:37:45'),(2,'Resolved','2024-12-30 12:38:02','2024-12-30 12:38:02'),(3,'Working','2024-12-30 12:38:07','2024-12-30 12:38:07');

--
-- Table structure for table `issueType`
--

CREATE TABLE `issueType` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(200) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `issueType`
--

INSERT INTO `issueType` VALUES (1,'Issue','2024-12-30 18:51:16','2025-01-02 15:55:17'),(2,'Feature','2024-12-30 18:52:13','2025-01-07 13:28:54');

--
-- Table structure for table `module`
--

CREATE TABLE `module` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` text,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `module`
--

INSERT INTO `module` VALUES (1,'Datasource Add','2025-02-04 15:40:49','2025-02-04 15:40:49'),(2,'Datasource Edit','2025-02-04 15:40:56','2025-02-04 15:40:56'),(3,'Datasource List','2025-02-04 15:41:24','2025-02-04 15:41:24'),(4,'Metadata Add','2025-02-04 15:41:39','2025-02-04 15:41:39'),(5,'Metadata Edit','2025-02-04 15:41:45','2025-02-04 15:41:45'),(6,'Metadata List','2025-02-04 15:41:52','2025-02-04 15:41:52'),(7,'Metadata Blending Add','2025-02-04 15:42:14','2025-02-04 15:42:14'),(8,'Metadata Blending Edit','2025-02-04 15:42:57','2025-02-04 15:42:57'),(9,'Metadata Blending List','2025-02-04 15:43:02','2025-02-04 15:43:02'),(10,'Machine Learning Add','2025-02-04 15:43:18','2025-02-04 15:43:18'),(11,'Machine Learning Edit','2025-02-04 15:43:24','2025-02-04 15:43:24'),(12,'Machine Learning List','2025-02-04 15:43:29','2025-02-04 15:43:29'),(13,'Machine Learning View','2025-02-04 15:43:36','2025-02-04 15:43:36'),(14,'Dashboard Cube','2025-02-04 15:44:06','2025-02-04 15:44:06'),(15,'Dashboard Add','2025-02-04 15:44:18','2025-02-04 15:44:18'),(16,'Dashboard Edit','2025-02-04 15:44:22','2025-02-04 15:44:22'),(17,'Dashboard List','2025-02-04 15:44:33','2025-02-04 15:44:33'),(18,'Dashboard View','2025-02-04 15:44:47','2025-02-04 15:44:47'),(19,'Pre Aggregation','2025-02-04 15:45:18','2025-02-04 15:45:18'),(20,'Shared View Add','2025-02-04 15:45:26','2025-02-04 15:45:26'),(21,'Shared View Edit','2025-02-04 15:45:31','2025-02-04 15:45:31'),(22,'Shared View List','2025-02-04 15:45:39','2025-02-04 15:45:39'),(23,'Shared View - View','2025-02-04 15:45:53','2025-02-04 15:45:53'),(24,'Shared View - Public View','2025-02-04 15:46:24','2025-02-04 15:46:24'),(25,'AI Query','2025-02-04 15:46:45','2025-02-04 15:46:45'),(26,'AI Prompt','2025-02-04 15:46:52','2025-02-04 15:46:52'),(27,'Administration - Email - Email Group','2025-02-04 16:00:23','2025-02-04 16:00:23'),(28,'Administration - Email - Email Notification','2025-02-04 19:11:15','2025-02-04 19:11:15'),(29,'Administration - Email - Share Report','2025-02-04 19:30:24','2025-02-04 19:30:24'),(30,'Administration - Data Management','2025-02-04 19:30:38','2025-02-04 19:30:38'),(31,'Administration - Report Group - Datasource','2025-02-04 19:30:50','2025-02-04 19:30:50'),(32,'Administration - Report Group - Metadata','2025-02-04 19:30:57','2025-02-04 19:30:57'),(33,'Administration - Report Group - Dashboard','2025-02-04 19:31:09','2025-02-04 19:31:09'),(34,'Administration - Report Group - Sharedview','2025-02-04 19:31:18','2025-02-04 19:31:18'),(35,'Administration - Role','2025-02-04 19:31:36','2025-02-04 19:31:36'),(36,'Administration - Role Security','2025-02-04 19:31:45','2025-02-04 19:31:45'),(37,'Administration - User Group','2025-02-04 19:31:54','2025-02-04 19:31:54'),(38,'Administration - User Role Assign','2025-02-04 19:32:03','2025-02-04 19:32:03'),(39,'Administration - Server - Status','2025-02-04 19:32:19','2025-02-04 19:32:19'),(40,'Administration - Server - Realtime','2025-02-04 19:32:27','2025-02-04 19:32:27');

--
-- Table structure for table `permission`
--

CREATE TABLE `permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text,
  `order` text,
  `displayName` text,
  `description` text,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `permission`
--

INSERT INTO `permission` VALUES (1,'issue-list','1','Issue List','Issue List','2025-01-02 15:55:17','2025-01-02 15:55:17'),(2,'issue-add','1','Issue Add','Issue Add','2025-01-02 15:55:17','2025-01-02 15:55:17'),(3,'issue-edit','1','Issue Edit','Issue Edit','2025-01-02 15:55:17','2025-01-02 15:55:17'),(4,'issue-delete','1','Issue Delete','Issue Delete','2025-01-02 15:55:17','2025-01-02 15:55:17'),(5,'administration','2','Administration','Administration','2025-01-02 15:55:17','2025-01-02 15:55:17');

--
-- Table structure for table `permissionRole`
--

CREATE TABLE `permissionRole` (
  `permissionId` int(11) NOT NULL,
  `roleId` int(11) NOT NULL,
  PRIMARY KEY (`permissionId`,`roleId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `permissionRole`
--

INSERT INTO `permissionRole` VALUES (1,1),(1,2),(1,3),(2,1),(2,3),(3,1),(3,2),(3,3),(4,1),(4,3),(5,1);

--
-- Table structure for table `priority`
--

CREATE TABLE `priority` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `priority` varchar(200) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `priority`
--

INSERT INTO `priority` VALUES (1,'High','2024-12-30 12:55:21','2024-12-30 12:55:21'),(2,'Medium','2024-12-30 12:56:13','2024-12-30 12:56:13'),(3,'Low','2024-12-30 12:56:59','2025-01-07 13:28:35');

--
-- Table structure for table `role`
--

CREATE TABLE `role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `role`
--

INSERT INTO `role` VALUES (1,'Admin','2025-01-02 15:55:17','2025-01-02 15:55:17'),(2,'Developer','2025-01-02 15:55:17','2025-01-02 15:55:17'),(3,'Tester','2025-01-02 15:55:17','2025-01-02 15:55:17');

--
-- Table structure for table `userRole`
--

CREATE TABLE `userRole` (
  `userID` int(11) NOT NULL,
  `roleID` int(11) NOT NULL,
  PRIMARY KEY (`userID`,`roleID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userRole`
--

INSERT INTO `userRole` VALUES (1,1),(2,2),(3,3),(12,3),(13,2),(14,3);


