Skip to Main Content
Feature Request FR-2067
Product Area Page Components
Status CLOSED

7 Voters

Client side identification of duplicate entries into a Interactive Grid column

fdloubser Public · Oct 14 2021

Idea Summary
Client side identification of duplicate entries into a Interactive Grid column. A Javascript solution to a user entering duplicate data into a column with a unique index, with a nice indication of which rows have duplicated data.

Use Case
You would not have to incrementally save to get a duplicates exist Oracle error. You also would not loose all your entered data. And you cannot sort to find the duplicates, because it requires you to save to do so.

Preferred Solution (Optional)

We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is not feasible in APEX.

Comments

Comments

  • john.snyders APEX Team OP 3.8 years ago (edited 3.7 years ago)

    I can see how this is very useful. The client in general does not have all the data so it can't do the unique test itself and instead would need to use ajax. In some cases this is reasonable in other cases it could be seen as undesired extra network traffic and server load. Viewed in this light it is a special case of https://apexapps.oracle.com/pls/apex/apex_pm/fr/r/FR-222

    One thing to consider is that it is never a 100% solution because there is always a chance that between the time the unique check ajax request returns and the time the IG region is saved someone else could have entered the same value. I realize that in many cases this is good enough. In other cases it is not good enough and different methods are required.

  • fdloubser OP 3.8 years ago

    This is for unsaved client side data, so ajax would only be used for the already saved part. You could make it so that it is a choice if you are willing to accept the additional network traffic.

  • fdloubser OP 3.8 years ago

    It is impossible to view FR-222. Neither through your link or through the search or through url editing.

  • jayson hanes Admin OP 3.7 years ago

    Try now. John's url had a period at the end. You can also search directly with fr222, etc