When attempting to add or modify a record in a Section Object I am getting these errors.
I had deleted some columns in the object. I am thinking that may be the root of my issues, but I am not sure. Any insight to what may be causing this and how to fix it would be much appreciated!
It has been a long time since I have visited this thread, but I have found the origin of the error. I thought I would post here just in-case someone has similar issues eventually.
Bhoobalan was correct in the sense that the issue was located in the server itself. The error messages are being generated from these 'triggers' within the section schema.
The triggers look like the image below.
I believe these triggers were created when I had added an "Image Link" column type. I am not entirely sure though, so if someone has more insight on the creation and removal of these triggers it would be appreciated! Personally, I had just deleted them from the database and everything seems fine, but I have not robustly tested the functionality as I am working on a different version at this point.
Check the deleted fields and also verify the same has been deleted in all the records. The issue could be the field is deleted from the object but the values stored against the field might be still available in the DB table.
So, delete all the column values in DB where it was stored against the old field "UsrImageId".
Check the deleted fields and also verify the same has been deleted in all the records. The issue could be the field is deleted from the object but the values stored against the field might be still available in the DB table.
So, delete all the column values in DB where it was stored against the old field "UsrImageId".
BR,
Bhoobalan Palanivelu.
Thanks for the quick response Bhoobalan!
I have investigated the issue further in the database and I cannot find any column named "UsrImageId". The only results from a full text database search is the error messages generated which are identical to the ones above.
Is it possible that Creatio had created this column somewhere on the client-side on its own? I am fairly sure that I didn't create this column, but the 'Usr' prefix makes me think otherwise. I will also post the full request below that generates the 500 error.
I have also searched through the application files on the server and still cannot find anywhere were UsrImageId is being used. It should be noted that I followed Ryan's advice in the previous thread I posted and created a virtual column to store Images. Maybe I am missing some nuance about images or virtual columns. I am also not sure where 'old' is coming from as I have never referenced anything as 'old'.
It has been a long time since I have visited this thread, but I have found the origin of the error. I thought I would post here just in-case someone has similar issues eventually.
Bhoobalan was correct in the sense that the issue was located in the server itself. The error messages are being generated from these 'triggers' within the section schema.
The triggers look like the image below.
I believe these triggers were created when I had added an "Image Link" column type. I am not entirely sure though, so if someone has more insight on the creation and removal of these triggers it would be appreciated! Personally, I had just deleted them from the database and everything seems fine, but I have not robustly tested the functionality as I am working on a different version at this point.
The issue seems to be that this tutorial is built to generate links for picture files saved/changed on the record page. Where I would like to do the opposite and display an image from a link that has already been generated elsewhere. The link is from PlantUML and here is an example.
I need to do a custom button implementation, which will download the grid from the detail with all the data that is in the grid, like the similar function of the "PRINT" button.
Please feel to explore the printables in the below thread.
It is explained for Portal users and in the same way, functionality has to be implemented in your custom section (Please be informed to debug the modules explained in the article and use it accordingly for your functionality).
I am trying to make uneditable the Customer column from Opportunity object based on the stages of the opportunity (dcm bar). My only issue is that I cannot find that column, in section wizard I find it as a script object - I am not sure how to work with that.
Hello, and thank you for your help. I added the column in the attributes part of the schema and the function in the methods part. Unfortunately, in the console I get an error saying that my function is not defined. What should I look on further?
I am having the same issue and it is driving me mad. I followed the above steps but the page just hanged when trying to create a new opportunity. Has anyone resolved this?
I tried your solution and the page just hangs when creating a new Opportunity. It does not seem to like the new attribute code. Is there something else that needs to be added?
I'm just getting started working with the new Freedom UI. One thing I'm not able to find any information on is if the new Freedom UI supports mini page popups. If not, is there a something that has been deemed a suitable replacement for that? If not, any plans on the roadmap to add support for this?
Unfortunately, the support for mini pages for Freedom UI is not released yet. I created an idea for our developers to adopt this functionality in the future.
- Сheck that the object has no publishing errors, and compile the application.
- Check the rights to the section/workspace and that the user has the right license.
- Check the mapping in the SysModul table. It is possible that the section was added to the same workplace twice and there are some duplicates at the database level, in this case, the section will simply not show up. You need to delete the entries at the database level and add the section again.
If the above tips do not help, it is better to contact technical support.
I made a post earlier that helped me with a section grid but I currently need to add a custom button that should be on every grid line of a detail that was added in Orders.
As an example in the image above, you should have a custom button on all rows of the Detail grid.
As Dariy Pavlyk mentioned, please share with us what has been implemented. The previously shared article is for the section and please share how did you implement in your scenario (the schemas you used, the implementation you did) With that further investigation could be made.
How can i change the color of a "Finish deadline" (Code:"UsrDueDate") column on some condition in section list page. As mentioned in the below picture.
item.columns.ColumnName (ColumnName should be replaced with the needed column) objecthas no "customStyle" property so it won't be possible using the approach from the article you've shared.t
Additionally the issue is that we could theoretically try using custom CSS, but the issue here is that the grid columns have autogenerated IDs so it will be a complex task to get the element needed in the document to set a custom style. Please use the the approach with marking the whole grid record with some color instead.
item.columns.ColumnName (ColumnName should be replaced with the needed column) objecthas no "customStyle" property so it won't be possible using the approach from the article you've shared.t
Additionally the issue is that we could theoretically try using custom CSS, but the issue here is that the grid columns have autogenerated IDs so it will be a complex task to get the element needed in the document to set a custom style. Please use the the approach with marking the whole grid record with some color instead.
Все прекрасно, при запуске перехожу в мейл бокс, все ок.
2. Пытаюсь добавить раздел мейл бокс в рабочее место (какое именно значения не имеет, везде одинаковая ситуация). Выбираю его, но по факту раздел не добавляется, хотя на 1 сек происходит как-бы обновление страницы и добавление.
В итоге попасть в раздел можно только по ссылке, что весьма неудобно.
Вчера я протестила этот вариант - добавить любой базовый и оказалось, что это тоже не работает. Поэтому написала напрямую в ТП, т.к. это подтверждает проблему не на стороне mail box, а на стороне creatio. Также написала о предложении Владимира очистить Redis. Когда ситуация разрешится, я отпишусь тут.