Question

What schema types CANNOT be configured using the third-party editors in the file system development mode? (Client schemas, Object schemas , schemas with a source code , process schemas)

Can someone explain to me please which can not be configured and why !

Like 0

Like

1 comments

If you think of it this way, which schemas are "text" that are easily understood by any 3rd party text editor? Client schemas are Javascript and source code schemas are C#. Both easily understood and editable by a text editor and can be edited by a 3rd party editor. However, object schemas in Creatio use a UI to add columns etc, it isn't just text. Also processes in Creatio have a complete UI process designer, it is not just text. Both objects and processes cannot be edited by a 3rd party editor since it wouldn't understand all the rest of the stuff the designer UIs in Creatio do. 

Ryan

Show all comments

Hello Creatio team,

How can i activate the Section Wizard option for the followin detail:

This feature is deactivated in the PlanningAccountDetailV2 schema part of Field package

I need to activate the wizard for this task:

Deactivate the filter that filters the accounts based on the selected employee.

Like 0

Like

2 comments
Best reply

Hello Sasori,

 

In order to deactive the filter based on employee it is just needed to click on the cross sign, and you will see all the accounts.

 

Alternatively you can create a replacing view model for the schema PlanningAccountDetailV2 and modify the method getFilters according to your needs.

 define("PlanningAccountDetailV2", [],
    function() {
        return {
            entitySchemaName: "Account",
            attributes: {},
            methods: {
                getFilters: function() {
                     this.callParent(arguments);
                    var filters = this.sandbox.publish("GetSectionFilters");
                    if (!this.Ext.isEmpty(filters.filtersValue)) {
                        this.setFilter(filters.key, filters.filtersValue);
                    }
                }},
            diff: /**SCHEMA_DIFF*/[]/**SCHEMA_DIFF*/
        };
    }
);

 

As for the section wizard, this whole detail was created with code, so it would be not possible to enable it. But the first option by clicking the cross sign would be the more simple one.

 

Best regards,

Dariy
 

Hello Sasori,

 

In order to deactive the filter based on employee it is just needed to click on the cross sign, and you will see all the accounts.

 

Alternatively you can create a replacing view model for the schema PlanningAccountDetailV2 and modify the method getFilters according to your needs.

 define("PlanningAccountDetailV2", [],
    function() {
        return {
            entitySchemaName: "Account",
            attributes: {},
            methods: {
                getFilters: function() {
                     this.callParent(arguments);
                    var filters = this.sandbox.publish("GetSectionFilters");
                    if (!this.Ext.isEmpty(filters.filtersValue)) {
                        this.setFilter(filters.key, filters.filtersValue);
                    }
                }},
            diff: /**SCHEMA_DIFF*/[]/**SCHEMA_DIFF*/
        };
    }
);

 

As for the section wizard, this whole detail was created with code, so it would be not possible to enable it. But the first option by clicking the cross sign would be the more simple one.

 

Best regards,

Dariy
 

Thank you very much Dariy.

Show all comments

Is it possible to export an existing database schema into a creatio datamodel? Or from an ERD Data export?

 

I use lucidchart to create a model of my database, it has export functions for MySQL, PostgreSQL, SQL Server, Oracle SQL and a similar platform as creatio, Quickbase. 

 

Does creatio support such an import wizard?

Like 1

Like

1 comments

Hello Pascal,

 

unfortunately this is not quite possible.

The thing is that you can export the DB in such way, but you will not have any objects in the system.

So we would recommend sticking to the standard way. Also, we will register this option as a wish for the dev team to implement it in the future.

 

Regards,

Gleb.

Show all comments

Hello,

 

I have an inherited Schema in Custom package. There are no changes of functionality there, but there are possible changes in LocalizableStrings.

How can I see, what LocalizableStrings was changes in Page Schema?

 

Thank you!

Like 0

Like

2 comments

Hello,
You can check the LocalizableStrings in the config section.
To do this, you need to open your schema and check the Localizable strings tab:

Cherednichenko Nikita,

Hello, I understand how to check the LocalizableStrings in the schema.

But there are a lot of them. So, how to find, which one was changed?

Thank you.
Vladimir

Show all comments

Hi,

 

I have an editable list and there are some validations. Due to usability issue, we want it back to the normal detail form with a card schema. The records to the detail are added via multiselect lookup. Is there a way to convert this detail to a normal detail while having source as a multi select lookup?

 

Thanks

Like 0

Like

0 comments
Show all comments

Hi all, 

We have sometimes issues with schema generation and/or compilation.

When we update the system (for example 8.0.0 to 8.0.1) , we can easily find the logs related to generating schemas in the update logs.

But when in "normal conditions", which logs (log names) both in the web app and in the logs folders on Windows should we looking at (to follow progress, to identify any issues) when:

1. Generating schemas
2. Compiling

Any other way to (console debug) to troubleshoot these 2 scenarios ?

 

Thanks for your tips !

Cheers,

Damien

Like 0

Like

4 comments

Hello,

 

Thanks for reaching out. 

 

To troubleshoot the issues, compilation logs can be found in application logs. In order to get it, please restore it and review the logs list.

 

