Has anyone been successful using the CreatioSDK in sending date updates via either InsertQuery or UpdateQuery?

 

I've tried sending dates in all the following formats but all result in an error:

 

yyyy-MM-dd

yyyy-MM-ddTHH:mm:ss

yyyy-MM-ddTHH:mm:ss.fff 

yyyy-MM-ddTHH:mm:ss.fffffffZ

M/d/yyyy

d/M/yyyy

dd/MM/yyyy

 

The dates I'm trying to send are defined as DataValueType.Date and I've tried specifying that in the Update/InsertQuery and in desperation also tried specifying as DataValueType.DateTime. 

 

If I omit dates from the Insert/Update queries the updates are successful. 

 

I can successfully enter dates in the records I'm trying to update via the Creatio UI.

 

Here's an example of a stripped down InsertQuery request, including the DueDate column causes an error 500, if excluded the insert is successful:

 

{

  "QueryId": null,

  "QueryKind": 0,

  "ColumnValues": {

    "Items": {

      "Title": {

        "ExpressionType": 2,

        "IsBlock": false,

        "ColumnPath": null,

        "Parameter": {

          "DataValueType": 1,

          "Value": "Test SDK Three",

          "ArrayValue": null,

          "ShouldSkipConvertion": false

        },

        "FunctionType": 0,

        "MacrosType": 0,

        "FunctionArgument": null,

        "FunctionArguments": null,

        "DateDiffInterval": 0,

        "DatePartType": 0,

        "AggregationType": 0,

        "AggregationEvalType": 0,

        "SubFilters": null,

        "ArithmeticOperation": 0,

        "LeftArithmeticOperand": null,

        "RightArithmeticOperand": null

      },

      "Contact": {

        "ExpressionType": 2,

        "IsBlock": false,

        "ColumnPath": null,

        "Parameter": {

          "DataValueType": 0,

          "Value": "fede06a3-1270-4464-8049-c7afb144a018",

          "ArrayValue": null,

          "ShouldSkipConvertion": false

        },

        "FunctionType": 0,

        "MacrosType": 0,

        "FunctionArgument": null,

        "FunctionArguments": null,

        "DateDiffInterval": 0,

        "DatePartType": 0,

        "AggregationType": 0,

        "AggregationEvalType": 0,

        "SubFilters": null,

        "ArithmeticOperation": 0,

        "LeftArithmeticOperand": null,

        "RightArithmeticOperand": null

      },

      "DueDate": {

        "ExpressionType": 2,

        "IsBlock": false,

        "ColumnPath": null,

        "Parameter": {

          "DataValueType": 8,

          "Value": "2022-05-28",

          "ArrayValue": null,

          "ShouldSkipConvertion": false

        },

        "FunctionType": 0,

        "MacrosType": 0,

        "FunctionArgument": null,

        "FunctionArguments": null,

        "DateDiffInterval": 0,

        "DatePartType": 0,

        "AggregationType": 0,

        "AggregationEvalType": 0,

        "SubFilters": null,

        "ArithmeticOperation": 0,

        "LeftArithmeticOperand": null,

        "RightArithmeticOperand": null

      },

      "Amount": {

        "ExpressionType": 2,

        "IsBlock": false,

        "ColumnPath": null,

        "Parameter": {

          "DataValueType": 5,

          "Value": 6718.35,

          "ArrayValue": null,

          "ShouldSkipConvertion": false

        },

        "FunctionType": 0,

        "MacrosType": 0,

        "FunctionArgument": null,

        "FunctionArguments": null,

        "DateDiffInterval": 0,

        "DatePartType": 0,

        "AggregationType": 0,

        "AggregationEvalType": 0,

        "SubFilters": null,

        "ArithmeticOperation": 0,

        "LeftArithmeticOperand": null,

        "RightArithmeticOperand": null

      },

      "Budget": {

        "ExpressionType": 2,

        "IsBlock": false,

        "ColumnPath": null,

        "Parameter": {

          "DataValueType": 5,

          "Value": 0.0,

          "ArrayValue": null,

          "ShouldSkipConvertion": false

        },

        "FunctionType": 0,

        "MacrosType": 0,

        "FunctionArgument": null,

        "FunctionArguments": null,

        "DateDiffInterval": 0,

        "DatePartType": 0,

        "AggregationType": 0,

        "AggregationEvalType": 0,

        "SubFilters": null,

        "ArithmeticOperation": 0,

        "LeftArithmeticOperand": null,

        "RightArithmeticOperand": null

      }

    }

  },

  "RootSchemaName": "Opportunity",

  "IncludeProcessExecutionData": false

}

 

  

