Hi,

 

Does anyone know what table they are in, I need to reset them once a year.

 

We, when a record is generated with Autonumber, we add to the Autonumber field, the year. So we need each year to have a new numbering, starting with 1.

 

Thanks in advance

 

Julio Falcón

Like 2

Like

10 comments

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

Show all comments

Hi, mentors, 

 

      I'd like to have the function to auto save for specific field when lookup change,  instead of clicking the Save button. 

I think it might need the handler function is js, if existed, please kindly share. 

 

Jeffrey. 

 

Like 0

Like

1 comments
Best reply

You'll need to add a change request handler to know when the lookup value has changed. See https://customerfx.com/article/responding-to-an-event-when-a-field-is-changed-on-a-creatio-freedom-ui-page/

Then you'll execute a crt.SaveRecordRequest to save the record. See https://customerfx.com/article/saving-a-page-before-some-action-on-a-creatio-freedom-ui-page/

Ryan

You'll need to add a change request handler to know when the lookup value has changed. See https://customerfx.com/article/responding-to-an-event-when-a-field-is-changed-on-a-creatio-freedom-ui-page/

Then you'll execute a crt.SaveRecordRequest to save the record. See https://customerfx.com/article/saving-a-page-before-some-action-on-a-creatio-freedom-ui-page/

Ryan

Show all comments

Dears

 

Again in Creatio 8.1.4 we found not available the selection of a contact to create a new Creatio User.

 

To enable this you need to enable the SysAdminUnitFeatures.ShowContactInAdminUnit Feature.

 

But when did it, and try to save get an error "Name field must be filled in".

 

Had somebody try this?, is some workorund? or another way to enable select a contact to cerate a New User in STUDIO Creatio instance (JUST Studio)

 

Thanks

 

Julio Falcón

 

 

Like 2

Like

2 comments

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.

 

Show all comments

Dears

 

Somebody knows how to enable use Ststic Filders in Freedopm UI Sections to new sections?

 

I have enabled the IsAllowUseStaticFolders Feature, also added my object to "Schemas for enable static folder in folder tree"  lookup and still have not enabled in my section to add static folders. What's wrong/missing?

 

Thanks in advance,

 

Best regards

Julio Falcón

Like 2

Like

2 comments

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:
  • folder tree

 

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

 

 

 

Show all comments

Hello,

 

For limited internal licenses, the user is only supposed to have access to one section.  How do you set this access up?  

Like 1

Like

4 comments
Best reply

Hello,

You need to create a new user workplace with the type "Limited internal."  

Then, add the desired section to this workplace. 

After that, create a specific role where you will add users with this type of license.

Finally, add this role to the "User groups" detail.


You can get more information by watching this part of the instruction video.

 

Hi,

 

1. Define a new functional role.
  
2. Assign specific users to the functional role (Users tab).
  
3. Users can be assigned to the functional role, replacing existing administrator and employee roles.
  
4. Create one new workplace setup and add the section and user groups  

Hello,

You need to create a new user workplace with the type "Limited internal."  

Then, add the desired section to this workplace. 

After that, create a specific role where you will add users with this type of license.

Finally, add this role to the "User groups" detail.


You can get more information by watching this part of the instruction video.

 

Bala Koteswarareddy,

Thank you!  This worked perfectly.  I made a new Limited Internal workplace and gave access to a new functional role which I'm assigning the Limited internal users to.

Antonii Viazovskyi, Thank you!  This worked perfectly.  I made a new Limited Internal workplace and gave access to a new functional role which I'm assigning the Limited internal users to.

 

Show all comments

Hello!

I'm trying to make an integration with a digital signature call "Firmamex" and I trying to use the code that they provide in their SDK in a business process but i have error messages that dont let me publish the script task. 

This are the errors 

 

And this is the source code of the process. I already try to put a return true; at the end of the script task but stills send me the error. 

 

I hope you can help me.

 

namespace Terrasoft.Core.Process
{
 
    using Newtonsoft.Json;
    using SignmageSDK;
    using SignmageSDKCore;
    using System;
    using System.Collections.Generic;
    using System.Collections.ObjectModel;
    using System.Drawing;
    using System.Globalization;
    using System.Text;
    using System.Web;
    using Terrasoft.Common;
    using Terrasoft.Configuration;
    using Terrasoft.Core;
    using Terrasoft.Core.Configuration;
    using Terrasoft.Core.DB;
    using Terrasoft.Core.Entities;
    using Terrasoft.Core.Process;
    using Terrasoft.Core.Process.Configuration;
 
    #region Class: UsrfirmamexMethodsWrapper
 
    /// <exclude/>
    public class UsrfirmamexMethodsWrapper : ProcessModel
    {
 
        public UsrfirmamexMethodsWrapper(Process process)
            : base(process) {
            AddScriptTaskMethod("ScriptTask1Execute", ScriptTask1Execute);
        }
 
        #region Methods: Private
 
        private bool ScriptTask1Execute(ProcessExecutingContext context) {
            }
            public class Flow
                {
                    SignmageSDK.FirmamexServices signmageServices;
                    String base64;
                    String name;
 
                    public Flow(SignmageSDK.FirmamexServices signmageServices, String base64, String name)
                    {
                        this.signmageServices = signmageServices;
                        this.base64 = base64;
                        this.name = name;
                    }
 
