Время создания
Filters

I have a bussiness process whicc extracts some values from a pdf, from the extraction on the pdf, there is a string value: "SecondaryPayerName".
now I have on a table "GCSeekPayer", some values and i need a script task to find if a value is in the "SecondaryPayerName" string.

I'm getting an error about the column "Id" not being found, but the column exists, the table has data, there are no spelling errors.

this is my script:

string secondaryPayerName = Get("SecondaryPayerName");

// Normalize: lowercase and remove spaces
string normalizedSecondaryPayerName = secondaryPayerName?.ToLower().Replace(" ", "") ?? "";

var esq = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "GCSeekPayer");
esq.AddColumn("GCPayerName");
esq.AddColumn("Id");

var entities = esq.GetEntityCollection(UserConnection);

Guid payerCode = Guid.Empty;

foreach (var entity in entities) {
   string payerName = entity.GetTypedColumnValue("GCPayerName");

   if (!string.IsNullOrEmpty(payerName)) {
       // Normalize payer name too
       string normalizedPayerName = payerName.ToLower().Replace(" ", "");

       if (normalizedSecondaryPayerName.Contains(normalizedPayerName)) {
           payerCode = entity.GetTypedColumnValue("Id");
           break;
       }
   }
}

Set("SecondaryPayerCode", payerCode);

return true;

 

Like 0

Like

2 comments

Hello,

There can be a few reasons why you get the error that the column "Id" is not being found:


1. The column name might be case-sensitive or slightly different (e.g., "id" instead of "Id"). Double-check the exact name of the column in the Object Designer and ensure it matches the name used in the code.

2. If the "GCSeekPayer" entity was recently created or modified, the changes might not have been published. Publish the entity to ensure all changes are applied.

3. If the EntitySchemaQuery is not correctly initialized with the schema manager, it might not recognize the columns of the entity. Ensure that the UserConnection.EntitySchemaManager is correctly passed to the EntitySchemaQuery constructor.

4. If the current user does not have permission to access the "Id" column, it might result in an error. Check the permissions for the "GCSeekPayer" entity and ensure the user has access to the "Id" column.
 

Iryna Oriyenko,

Thanks for the reply, I found a solution here:

https://community.creatio.com/questions/get-primary-key-value-entity

I just needed this:

name your Id column:

var idColumnName = esq.AddColumn("Id").Name;

then you can get in your foreach loop:

entity.GetTypedColumnValue<Guid>(idColumnName);

Show all comments
exchangelistener
kubernetes
redis
Studio_Creatio
8.0

As the subject says, I'm curious if anyone has ever done this? We run several on-prem K8s clusters but are interested in moving the EL stuff into Azure.

Like 0

Like

0 comments
Show all comments

Hi,

I know that it's possible to define Accounts pages from a typed fields, but how can I make inheritance of th OOTB one for the 2 others pages ? 

Angular replace option doesn't allow page name modification

 

Like 0

Like

2 comments

Hello.

To address your request, please use the typed pages logic.
We’ve attached the relevant instruction for your reference.

https://academy.creatio.com/docs/8.x/no-code-customization/customizatio…

Valeriia Hromova,

Yes, I read this before posting, but I want to make 2 pages that "inherits" (or replacement page) Accounts_FormPage, then use them in the typed screen. But I don't think it's possible.

Show all comments

Hi everyone,

I was exploring the latest 8.3 release on a trial instance (v8.3.0.3031 to be specific) and I've been unable to add dependencies to packages. I tried adding a dependency and clicked apply - it navigated me to the configuration page, but when I opened the properties of the package again, the added dependencies were missing. 

I faced this issue across multiple trial instances and was just curious if anyone encountered this and figured a solution / workaround.

Regards,
Ramya

Like 0

Like

0 comments
Show all comments
Email
email templates
unsubscribe
Customization
Marketing_Creatio
8.0

Hi Creatio Community,

I have a use case where I’d like to customize the unsubscribe behavior in our email campaigns.

Currently, when we send emails via Creatio, there’s an unsubscribe link included. However, clicking this link unsubscribes the user from all future emails sent from Creatio, regardless of type (newsletter, product updates, offers, etc.).

What I’d like to achieve instead is:

👉 When the user clicks the unsubscribe link in an email, they should be redirected to a preference management page.
👉 On this page, they can choose what kind of emails they want to unsubscribe from – for example:

  • Newsletters
  • Product updates
  • Promotional offers

This would give users more control over their communication preferences and reduce the chances of losing engagement altogether.

Has anyone implemented a similar setup in Creatio or found a workaround? Any guidance on how to configure this or customize the default unsubscribe process would be much appreciated.

Thanks in advance!

Like 1

Like

2 comments

You can create your own custom unsubscribe or preferences webpage that works however you need and maybe uses the Creatio API to communicate with Creatio. As for using that page as the default unsubscribe page, that is a system setting (I think it is the UnsubscribeApplicationUrl setting). You can put whatever URL you want in that setting and it will use that in the subscribe link added to the emails. 

Ryan

I agree, setup in Creatio is not straightforward for a functionality that is crucial today in marketing.

Show all comments