Rukovoditel Support Forum

I added a Dynamic Date field and added [date_added] in the Formula field then created a new record. Adding the week filter returned a MySQL error on the page. Database Error: 1052 - Column 'field_908' in having clause is ambiguous Query: select e.* , (e.date_added) as field_908 from app_entity_38 e ...

I've finished updating to 2.8 & tested. Still getting no week filter results.

Yes, the only filter I have set is Date Added > Filter by Week 0, it returns no results. There are 84 records for the current week in that entity.
I'm using version 2.7.1. I can try updating to 2.7.2 to see if that fixes but I've had this filter issue for several past versions as well.

Found the date_added field in one of the entities and it is set to bigint (11), default 0 and it was set to YES for null so I changed that to NO. Added a new record and applied the filter, no results. The new install has the date_added field set with YES for null by default. Date & timestamps ar...

I created a new entity with a single text input field, added a record and tried filtering by week and no result. I installed another copy of Rukovoditel with new database and it is working there. To make sure it wasn't a corrupt file, I tried restoring a database backup from the other one to this ne...

Is there any information I could provide to help solve this? Trying with "Date Updated" field also returns no results, even as an admin.

I've had an issue specifically with the "Filter By Week" option even since I started using Rukovoditel. I have never been able to get it to show any results when filtering by week for the "Date Added" field. All other filters are working fine. I didn't have a need to use the week...

Check the link below. One of these methods should work for you. Upload the .js file to your server and use the path of that file to include.

https://www.geeksforgeeks.org/how-to-in ... ript-file/

Thanks, Sergey. But I have noticed none of the fields for the sub entity have that option. I have a couple drop-down lists and a "Value From Parent Entity" field to identify the parent. I've tried adding a "Static Text by Pattern" to copy the parent value field to be searchable, ...

I have a common report on my dashboard for a sub entity but does not show the search bar at the top. Reports for parent entities all have this. How can I enable search for sub entities?