                    public String request()
                    {
                        B64_doc b64_doc = new B64_doc { name = name, data = base64 };
 
                        JObject flujoEjemplo = JObject.FromObject(new
                        {
                            b64_doc = b64_doc,
                            stickers = new object[] {
                                new {
                                    authority = "SAT",
                                    stickerType = "line",
                                    dataType = "rfc",
                                    data = "ARCX9012226P8",
                                    imageType = "hash",
                                    email = "jhon@gmail.com",
                                    page = "0",
                                    rect = new Rect { lx = 226.45f, ly = 355.25f, tx = 397.75f, ty = 413.85f }
                                }
                            },
                            workflow = new object[] {
                                new {
                                    data = "ARCX9012226P8"
                                }
                            },
                            app2 = true
                        });
 
                        String flujoParams = flujoEjemplo.ToString(Formatting.None);
                        return signmageServices.request(flujoParams);
                    }
                }
            };
        }
 
        #endregion
 
    }
 
    #endregion
 
}
Like 0

Like

2 comments

Hello Laura,
Thank you for your question.

I have some updates regarding you issue. 

First of all, indeed the generated code contains errors in lines 88 and 92 due to #endregion directives are being set in the wrong place.
1

Secondly, if you have a script task in your business process you might want to return a bool value inside it because the body of the script task if actually a body of a generated method (in your case ScriptTask1Execute).


Thirdly, it is impossible from my side to verify implementation of third-party code so i am unable to state that the code you provided will work. 

Lastly, if you have multiple versions of your business process that contain compilation errors, it is recommended to either correct them in all versions or delete them in the Configuration section of your application.

Hello Yevhenii Grytsiuk,

 

After the comments you left me, I have made some changes.

I have tried to place a return bool but every time I place it I get another error, so I have omitted it in order to be able to test if the script works. 
However, despite my attempts I still cannot remove this error "Type or namespace definition, or end-of-file expected"
It doesn't allow me to move the #endregion around, and even if I move the brackets it leaves it the same. In fact, that part is placed automatically when publishing the script, so I don't know how to move it so that I can stop having the error. 
If you have any idea on how to move it to remove the error, I would greatly appreciate it if you shared it with me.

Show all comments

Hey, everyone! 

I've got 2 teams working together on the same portal and each of them must see a different page for "Contacts". 
I'm courrently using the Freedom UI to create everything and, on papper, it seems to be working fine, but not on practice..

I've got a "contact" replacing object on another application and that one is done and working. I don't want to create lots and lots of business rules on that page to "work" for everyone, so, to make it work, I've created a new replacing object for contacts on another application and created a new freedomUI section for that (edited the form page and everything). The thing is: Whenever I open my "contact" section from the second application, it opens up the list and form page from my frist replacing object!

 

Anyone has already seen something like this and can help out how to configure propperly?

Already went to "Workplace setup" and checked that I'm using the "New" replacing object that I've created and checked that, on the object manager (EntitySchemaDesigner), the "Default page" has the page I want and on the Workplace Page setup (where I link the sections I want to appear) is propperly configured (when I click on the Contacts that is there and then "List setup" or "Page setup" it directs me to the page I want, not the old one).

 

Thanks for now! 

Like 2

Like

4 comments

We have a similar question, for working on two different case pages and sections based on the same object. Needed some development in Classic UI, unsure how to replicate in Freemdom UI.

Dear Gabriel,


You can add typed pages for roles "All employees" or "External users" and their respective types in the list settings:

Page setup

 

This can also be implemented with code.

 

The following articles might help you with this implementation:
https://academy.creatio.com/docs/8.x/no-code-customization/customization-tools/ui-and-business-logic-customization/set-up-the-app/customize-portal-freedom-ui

https://academy.creatio.com/docs/8.x/no-code-customization/customization-tools/ui-and-business-logic-customization/set-up-the-app/set-up-typified-pages

 

Have a great day!

Whats about if I want to inherit from a previous Freedom page to get the base page configuration and add the specific to the new one, like in Classic UI?

Julio.Falcon_Nodos,

 

To create a replacing Freedom UI page, you need first to enable feature "AllowCreateAngularSchema". After that, the "Angular replacing view model" item will appear in the Add button in WorkspaceExplorer.

 

Have a great day!

Show all comments

I'm seeing system settings for the new password reset feature but no detailed documentation on setting this up.  Can someone confirm this feature is ready in 8.3 and the step by step for displaying it on the login screen?

Like 0

Like

0 comments
Show all comments

Dears

 

Is it possible to edit the Components? I need to present contact name fields in this order:

  1. First Name
  2. Middle Name
  3. Last Name

 

Actually the order is other

 

Thanks in advance

 

Best regards

Julio

Like 2

Like

3 comments
Best reply

Hello,

Unfortunately, for now, it is not possible to edit and add additional fields in the short contact and account profile using the basic application tools. However, we have registered this idea for the responsible R&D team to consider and implement in future releases of the application. 

Thank you for helping us to improve our product. 

Hello,

Unfortunately, for now, it is not possible to edit and add additional fields in the short contact and account profile using the basic application tools. However, we have registered this idea for the responsible R&D team to consider and implement in future releases of the application. 

Thank you for helping us to improve our product. 

Yes please ! :)

Malika,

Thanks

Show all comments