Think APEX

Introduction The search box in an Interactive Grid (IG) or Interactive Report (IR) accepts any character by default. In some applications, business rules require end users to enter only letters ( a-z , A-Z ) and numbers ( 0-9 ) when using the All Text Columns search option. Special characters such as @ , # , % or ' should not be allowed. Oracle APEX does not provide a declarative setting — such as an input mask or pattern — for the built-in search field. In this post, we implement the restriction with a small, reusable JavaScript file that applies to every Interactive Grid and Interactive Report in the application automatically. Requirement The search field must accept only a-z , A-Z and 0-9 (spaces allowed, optional). The restriction must work for typing , pasting and drag-and-drop . It must apply to all pages automatically , with no per-page setup. It must cover both Interactive Grid and I...