l10n_nl_bsn: searching on BSN without dots

[thomaspaulb]

l10n_nl_bsn: searching on BSN without dots

[astirpe]

Yes, I agree.
Alternatively we could implement a search method for the bsn field. This will fix the Odoo "advanced search" and probably will also fix the importing by CSV.

[thomaspaulb]

True, but such a search method should then be accompanied by either of these three:

1. A migration script that adds dots to existing BSN's, very strict enforcing that dotless BSN's don't enter the database and searching on BSN's with dots only
2. Some Postgres trick that allows a where search on a transform of the BSN value to something without dots (i dont know if this exists)
3. A stored, indexed computed field without dots that the search operates on

[astirpe]

@thomaspaulb the above three points are not necessary IMO. The search method must allow the search on both dotted and not-dotted records, so no need of migration scripts or extra computed fields.

[thomaspaulb]

Ah yes, my mind missed the option of searching for dotted as well as non-dotted. That should also do it.

[github-actions]

There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days.
If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.