[anuragkumar]

# 2 years ago

Up

0

Down

::

Hi @mathieuroll, @chris,

Could you please provide some info on this? It would be really time saving for us because our table contains some 30 columns and mapping them one by one in connector output is very tedious.

Regards
Anurag

[anuragkumar]

# 2 years ago

Up

1

Down

::

Hi @Mathieu,

How we can set the table aggregation data from UI designer itself, may be by setting some attribute with the struct field values, so that we need not map all the fields one bu one in the Connector/BO output mapping and just mapping the global struct variable would be fine?
It would be great if you can share the application transport file link if you have created one.

Regards
Anurag

[anuragkumar]

# 2 years ago

Up

0

Down

::

Thanks @Mathieu, let me check now how I can pass the values from the multicombobox to my filtering BO.

[anuragkumar]

# 2 years ago

Up

0

Down

::

I have tried creating a domain type for nullable string, still I  get error while inserting.

[anuragkumar]

# 2 years ago

Up

0

Down

::

Hi @chris,

I am using below insert query in my connector:

INSERT INTO person (name, age,graduatedOn,birth_date_time,isAlive)
VALUES (:name:, :age:Integer:, :graduatedOn:Date:,:birth_date_time:Date:, :isAlive:);

Here, I am passing value from a struct having all string fields.

There is no problem, when I have set all the fields in the struct and none is empty. Insert query runs fine then.

Problem is in below conditions:

1) when age is empty, then I get below error:

{
“message”: “Invalid payload for connector type SQL: Parameter age had invalid format: JSON Literal for type Integer malformed”,
“success”: false
}

2) When age is filled, then I get error for the date field ‘graduatedOn’, error is below:

{
“message”: “Data truncation: Incorrect date value: ” for column ‘graduatedOn’ at row 1″,
“success”: false
}

Please find below the table description:

How can I deal with this situation, as I can have empty fields in my struct if user has not entered any value for it.

Regards

Anurag

 

 

 

 

 

Attachments:

You must be logged in to view attached files.

[anuragkumar]

# 2 years ago

Up

0

Down

::

Hi @Chris,

Thanks for your inputs. Where can I create a datatype that is nullable. I don’t see that option in the struct creation screen attached below.

 

Regards

Anurag

Attachments:

You must be logged in to view attached files.

[anuragkumar]

# 3 years ago

Up

0

Down

::

Hi @ck,

I have entered my gmail password but it is not shown by simplifier once password change is done.

Regards

Anurag

[anuragkumar]

# 3 years ago

Up

0

Down

::

@Chris, @MathieuRoll,

Any inputs here?

I have attached my smtp server settings. I tried all combinations of  SSL and TLS port settings as well.

Also, now if I try to restore the default settings (whose screenshot I backed up earlier), I still get password error as I don’t know the default password for the itizzimo account.

Any help would be highly appreciated, as we have to develop and test some email use cases in simplifier.

Regards

Anurag

Attachments:

You must be logged in to view attached files.

[anuragkumar]

# 3 years ago

Up

0

Down

::

@Chris, @MathieuRoll,

If the nullable is set to no, shouldn’t it show some validation error  on livechange when field gets empty?

Regards

Anurag

[anuragkumar]

# 3 years ago

Up

0

Down

::

Thanks Mathieu, for your immediate response.

[anuragkumar]

# 3 years ago

Up

1

Down

::

@Team,

Found this to be a javascript issue as javascript push work on object references.

Issues solved by pushing the   stringified  JSON parsed objects into the array.

[anuragkumar]

# 3 years ago

Up

0

Down

::

Hi Team, @mathieuroll, @chris

Is there any way I can get the correct id of the inserted record irrespective of other user sessions.
Because its crucial in a parent-child table model in database.

Regards

[anuragkumar]

# 3 years ago

Up

1

Down

::

I found the solution as I had to modify the request as below removing the FOREIGN KEY key-word.

CREATE TABLE IF NOT EXISTS project_assignee (id INTEGER PRIMARY KEY, person, role, status, project_id INTEGER REFERENCES project1 (id) )

[anuragkumar]

# 3 years ago

Up

0

Down

::

Thanks @Chris,

Its returning the correct id which was last inserted.
Only concern is that will it return another id if someone else did an insert from another application session at the same time?
I hope that its restricted to the current user session only.

[anuragkumar]

# 3 years ago

Up

0

Down

::

@Chris

I tried this just now multiple times and its returning 0 always.

Below is the output

"id": [
{
"last_insert_rowid()": 0
}
]

It should return the primary key of the record inserted.

Am I missing something here, some database config?