Hello,

Here is an instruction with which you can add your own custom icon: 
https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/front-end-development/freedom-ui/remote-module/requirements-for-icons

Best regards,
Ivan

Hi Julio

The AutoNumber value is stored in a Sequence in the database (Postgres Sequence for cloud instances).
For example, you can get the last value of a sequence using this query:
SELECT last_value FROM "Contact_RId_seq".

To reset a sequence, you can use the following query:
ALTER SEQUENCE "seq_name"
RESTART WITH 0;

Hope this helps!

Mohamed Ouederni,

Thanks,

1.- But, can I access this data from a process? 

2.- Have access to this object from a process, 

3.- How to determine which sequence correspond with a specific section?

I have not visible this table from a Creatio Cloud instance, I've enabled an autonumber field in contacts, for example, and not available the table mentioned by @Mohamed, see it

Hi Julio

1- You can run a custom SQL query from a Task Script.
2- No, you don't have access to the sequences.
3- The sequence name is identical to the column UId. You find it in the source code tab of the Object in Advanced settings.

Thanks!

Hello Julio,

Once you add the autonumber column, you'll need to get the UId for the column. You can open the object then select "Open metadata" under the Actions menu, the find the column and get the Guid for the UId. 

That is the name of the sequence in the database. If needed, you can use that to get the next sequence value using this where the guid is the UId for the column (for Postgresql):

SELECT nextval('ed398640-de69-842b-c50c-6c673da5aa98')

Then to reset it to 1 again you can use this (if needed, replace the 1 with whatever number you want the sequence to start at): 

SELECT setval('ed398640-de69-842b-c50c-6c673da5aa98', 1, false);

To do this via a process, you'll need to do a direct database connection and you'll use a script task, see https://customerfx.com/article/executing-direct-sql-statements-in-a-process-or-configuration-web-service-in-creatio-formerly-bpmonline/

Lastly, if you want to get what the last value/number used from the sequence was, you can use:

SELECT last_value FROM "ed398640-de69-842b-c50c-6c673da5aa98"

Ryan

This is No Code ? In Classic UI was sImple, why in Freedom I need NASA certification to do this?

Julio.Falcon_Nodos,

Yes, for now to reset the value it requires the database update (either by Clio, SQL Executor, or asking support to update the value). I do hope we'll get a UI to manage that at some point. The prefix is also set at the object level now, instead of a system setting - so that now requires an object publish to change rather than updating a setting.

Ryan

Ryan Farley,

Thanks for your support Ryan

Julio.Falcon_Nodos,

Hello,

Yes, unfortunately at this moment there is no possibility to reset sequence using No Code. But you can always contact support, and we will be happy to do it for you. We have created a request to the responsible development team to add this functionality in future releases.  

Antonii Viazovskyi,

Thanks Antonii

Hello!

Please publish the ContactCommunication object and then try to run all previous actions.

Kyrylo Atamanenko,

Hello, 

After publishing I get the same error

Hello. 
I implemented similar logic but instead of opening a modal page, i open card for the detail. In case section i added a test detail. When double clicking on a record in this detail onGridRowDoubleClick method is called which set values of record to sessionStorage and opens a UsrTestCardPage. Than init method is called while page is initializing which sets the field values.