Like 0

Like

1 comments
Best reply

Hello Jerry, 



Please try to pass Date into Creatio with the following format in UTC time:

 

      "dataValueType":8,
      "value":"\"2000-01-01T00:00:00.000\""

Kind regards,
Roman

Hello Jerry, 



Please try to pass Date into Creatio with the following format in UTC time:

 

      "dataValueType":8,
      "value":"\"2000-01-01T00:00:00.000\""

Kind regards,
Roman
Show all comments

Dear mates,

i 'd like to modifiy a process named "ChangeOrder Société émettrice" in order to launch the process only if the order's company is changed.

In the process designer the custom column "Société émettrice" (UsrSocieteEmettrice) does not appear in the system designer:

 

Is it because the process is in another package which has not access to this column (the order objet is in the custom package).

Thank you !

Nicolas

Like 0

Like

1 comments

Hello Nicolas!



We have already registered the issue for our R&D team to fix this functionality in further releases. I will assign your case to this project in order to increase its priority. 

 

To solve this issue we recommend you generate the source code and compile the system.

 

Best regards, 

Anastasiia 

Show all comments

I modified out Lead process and we don't use "nurturing" anymore. This works well for new leads.

When I copy a lead this new document is still placed in the "nurturing" stage. Which process do I have to modify to change this behaviour?

Like 0

Like

10 comments
Best reply

Christian Waidner,

 

You can check here,

 

Thanks,

Sourav

Hello Christian,

 

Could you please clarify what you mean under "new document" and what actions are you doing before the Lead came to the "nurturing" stage?

 

Thank you in advance!

Hello Anastasiia!

 

Workflow:

Click on an existing lead in list view

Click "copy"

A new lead document ("new document") is being creating

This new document is in stage "nurturing" and I want it to be in a different stage.

Christian Waidner,

Anastasiia Stepanova,

Do you need any more explanation? Is there anything i can do to change the starting phase of a copied document?

Anastasiia Stepanova,

Reminder - are you still on it?

Christian Waidner,

 

If I understand correctly, you do not want to copy the DCM stage while copying the existing record, then you can try the following with the lookup used for DCM in the Object itself,

 

Thanks,

Sourav Kumar Samal

Sourav Kumar Samal,

The checkbox is unchecked for my field and I do not think that this will fix my problem.

 

This is the situation, I click on "copy" on an existing lead.

 

The resulting lead stage looks like this:

 

 

I do not have a "nurturing" stage in my lead stage anymore.

Christian Waidner,

 

Could you check what is the default value of the lookup value set in the object ?

 

Thanks,

Sourav

Sourav Kumar Samal,

If you can give me a hint how to find this in the system .... sure

Christian Waidner,

 

You can check here,

 

Thanks,

Sourav

Show all comments

Until recently we have been using the Excel Reports builder without any issue.  We have now started receiving an error (below) when we try to generate a report with calculated Net Sales Entered.  If we remove the columns or generate a different report without these columns there is no issue.  If we add the columns back we again receive the error.  This is an excel report we've had and ran for several months and just now began receiving the error.

 

A severe error occurred on the current command. The results, if any, should be discarded. Operation cancelled by user. Please check filter settings

Like 1

Like

1 comments

Hi Garrett!

I recommend checking your calculation. If the final calculation is more than 2,147,483,647 in a field, integer overflow error occurs. Also, you might want to try basic export with the same parameters or build a dashboard using your data. If errors occur in these cases, the problem is caused not by the add-on but by data.

Show all comments

Hi,

 

Can some one help me,

 

I am using this tutorial for making section grid editable: https://community.creatio.com/articles/editable-grid-section#comment-81…

 

And I have two errors and it doesn't work.

 

My errors are: 

-Heading for label "DataGrid" not found.

-Unable to find column by configuration: "{"className":"Terrasoft.ConfigurationGrid","generateControlsConfig":{"bindTo":"generatActiveRowControlsConfig"},"changeRow":{"bindTo":"changeRow"},"unSelectRow":{"bindTo":"unSelectRow"},"onGridClick":{"bindTo":"onGridClick"},"initActiveRowKeyMap":{"bindTo":"initActiveRowKeyMap"},"activeRowAction":{"bindTo":"onActiveRowAction"},"multiSelect":{"bindTo":"MultiSelect"},"name":"DataGrid"}" .