Please let us know whether additional questions arise. 

 

Best regards,

Anastasiia

 

 

Hi Anastasiia,

Could you share the full list of of possible application logs files names pertaining to:
 

1) Schema generation

2) Compilations

So that we know exactly which files we need to examine for any troubleshooting.

Thank you,

Damien

Dear Damien,

 

Thanks for your question.

 

All needed application logs for shema generation and compilation can be found in the folder C:\Windows\Temp\Creatio folder. You need to restore the logs and make the following query for your list:

 

PostgreSQL: Select * from "tablename" where "Logger"='Build' order by "Date" desc limit 200

 

MSSQL: Select top 200 * from "tablename" (nolock) where Logger"='Build' order by "Date" desc

 

Best regards,

Anastasiia

 

 

Anastasiia Marushenko,

 

Yes we know we can find all the application logs in that folder.

 

There are multiple different logs. Concerning schema generation and compilation, we have find a couple different ones showing up in the past, not always all of them, which sometimes show up after quite a while of generating, and it's hard to say if we need to let the system running or if the system is just stuck...

 

Please let me reiterate the question: ..... Could you share two full list of of possible application logs file names [for all 3 DBs : MSSQL, PostgreSQL & Oracle] pertaining to:

1. Schema Generation (for example if you just click on "Generate all schemas") and

2. Compilation (if you click on "Compile all")

 

Thank you for the SQL scripts: 

1) Can you share the script for Oracle ?

 

(yes, their is a 3rd database that you support.. and if not possible to do it with Oracle,  indicate specifically that there no script possible. We never know if it is not possible with Oracle, if you forget to provide the information, the latter happens more often)

2) I can be mistaken here: doesn't the table the "build" only show "compilation" information, not schema generation ? For example, if we only do a schema generation (no compilation), will we find information there ?

Thank you,

Damien

Show all comments

Hello Creatio Community,

I have e development env and a test env.

For a specific page schema, the metadata of the page differs from Dev and Test env. The nr of rows is the same , but the content isnt. Is this supposed to be correct ?

 

Like 0

Like

1 comments

Hello,

 

Please be informed that the sole fact of the schemas being a bit different is not a problem, the question is does it cause any actual issues to the performance of the site? Also, please specify if the Test env is a full copy of Dev and if so, was that schema present on the Test env before copying? Also, did you make any changes to the schemas yourself?

 

Kind regards,

Mira

Show all comments

Hello team,

What is the purpose of IsLocked column in the the SysSchema or SysPackage tables.

How does IsLocked affect 

1- Objects

2- Bussines Processes

3- Edit Page schemas

4- Packages

I couldnt find information in the academy regarding this topic.

Thank you

Like 0

Like

1 comments

Hello Petrika,

Parameter IsLocked mainly affects if you can edit the schema or the package.  Only the author of the lock can edit these elements. In the database, this author isn't mentioned and you can see only IsLocked.

The system will check the author on the other level.

Show all comments

Hello community,

I'm trying to install a package using update from file system. After the installation everything is added successfully, except for some objects which have the following status (Source code update required).

I tried the following commands but nothing happens.

The structure of the object in the database is modified successfully but this message is displayed again.

** This happens only with replacing objects.

 

Like 0

Like

3 comments

Hello,

 

Thank you for your question!

 

Please, run database structure update for these objects.

 

After that, 

select Generate For All Schemas (source code) as on the screenshot below:


 

And compile the system:

 

This should resolve the issue.

In case it persists after these recommendations - please, let us know.

 

Regards,

Anastasiia

Anastasiia Lazurenko,

I tried the recommendations you sent but it still did not work. This happened because I was using the landing version 7.18.2.1236 and the package version was newer (7.18.4.1532). After downgrading the package version everything was compiled successfully. 

Hello,

 

Thank you for updating us. Good to know the issue is no longer in place.

 

Regards,

Anastasiia

Show all comments

Dear Community,

I was wondering if there's a comprehensive list somewhere where we can find all the attributes for the schema page.
Some of the examples are:
- In diff we can add different things like

"operation": "delete",
                    "name": "",
                    "propertyName": "",
                    "parentName": "",
                    "values": {}
Where can I find a list of things I can put in the Diff and "values"?
Same thing for messages, attributes, ...

Thank you in advance!

Like 0

Like

3 comments

Hi Yosef,

 

You can find the chain of articles here that describes multiple schema configurations:

https://academy.creatio.com/documents/technic-sdk/7-16/introduction-3

The diff array article among others describes the possbile operations that you refer to

https://academy.creatio.com/documents/technic-sdk/7-16/diff-array

 

Regards,
Dean

dean parrett,

Thank you for the quick response but this isn't exactly what I'm looking for, it sure is a great start for beginners!

What I'm looking for is like an "extended" list. If I want to enable or disable an item, I would be adding the ' "enable": true ' to the diff. This is nowhere to be found on the second link.

While programming I found bits and pieces of information of these properties in different posts, but I'm looking for something more complete in one place.

If anyone knows or has made a list like this, please let me know!
Thank you

Show all comments