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

Please tell me what I am specifying wrong when requesting the Id list:
 

var changedSchemaName = "Contact";
var fieldName = "Address";
changedRecordsList = ["xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx", "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"]; // can be more then 1000
const filterGroup = new sdk.FilterGroup();
filterGroup.addSchemaColumnInFilterWithParameters(sdk.ComparisonType.Equal, "Id", changedRecordsList);
// I read the old values ​​first.                    
const changedModel = await sdk.Model.create(changedSchemaName);
const resultChanging = await changedModel.load({
     attributes: ["Id", fieldName],
     parameters: [{
                    type: sdk.ModelParameterType.Filter,
                    value: filterGroup
	 }]
});

 

As a result, I get an invalid filter error: 

ye {headers: N, status: 500, statusText: 'Internal Server Error', url: 'https://................./DataService/json/SyncReply/SelectQuery', ok: false, …}

  1. error: {responseStatus: {
    1. ErrorCode: "NullReferenceException"
    2. Errors: []
    3. Message: "Object reference not set to an instance of an object."
  2. }, rowsAffected: -1, nextPrcElReady: false, success: false}
  3. headers: N {normalizedNames: Map(0), lazyUpdate: null, lazyInit: ƒ}
  4. message: "Http failure response for https://................./DataService/json/SyncReply/SelectQuery: 500 Internal Server Error"
  5. name: "HttpErrorResponse"
  6. ok: false
  7. status: 500
  8. statusText: "Internal Server Error"
  9. url: "https://................./DataService/json/SyncReply/SelectQuery"

    Thanks/
Like 0

Like

1 comments

I figured it out. filterGroup does not have an "items" property. The example given at https://customerfx.com/article/querying-data-using-filter-conditions-vi… solves this problem:

const newCustomerFilters = Object.assign({}, filterGroup;
newCustomerFilters.items = filterGroup.items;


adds this property. And then it works correctly.

Show all comments

Is there a way to change the language a report would be generated in programmatically? I would like to have the ability to print a report in a language other than the user's set language/culture so that it can be printed in that language for others that don't have access to the system.

 

I have already set up the report and the translations and confirmed that if I manually change the culture of my user account the report properly prints in the correct language.

 

But it seems that trying to change the user's culture in a process doesn't actually change for the user.

 

Here is how I have the process element set up:

Like 1

Like

1 comments

Dear Alexander,

Unfortunately, at the moment, there is no option to generate the report based on the values of certain field.  As a workaround, you can manually change the system language to the required for the person who is generating the report. 

We already created an idea for our R&D team for possible implementation in the future. 

Thank you for making Creatio better!

Show all comments

Hello

In Classic UI I've customized a section page (let me call it "Production Page") with 3 details that must be shown and filtered depending on the record selected in the previous detail.

Let me call "detail 1", "detail 2" and "detail 3" the three details.

Only "detail 1" is visible opening the Production Page.

When the user selects an item from the "detail 1", then "detail 2" becomes visible and is filtered based on the Id of the "detail 1" selectet item.

When the user selects an item from the "detail 2", then "detail 3" becomes visible and is filtered based on the Id of the "detail 2" selectet item.

 

I've implementd it with custom javascript code in my classic ui "Production Page" and works very well.

 

My customer wants to migrate its classic section to Freedom UI, then I must do the same thing in a Freedom UI FormPage using list or datagrid components.

I've not found any documntation or guide on handling list item selection events.

How can I do it?

Is there a way to hide the "Open, Copy and Delete" bullet point shown at the left of the rows of a freedom UI list component?

 

Thanks

Regards

Like 0

Like

1 comments

You can filter a list based on the selected record of another list all using no code in Freedom UI. See this post: https://community.creatio.com/questions/filtering-records-freedom-ui-expanded-list

If you also want to have code that gets the change of the selected row in a list see here: https://community.creatio.com/questions/list-bind-selected-record-or-add-custom-handler-selectionchange

For removing the row toolbar menu with add,copy,delete, see here: https://customerfx.com/article/removing-the-row-toolbar-from-a-creatio-freedom-ui-list-component/

Ryan

Show all comments
Idea
Discussion

Hello everyone! 🌟 

The Clio team is excited to announce that the new version of T.I.D.E 1.2.4 and Clio 8.0.1.15 now allow using T.I.D.E without the need for a separate server configuration. 🚀 This means that starting from this version, all features available for integration with Git are accessible for cloud versions of Creatio. ☁️✨

 

To install or update T.I.D.E. on your environment use the following command

 

clio tide -e YOUR_ENVIRONMENT_NAME

 

p.s. our goal is to provide complete abilities to no-code developers to work with git

 

#git #tide #clio #nocode

2 comments

This is fantastic. Kudos and a huge thank you to the Clio team!

Ryan Farley,

Thanks a lot!

Show all comments

Hi, 

testing the calendar synchronisation with the productivity freedom ui app. Is it possible to limit which outlook meetings are synched back to Creatio? For now it synchronises everything (except private meetings). 

In the 8.1.4 release notes, read about this beta feature note "Synchronization of Office 365 calendar. It is now possible to import meetings that have "Creatio sync" category from Office 365 calendar to Creatio. To access this functionality, contact Creatio support."

Has this feature been released out of beta since 8.1.5 ? Do we still need to contact Creatio Support to use this feature or is there some configuration to do ? Did not find any documentation in the academy....

Thanks, 

Damien

Like 1

Like

1 comments

Hello,

Starting from 8.1.4, there is an option to download from Exchange calendar only the meetings marked with the category Creatio sync:


  • 1. All exported items are marked with a category (newly created or updated)
  • 2. Imported meetings (new or updated) are used in Creatio only if marked with a category.
     

The primary use case for this feature: I do not want to synchronize my private meetings (e.g., doctor appointment or family dinner) to Creatio. So I mark only the meetings that should be synchronized to Creatio with the category Creatio sync.

Important:  This is a global option for a mail service provider in Creatio, it cannot be enabled on per user basis.

This option is available for Office365 / Exchange calendars only. It will not work for Google calendars.

Step-by-step instruction
1. The user should create the category Creatio sync in Outlook calendar:


Outlook categories guide: Use categories in Outlook - Microsoft Support

2. Enable the option in the mail server provider in Creatio. Currently it is possible to do it via SQL request only:

MSSQL

update Mailserver set IsLimitMode = 1 where Id = 'your_mailserver_id'

Oralce
update "Mailserver"
set "IsLimitMode" = true
where "Id" = 'your_mailserver_id'

PostgreSQL
update "Mailserver"
set "IsLimitMode" = true
where "Id" = 'your_mailserver_id'

3. As soon as the option is enabled all meetings exported from Creatio to Outlook will have the Creatio sync category assigned. Only the meetings that the user marked with the category Creatio sync will be synchronized to Creatio.

Environment

  • Version - 8.1.4+

    Note! This is still a beta version of this feature. We would greatly appreciate it if you could share your feedback with us after using this.


    Best regards,
    Malika
Show all comments