Search found 44 matches

by amamyoj
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?
by amamyoj
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...
by amamyoj
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? ...
by amamyoj
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...
by amamyoj
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!
by amamyoj
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, ...
by amamyoj
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?
by amamyoj
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?
by amamyoj
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,
by amamyoj
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...