Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Question isdate dosen't work ?

More
13 Feb 2019 14:32 #1 by merzouk
isdate dosen't work ? was created by merzouk
Est ce que la fonction isDate() fonctionne sur stambia ?
je l'ai utilisé dans une condition mais elle ne fait pas les rejets.

Is the function isDate () running on stambia?
I used it in one condition but it does not make rejections.
More
13 Feb 2019 18:13 #2 by Thomas BLETON
Replied by Thomas BLETON on topic isdate dosen't work ?
Hello,
Can you specify which "isDate" function you are referring to?
Is it a database function?
Can you show with a screenshot where you are trying to use it, and how?
More
14 Feb 2019 11:34 #3 by merzouk
Replied by merzouk on topic isdate dosen't work ?
Attachments:
More
14 Feb 2019 13:50 #4 by Thomas BLETON
Replied by Thomas BLETON on topic isdate dosen't work ?
OK, this metadata looks correct. Can you confirm this is a Sql Server table ? or another database ?
Is there an error or simply the mapping is ignoring the Rule ?
How is your mapping configured? Is the "Enable rejects" checkbox enabled on the target?
Can you verify that the SQL query looks correct in the Reject step?
More
14 Feb 2019 15:21 #5 by merzouk
Replied by merzouk on topic isdate dosen't work ?
Hello,
yes thi is sql server
simply the mapping is ignoring the Rule
Attachments:
More
14 Feb 2019 15:49 #6 by Thomas BLETON
Replied by Thomas BLETON on topic isdate dosen't work ?
The mapping looks correct too.
Can you show a sample data which should be rejected, from the source File ?
And this question is important : can you verify that the SQL query looks correct in the Reject step, I mean can you see your isDate() function in the generated SQL statements ?
More
15 Feb 2019 16:59 #7 by merzouk
Replied by merzouk on topic isdate dosen't work ?
Bonjour,
j'ai trouvé la source du problème. le mapping n'était pas sauvegardé.
merci pour votre aide