Data-Table with auto-complete
This is just sharing knowledge around an interesting requirement.
One of our clients had a requirement of creating two data-tables mapped in to two different data classes along with two database table instances.
ABC-Ent-Data-CaseTypes (Table Name: PegaDataTypes [Columns- CASETYPE and DESCRIPTION])
ABC-Ent-Data-SubCaseTypes (Table Name: PegaDataSubTypes [Columns- CASETYPE, SUBCASETYPE, DESCRIPTION])
Client wanted to bring all the data in CASETYPE from ABC-Ent-Data-CaseTypes as an auto-complete under ABC-Ent-Data-SubCaseTypes CASETYPE. This prevents typo and re-entering same data to second table. Please note that; the requirement is bit bigger than how it explain in this post but just wanted to keep it simple for understanding purpose.
There could be many ways to do this; but the approach what we followed is very simple.
Set CASETYPE as the key under ABC-Ent-Data-CaseTypes class. Change UI Control of CASETYPE under
ABC-Ent-Data-SubCaseTypes to OpenRuleAdvancealong by setting up parameters as Class = ABC-Ent-Data-CaseTypes and ApplyTo = . CASETYPE.
This queries the data from PegaDataTypes instead of running it through a data-page or report-definition.