Hello,

Apparently, the system does not look at the "Current Package" setting and will save administrative changes as a copy of an object in the custom package.

Hence why currently there are no OOTB tools to transfer administration settings and this task can be only achieved by means of development.



Information relating to the tables is given below:



- SysAdminUnit (Administration object: users and roles)

- SysUserInRole (Users in roles)

- SysFuncRoleInOrgRole (Functional role into organizational role)

- SysAdminOperation (System operations)

- SysAdminOperationGrantee (Access to system operations)

- SysEntitySchemaOperationRight (Access to objects)

- SysEntitySchemaRecordDefRight (Access to default records)

- SysEntitySchemaColumnRight - (Access to object columns)

- SysAdminUnitGrantedRight - (Delegated)

- SysWorkplace - (User Workplace)

- SysAdminUnitInWorkplace - (Users in the workplace)

- SysModuleInWorkplace - (Section in workplace)

I tried to bind these tables but was unable to do so

Satyam Kumar,

Please note that you must have at least basic developer skills to perform this procedure.

To generate queries, you can use tools like Microsoft SQL Server Database Publishing Wizard. The resulting SQL script should be attached to the package (tab - "SQL Scripts").

Hello,



As of now the corresponding article about Custom OpenID is still in progress, but it should be available on our Academy soon. 

In the Url field the main endpoint should be specified.

In order to avoid any errors we'd suggest to double-check whether the field is populated with a correct value. 



Should you have any additional questions, please let us know.

Best regards,

Anastasiia

Hello Thibault,

Would you please provide more details on your question, so that we can check it for you?

Hello Yuliya,

I am calling a third party service in order to obtain an authorization code from scratch. After that, I am redirected back to my edit page with a code. The url looks like this: https://079046-studio.creatio.com/0/Shell/?code=Uq-EurbsQyJ1si-mXiw_DW7…. I would like to know how I can retrieve the code to put it in a business process.

Hello,

Please review this video material, as it may assist you in implementing your task:

https://www.youtube.com/live/mHaGY1DxETw?feature=share&t=292

https://www.youtube.com/live/ehjfcBxpLsQ?feature=share&t=247

Hi, I think you can try this

1. Make parameter to record your code, in my example it is simple string parameter called UsrTest2

2. add script task:

string resultString = "https://079046-studio.creatio.com/0/Shell/?code=Uq-EurbsQyJ1si-mXiw_DW7…";

string part = resultString.Substring(0, resultString.LastIndexOf('#'));

string newURL = part;

string[] parts = newURL.Split('=');

string itIsCode = parts[parts.Length-1];

Set<string>("UsrTest2", itIsCode);

return true;

3. Get some autogenerated page to see the result

4. Result

now my parameter UsrTest2 holds the code from URL. I can use it anywhere in the process now.

Note: this example works if your url is going to be static and there will be no extra symbols. If your url format is changed - this code might not work properly. In that case you will have to query the string to find the code after the word "code=", something like this

foreach (string queryString in queryStrings)
{
 if (queryString.StartsWith("code="))
	{	
    string codeValue = queryString.Substring("==".Length);
     Console.WriteLine(codeValue);
   }
}

Hi, 

Thank you for your answer. The URL will not be static since the code will change with every call. However, I am unsure of how to retrieve the URL string.

You can add your external website in the IFrame inside the app: in the 2.b "Declare the component class" of this article, you should insert your iframe HTML markup. Also, keep in mind that not all sites can be inserted as iframes due to different security settings.

Additionally you can try creating the code that will use Fetch API to authenticate and get data needed.

Hello!

OAuth (Open Authorization) is a trusted, widely used standard protocol for authentication and authorization. It allows users to grant access to their resources on one website or application to a third-party application without disclosing their credentials, such as username and password. This approach enhances security and reduces the risk of credential theft. 

According to the basic logic of OAuth, the connection is created only once and only for one user. You can create another connection for the new user, however, there is no alternative way to bypass the logic as you described.

Hope the information was useful.

Hi,

Thank you for your answer. In that case, I am very curious about how you refresh the token given by the third party application. Essentially, what happens when the token expires ?

Thibault Cros,

To get a refresh_token, it will be necessary to add settings for "Auth code request URL" as it is described here: https://developer.atlassian.com/cloud/jira/platform/oauth-2-3lo-apps/#how-do-i-get-a-new-access-token--if-my-access-token-expires-or-is-revoked-

We will be glad to help with any other questions.

Hello Altaf, 

In order to enable OAuth2.0 functionality for the cloud-based instance, you need to contact our support team using support@creatio.com.

The functionality will be enabled from our side and there will be no need to populate the settings manually. 

Best regards,

Anastasiia

Hello,

Please find information about platform basics here.



You can also find information organizational roles are user groups that represent company units, departments or subdivisions in the organizational structure here.

 

In addition to the above, I could see the source code section on the downloaded https://academy.creatio.com/docs/node/2311 package with many autogenerated function related to event triggers. If I check my custom object it only has getter and setter for each columns.

To autogenerate the source code I have tried 

1. Generate schemas

2. Publish

3. Complie

All options I have tried but Source code is not generated.

Thanks

From the screenshots it look like the column you're storing the number in is "UsrCode", however the screenshots show you're attempting to set that in a column named "Code".

Change the line that says:

Entity.SetColumnValue("Code", UserTask1.ResultCode);

To this:

Entity.SetColumnValue("UsrCode", UserTask1.ResultCode);

Secondly, it's unlikely that the name of the UserTask component (the element titled "Generate ordinal number" in your screenshot) is really just UserTask1 (unless you've changed it to that). To find it's name, select that element, then click the three-dot button on the top of the properties on the right and switch to advanced mode to see the name. Then change the "UserTask1" part of the code in both script tasks to that name (it's likely something like UserTask_ followed by random numbers/letters)

Ryan

Ryan Farley,

Thanks for your reply. I have double checked my code and I have changed it into "UserTask1" also I have shown 2 examples where I am trying to follow the tutorial with property value as "Code" and my custom section with the property as "UsrCodee".

Also, I see this as because of missing source code details for my custom section than the sample SDK which was referenced in the document.

Thanks,

Altaf Hussian

Hello Saun,

Could you please elaborate on your business task?



Best regards,

Bogdan

Hello,

 

Indeed, functionality allowing you to pass collections into a pre-configured page was added not so long ago. 

Collection data can be displayed on the page only when there are adjustments made in the code of the page to process and work with a collection of records. 

 

An example of this page can be found in the bank customer journey product:

“Product selection | ProductSelectionProcessPage” 

And more hints on how to use it in the process are in the respecting academy article:

https://academy.creatio.com/docs/user/finance_and_banking/financial_pro…