SQL in export template when using records visibility and common report field sorting

Any critical bugs will be fixed within 24-48 hours.
Post Reply
antevasin
Posts: 125
Joined: 24 Mar 2020, 08:57
Name: Spencer Crocker
Location: Corby, UK
Company Name: Unicloud
Contact:

SQL in export template when using records visibility and common report field sorting

Post by antevasin »

Get the error below in this demo
https://rukovoditel.cloud/demo/3.5/inde ... mo_id=3283
sql error.png
If you turn off the records visibility on entity 21
projects records visibility.png
OR you remove the sorting configuration on the My Projects Common Reports then the error message disappears
my projects common report.png
You can see the error message when you Print>My Projects in any of the Projects entity item pages
project 3 item page.png
here is the export template
my projects export template.png
User avatar
support
Site Admin
Posts: 6231
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: SQL in export template when using records visibility and common report field sorting

Post by support »

Found issue. File from archive replace to plugins\ext\classes\templates\
Let me know if it works ok now.
Attachments
export_templates.zip
(9.75 KiB) Downloaded 5 times
antevasin
Posts: 125
Joined: 24 Mar 2020, 08:57
Name: Spencer Crocker
Location: Corby, UK
Company Name: Unicloud
Contact:

Re: SQL in export template when using records visibility and common report field sorting

Post by antevasin »

Thanks! comfirmed it is working on our instance.
Post Reply