Hello,
Thanks for the reply. I'm familiar with the <view-entity> as well as the DynamicViewEntity class.
What I wanted to accomplish is to aggregate the person's firstName, middleName, lastName into one field so that I can use a single search filter to filter in or out the appropriate entries of a resulting join operation.
I was thinking of creating a temporary table to store these aggregated strings and then use the temporary table to join with other tables accordingly. This way, I can let the database do all the work of filtering and let the screen widget do the paging as usual.
Otherwise, I would have to perform a join with entities Party, Person. Then read all the entries and concatenate by code, the firstName, middleName, lastName and then store the aggregated name into an unused GenericValue field (eg. firstName or something else), then perform the filtering in my code and then let the screen widget output the listing.
I could use ...
<view-entity>
<alias name="fullPersonName">
<complex-alias operator="||">
<complex-alias-field entity-alias="PERSON" field="firstName"/>
<complex-alias-field entity-alias="PERSON" field="middleName"/>
...
But the above would be database server specific. Hence, I would like to avoid it.
What I want to do seems very common and I would like to know if anyone has already accomplished this and give some insight.
Thanks in advance,
Wai
Locked
