Main Region

Grid Change detection on two adjacent Date Fields in Row Edit Mode (FXP-1899)
| | 2 answers | 2 views

AL
Posted by Alex
Jun 10th, 2015 at 18:28
0

I have got a grid with 2 date fields next to each other.

With Grid Change Detection Options set to "MD5 Check, Before DML, After DML" or "Before DML, After DML", if the user sets the second date field to the exact same value as the first date field, the value in the second date field gets reset to the previous value.

I would expect the second date field to be checked independent of the previous date field.

If the Change Detection Options is set to "No Checking", then the second date value gets stored even if it is the same as the first date value. Also a direct database update works fine, and I have checked for triggers..

I can always set the first value to the second value, this does not cause an issue.

I will forward some more debug data.

Please confirm as to whether you can identify the issue here.

2 Comments

AL
Alex on Jun 11th, 2015 at 12:09

The user to update a grid containing a start date and an end date column

The current data is

START_DATE END_DATE 01.01.2015 02.01.2015

She edits the grid and changes the end date to the start data

START_DATE END_DATE 01.01.2015 01.01.2015

once she presses "Update", END_DATE reverts to the previous value

START_DATE END_DATE 01.01.2015 02.01.2015

If I change the change detection options for the grid to "not checked" then after the update we see the expected result

START_DATE and END_DATE 01.01.2015 01.01.2015

AL
Alex on Jun 11th, 2015 at 12:10

I have sent you a screencam and extracts of the server JSON DATA. I have set up a similar test case at our workspace page 60000 but it doesn't reproduce there.

AL
Posted by Alex
Feb 1st, 2017 at 12:43
0

This has been retested in FOEX 2.2 HFXP-2731 and is no longer an issue.

0 Comments

MN
Posted by Matt Nolan
Jun 11th, 2015 at 08:01
0

I am confused by what you have written. Can you please explain using some example data for both date fields, including what they have been set to before saving, what is expected and what the actual result is for each scenario which you have a problem.

Also a test case would be appreciated on demo.tryfoexnow.com to confirm the issue is not because of your environment/setup.

0 Comments

You must log in or sign up to post questions and answers.