Search found 44 matches
- 07 Dec 2023, 11:17
- Forum: Discussion
- Topic: SOLVED - Report Designer Filter
- Replies: 9
- Views: 3298
Re: Report Designer Filter
How can i use the entity for the global list?
- 05 Dec 2023, 10:12
- Forum: Discussion
- Topic: SOLVED - Report Designer Filter
- Replies: 9
- Views: 3298
Re: Report Designer Filter
Hi, I tried creating a global filter for the hazard status. but it is getting the ID from the global list. is it possible that i can configure the ID of the status to be the same as in the entity? IN the screenshot below, you will see that in the reports, the ID 7 of the CLosed Hazard Status is bein...
- 04 Dec 2023, 19:04
- Forum: Suggestions
- Topic: New Filter Options in Report Designer
- Replies: 14
- Views: 4096
Re: New Filter Options in Report Designer
I tried toggling on the Filter by Entity 2 and selected the Leading INdicator Entity, and in the dropdown list it is showing the "HEading COlumn" for the Leading Indicator Entity which is the Location. Is it possible to choose a column in the selected entity other than the heading column? ...
- 04 Dec 2023, 18:31
- Forum: Discussion
- Topic: SOLVED - Report Designer Filter
- Replies: 9
- Views: 3298
SOLVED - Report Designer Filter
HI Sergey, Is it possible to use the Filters Panel "Filter by Entity 3" but the column that will be used is not the Heading column of the Entity selected? For example, I have here the Entity Hazard Reports, its Heading Column is "Hazard Title". I will be using the "Hazard Re...
- 04 Dec 2023, 18:01
- Forum: Discussion
- Topic: Group Records/Data using mySQL query
- Replies: 4
- Views: 1363
Re: Group Records/Data using mySQL query
Thank you Serygey!
- 01 Dec 2023, 20:41
- Forum: Suggestions
- Topic: New Filter Options in Report Designer
- Replies: 14
- Views: 4096
Re: New Filter Options in Report Designer
Hi Sergey, Is it possible to add another report filter but in the same entity of the Filter by Entity 1? Like in the picture below, I toggled on the Filter by Entity 1 using the "Leading Indicator" Entity and "Location" column/field as filter. I would want to add another filter, ...
- 28 Nov 2023, 07:45
- Forum: Discussion
- Topic: Date Filter in Reports not working
- Replies: 3
- Views: 996
Re: Date Filter in Reports not working
The Date Filter in the Entity listing is not working because the date field when saved into the database is in bigint data type. I s there a way we can convert the date filter to bigint to match the date that is in the database?
- 26 Nov 2023, 17:29
- Forum: Discussion
- Topic: Date Filter in Reports not working
- Replies: 3
- Views: 996
Re: Date Filter in Reports not working
The Date Filter in the report is not working because the data type of the date in the database is bigint. Is there a way where I can manipulate the date filter or a query window where I can match the date filter vs the date stored in the db?
- 23 Nov 2023, 18:04
- Forum: Discussion
- Topic: Date Filter in Reports not working
- Replies: 3
- Views: 996
Date Filter in Reports not working
The date filter is not working on the reports. I have found out that the date_added column is saved as datatype bigint in the database. Is there a way to have the date filter work even if the data is in bigint? Attaching a screenshot for your reference.
Regards,
Regards,
- 19 Nov 2023, 03:49
- Forum: Discussion
- Topic: Group Records/Data using mySQL query
- Replies: 4
- Views: 1363
Re: Group Records/Data using mySQL query
Cant I group them using the mySQL Query? Coz I need to show the count of the data in the Inspections Entity per month. In the screenshot below: I need to show the total count for the month of October from the Inspection Entity, it should show in the "Area Inspections Completed" column. Ass...