SPEL: Dynamic filling of related fields in edit mode

Document created by cdtj Champion on May 4, 2017Last modified by cdtj Champion on May 10, 2017
Version 3Show Document
  • View in full screen mode


This customization is presented as is and was not tested well. Use it at your own risk.

Please remember! Any kind of SPEL customization can cause performance/stability issue which is not responded by CA Support: https://communities.ca.com/docs/DOC-231156196#comment-233917142 


Demonstration video


What is this

This method is seeking for lookup and hier fields, then determine all related fields. Once parent field being changed, script performing ajax query to fetch all related values (exception: nr associated fields).


Installation steps

1. Register new WebEngine OP (more info about Webengine OPs: SPEL: Register custom webengine OP)

- Open $NX_ROOT\site\mods\www\op_custom.cfg;

- Add followed string to end (before footer message) of the config file:


- Save file;

- Copy z_backfill.spl as: $NX_ROOT\site\mods\www\z_backfill.spl;

- Recycle WebEngine to apply changes.


2. Register HTMPL file

- Copy z_backfill.htmpl as $NX_ROOT\site\mods\www\htmpl\web\analyst\z_backfill.htmpl;

- Add followed line to enable backfilling on selected form (such as detail_cr.htmpl, detail_iss.htmpl, etc):

<PDM_INCLUDE FILE=z_backfill.htmpl>

Line should be inserted between <head></head> and <script></script> HTML tags;

- Reset Webcache;




   - jQuery alias fixed;

5 people found this helpful