Forum Replies Created

  • anuragkumar
    Participant
    • Topics: 22
    • Replies: 27
    # 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
    Participant
    • Topics: 22
    • Replies: 27
    # 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
    Participant
    • Topics: 22
    • Replies: 27
    # 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
    Participant
    • Topics: 22
    • Replies: 27
    # 2 years ago
    Up
    0
    Down
    ::

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

    anuragkumar
    Participant
    • Topics: 22
    • Replies: 27
    # 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
    Participant
    • Topics: 22
    • Replies: 27
    # 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
    Participant
    • Topics: 22
    • Replies: 27
    # 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
    Participant
    • Topics: 22
    • Replies: 27
    # 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
    Participant
    • Topics: 22
    • Replies: 27
    # 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
    Participant
    • Topics: 22
    • Replies: 27
    # 3 years ago
    Up
    0
    Down
    ::

    Thanks Mathieu, for your immediate response.

    anuragkumar
    Participant
    • Topics: 22
    • Replies: 27
    # 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
    Participant
    • Topics: 22
    • Replies: 27
    # 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
    Participant
    • Topics: 22
    • Replies: 27
    # 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
    Participant
    • Topics: 22
    • Replies: 27
    # 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
    Participant
    • Topics: 22
    • Replies: 27
    # 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?

Viewing 15 posts - 1 through 15 (of 26 total)