Card schema:
 define("UsrTestCardPage", [], function() {
    return {
        entitySchemaName: "UsrTestDetail",
        attributes: {},
        modules: /**SCHEMA_MODULES*/{}/**SCHEMA_MODULES*/,
        details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
        businessRules: /**SCHEMA_BUSINESS_RULES*/{}/**SCHEMA_BUSINESS_RULES*/,
        methods: {
            init: function() {
                this.callParent(arguments);
                this.getSessionStorage();
            },
            
            getSessionStorage: function() {
                var UsrName_SessionValue = sessionStorage.getItem("UsrName_Session");
                var UsrIntColumn_SessionValue = sessionStorage.getItem("UsrIntColumn_Session");
                var Id_SessionValue = sessionStorage.getItem("Id_Session");
                this.set("UsrName", UsrName_SessionValue);
                this.set("UsrIntColumn", UsrIntColumn_SessionValue);
                this.set("Id", Id_SessionValue);
            }
        },
        dataModels: /**SCHEMA_DATA_MODELS*/{}/**SCHEMA_DATA_MODELS*/,
        diff: /**SCHEMA_DIFF*/[
            {
                "operation": "insert",
                "name": "UsrName2a0f6821-93ff-4f8b-a8c0-e58bb9032171",
                "values": {
                    "layout": {
                        "colSpan": 24,
                        "rowSpan": 1,
                        "column": 0,
                        "row": 0,
                        "layoutName": "ProfileContainer"
                    },
                    "bindTo": "UsrName"
                },
                "parentName": "ProfileContainer",
                "propertyName": "items",
                "index": 0
            },
            {
                "operation": "insert",
                "name": "INTEGER406f5583-84ac-4659-9ff8-46b9c72de82a",
                "values": {
                    "layout": {
                        "colSpan": 24,
                        "rowSpan": 1,
                        "column": 0,
                        "row": 1,
                        "layoutName": "ProfileContainer"
                    },
                    "bindTo": "UsrIntColumn",
                    "enabled": true
                },
                "parentName": "ProfileContainer",
                "propertyName": "items",
                "index": 1
            },
            {
                "operation": "insert",
                "name": "LOOKUPcb467c2f-f352-4ac0-90ea-f25c2ed22119",
                "values": {
                    "layout": {
                        "colSpan": 24,
                        "rowSpan": 1,
                        "column": 0,
                        "row": 2,
                        "layoutName": "ProfileContainer"
                    },
                    "bindTo": "UsrCase",
                    "enabled": true,
                    "contentType": 5
                },
                "parentName": "ProfileContainer",
                "propertyName": "items",
                "index": 2
            }
        ]/**SCHEMA_DIFF*/
    };
});

Detail schema:

Hope this helps

Hello,

Unfortunately, the basic functionality of the platform doesn't allow you to filter values specified by you. However, we've registered this idea in our R&D team backlog for consideration and implementation in future application releases. Thank you for helping us to improve our product.

Great idea :) It's like also making sure some inactive values are not only inactive in dropdowns, but also in filters. 

Hello,

1) When adding this feature, you should specify "For all employees".
2) Save for current user. 
3) Enable the feature in general.
 
Then the error shouldn't occur.

Ivan Savenko,

Thanks Ivan

I saw I need to 

1.- Open the Feature page, 

2.- Add the All Employees group, 

3.- Check enable the feature to all Employees,

4.- Click on Status to Enable

5.- Save (Still getting the error, but saves)

6.- Logout & Login and voila, the contact search in System Users is available.

Hello,

Here are a few things that might be missing:

• - Don’t forget to add mass actions (“Add records to static folder”/”Remove records from static folder”) to the required grid;
• - Switch the "Folder storage location" in the designer to FolderTree:
• 

Hanna Skalko,

Thanks Hanna, but in my instance the "Folder Storage Location" is read only, so I can't change it.

SO I cannot also add mass action to add/remove from the static Folder

Also in the Section the "Add static folder" is not enabled

Hi Satyam, 
You can try using crt.7XRequest with action 'EditRecord'/ 'AddRecord'. Please see this article on community : https://community.creatio.com/questions/base-function-lookup-value-clic…

Yurii Sokil,

The Terrasoft modules are also still available. You can use the same code as in classic UI, something like this will work in a Freedom UI request: 

Terrasoft.MiniPageListener.open({
	parameters: {
		entitySchemaName: "Activity"
	},
	valuePairs: [
		{ name: "Type", value: "fbe0acdc-cfc0-df11-b00f-001d60e938c6" },
		{ name: "Contact", value: contactId },
		{ name: "Account", value: accountId }
	],
	miniPageSchemaName: "ActivityMiniPage",
	operation: Terrasoft.ConfigurationEnums.CardOperation.ADD,
	showDelay: 0,
	miniPageSourceSandboxId: null
});

Ryan