Studio Creatio | Community Creatio

10:27 Aug 23, 2021

Hi community,

I've a problem with PATCH method on Region Entity.

I receive a generic error when I try to update a record.

What am I doing wrong ?

Here the postman request.

1) Read the region record to update

2) The error captured on postman when I tried to update the same record founded before

4 comments

11:37 Aug 23, 2021

Hi Stefano,

There can be a problem with the Region object in configuration or another object and that's why an UPDATE fails. You need to:

1) Check the application logs to see the error message that is returned upon a request

2) Go to configurations and generate source code for all items and compile all items and try updating the record after that

Best regards,

Oscar

15:54 Aug 23, 2021

Hi Oscar

thank you for you suggestion.

About the first tip, the issues is on cloud creatio instance, how can I access to application logs ?

16:00 Aug 23, 2021

Stefano Bassoli,

Just email us at support@creatio.com to get the logs of the application for some date.

Best regards,

Oscar

https://community.creatio.com/questions/how-make-radio-button-mandatory…

17:54 Aug 24, 2021

Oscar Dylan,

I understood the problem.

The user associated to oauth did not have permission on operation "

CanManageLookups"

Show all comments

Studio_Creatio

7.15

Check Menu Item

Jose Hernandez

02:57 Aug 18, 2021

Hi,

I added a Check Menu Item on the Actions menu to one of my sections and it works fine, but I have not been able to set the Checked default value base of an attribute set on the init function.

This is what I have:

actionMenuItems.addItem(this.getButtonMenuItem({

                   "Type": "Terrasoft.controls.CheckMenuItem",

                   "Caption": { bindTo: "Resources.Strings.OpenImagesAutomaticallyFromInitialEntryCaption" },

                   "Click": { bindTo: "setOpenImagesAutomaticallyFromInitialEntry" },

                   "Checked": { bindTo: "OpenImagesAutomaticallyFromInitialEntrySetting" }

               }));

but when I go to the menu item, the menu is always unchecked regardless of the value of the boolean attribute OpenImagesAutomaticallyFromInitialEntrySetting.

Any help on how to accomplish that would be greatly appreciated.

Thanks,

Jose

2 comments

Bogdan Lesyk

11:19 Aug 26, 2021

Hello Jose,

Please check my last answer on this post:

Here I explained how to use attribute "Checked" correctly. Although there is a post regarding radio button, however the required logic for "Checked" attribute will be the same.

Best Regards,

Bogdan L.

Jose Hernandez

17:16 Aug 26, 2021

Bogdan Lesyk,

Thanks Bogdan. I will try that.

Show all comments

Studio_Creatio

7.17

Access to cachedsyssettings in mobile

12:40 Aug 09, 2021

Hello Community! There is any way to get the cached syssettings in Mobile?

Equivalent to Terrasoft.SysSettings.cachedSettings in Web

3 comments

Ivanna Yatsura

13:04 Aug 09, 2021

Dear Federico,

You can check Terrasoft.SysSettings in which you can see all stored information from the manifest

Best Regards,

Ivanna Yatsura.

Cell details background color

13:05 Aug 09, 2021

Ivanna Yatsura,

Yes I checked but Can't see the cached syssettings there. I dont know from where are coming those system settings.

Ivanna Yatsura

13:08 Aug 09, 2021

Federico Buffa ,

Unfortunately, it is the only option here.

Best Regards,

Ivanna Yatsura.

Show all comments

details

Studio_Creatio

7.17

15:26 Jul 29, 2021

Hi community

is it possible to change the background color of a single cell on a detail conditionally ?

3 comments

Yurii Sokil

09:02 Jul 30, 2021

Hello Stefano,

Feel free to refer to this answer on out community:

https://community.creatio.com/questions/how-add-custom-style-control-pa…

You'll need to implement such method in the detail page schema, and

change background color in your CSS module.

Best Regards,

Yurii

https://customerfx.com/article/styling-section-list-rows-based-on-condi…

10:14 Aug 04, 2021

Hi Yuril

thank you for you suggestion.

I know the suggested articles.

I need to change the background color of a cell in the detail grid based on the value of some fields of the detail row, but I don't know how to get it.

Ryan Farley

21:34 Aug 04, 2021

Stefano Bassoli,

You can conditionally style a list row based on conditions in the data, however, the list/grid in Creatio doesn't support adding style to specific cells. To style a list row based on conditions in the data of that row, refer to this article

Ryan

Show all comments

Studio_Creatio

7.17

Read Rol of the user from mobile app

14:34 Jul 26, 2021

Hello Community!

I need to read the roles of the user logged in the mobile app. I try with a query sql but I don't have any result (query is working from the sql console). There is any other better option for that?

var sqlText =
			"select u.contactid, u.name, rol.name from  sysUserInRole ur  " +
			"inner join sysadminunit u on ur.sysUserId = u.id inner join " +
			"sysadminunit rol on ur.SysRoleId = rol.id where u.contactid ='" + Terrasoft.CurrentUserInfo.contactId + "'";
		var me = this;
		Terrasoft.Sql.DBExecutor.executeSql({
			sqls: [sqlText],
			success: function(data) {
				if (data.length > 0) {
					var records = data[0].rows;
					for (var i = 0, ln = records.length; i < ln; i++) {
						var sqlData = records.item(i);
 
					}
				}
			}
		});

6 comments

18:26 Jul 26, 2021

Hello Federico,

And have you tried using ESQ select query using the Terrasoft.CurrentUserInfo.contactId as a value for the ESQ filter? Please try this approach as well.

Best regards,

Oscar

18:33 Jul 26, 2021

Oscar Dylan,

Can you give me a example of this query using esq for mobile?

18:44 Jul 26, 2021

Federico Buffa,

I have no example, but the code should be similar to the one below:

var resultArray = [];
var esq = Ext.create("Terrasoft.EntitySchemaQuery", { rootSchemaName: "SysAdminUnitInRole" });
esq.addColumn("SysAdminUnit");
esq.addColumn("SysAdminUnitRole");
esq.filters.addItem(esq.createColumnFilterWithParameter(3, "SysAdminUnit", Terrasoft.CurrentUserInfo.userId));
esq.filters.addItem(esq.createColumnFilterWithParameter(4, "SysAdminUnitRole", Terrasoft.CurrentUserInfo.userId));
esq.getEntityCollection(function (result) {
	if (result.success &amp;&amp; result.collection.getCount() &gt; 0) {
		var item = result.collection.getByIndex(0);
		resultArray.push(item.get("SysAdminUnitRole"));
	}
}, this);

Best regards,

Oscar