Like 0

Like

2 comments

Can you post the complete code? Won't be able to see what might be wrong without that.

Ryan

Hi Marko,

 

Please check my reply in the original article, this should help.

 

Best regards,

Oscar

Show all comments

Hi Team,

 

I have configured one business process for creating one notification as soon as a lookup value in a section changes. I have referred the article: https://community.creatio.com/questions/create-notification-communication-center.

 

The issue that I'm facing is not getting any count alert for the new notification received although the notification is present in the notification center info section. The alert for the new notifications count is only visible if the user is already logged in to the system.

 

 

Kindly help.

 

Thanks,

Sarika

Like 0

Like

6 comments

Hello Sarika, 

 

Could you please check if the checkbox "Run following elements in the background" is cleared for the start signal of this business process?

 

If not, please clear it, save the changes and relogin to the system. 

Let us know if the issue persists despite the provided recommendation.

 

Best regards,

Anastasiia

Hi Anastasiia, 

 

I followed your recommendation but the issue is still the same. Please suggest me what to do

Hi team,

 

Please suggest me a solution for this.

 

Thanks

Hi Sarika,

 

I am reaching out to see if you were to resolve the issue. We have a similar problem with our instance as well. 

 

Thanks

Hi Nirupama,

 

I removed the 'message is need to send' parameter from the add notification element and was able to get the notifications successfully.

 

Hope this helps in your case as well.

 

Best Regards,

Sarika

Sarika Sharma,

Thank you for your response. Really appreciate it!

Just a follow up question - did removing that parameter have any impact on the notification getting sent? Were you able to find out what it is used for?

Show all comments

Dear All,

 

is it possible to make a home page with tasks list, calendar view and with some KPI diagrams in one page? 



Thanks for your help.

Timi

Like 0

Like

1 comments

Hello Timea!

 

We will register it in our R&D team backlog for consideration and implementation in future application releases.

Show all comments

Hi community,

 

Hope all are keeping well!

 

Does anyone know if we can remove some of the sections from Mail panel as in the attached picture if we're not using

 

Please kindly advise what can be done

Many thanks

File attachments
Like 0

Like

1 comments
Best reply

Dear Minh, 



If you don't use some of these connections at all you can delete connection between activity and connected object in EntityConnection table. 



In case if you still want to use some of the connections from the list for other Activity Types you can try to override method responsible for forming this dropdown. 

In OOB it's defined in EntityConnectionLinksUtilities mixin. And loadEntityConnectionColumns is the method that loads these column.

The list is being formed with an ESQ and you can try to change the filter condition for it in overriden mixin.



Kind regards,

Roman

Dear Minh, 



If you don't use some of these connections at all you can delete connection between activity and connected object in EntityConnection table. 



In case if you still want to use some of the connections from the list for other Activity Types you can try to override method responsible for forming this dropdown. 

In OOB it's defined in EntityConnectionLinksUtilities mixin. And loadEntityConnectionColumns is the method that loads these column.

The list is being formed with an ESQ and you can try to change the filter condition for it in overriden mixin.



Kind regards,

Roman

Show all comments

Hi,



We would like to send a dashboard, monthly as pdf per email with a process. Any ideas how this can be done ?



Cheers,



Damien

Like 1

Like

2 comments

Hello Damien,

 

Unfortunately, there is no such functionality in our system to export dashboards in PDF format.



We have already registered the idea for our R&D team to implement this functionality in further releases. I will assign your case to this project in order to increase its priority.  



Best regards,

Bogdan

Hello Bogdan,

Are you planning to add the functionality to export dashboards or reports to PDF format?

 

 

Show all comments

Hi Team,

 

I'm looking for a solution where the current date can be fetched from the system in edit page code of a section. 

 

I tried using: 

var today = new Date();

var dd = today.getDate();

 

but is not working. Kindly help

 

Thanks,

Sarika

 

 

 

 

 

 

Like 0

Like

1 comments

Hello Sarika,

 

that seems to be regular JS code which works properly independently from the environment. Could you please specify what is exactly not working? It does not generate a number at all? Or it does generate a wrong one? How exactly are you using later this date?

 

Best regards,

Dariy

Show all comments