Display Referance Data

ajinkyab277

Certified Lead Developer

over 8 years ago

Hi,
I have below scenarion , I am looking for some design practices for it

I have Employee list in Employee CDT

--------------------------------------

Employee
----------
empId
firstName
lastName
designationId

Designation
---------------
designationId
designationDescription

I want to show employee empId,firstName,designationDescription in grid.
Whats are the best possible solution to show designationDescription in grid with minimum number of database calls.

Below are some solution approach i have in my list
1. Create view for Employee Details
Cons:
1. Need to create extra view and CDT
2. Pass designationId list and get designationDescirption
Cons:
Desgination desciption might not come in sorted order of desgination id for in operator

Discussion posts and replies are publicly visible

0 chetany
A Score Level 1
over 8 years ago

Also, CDTs do not map to existing DB views - you have to tell Appian to map to an existing View by annotating with @Table, and the DB View must already be created(and creating the DB view is tied to the DB vendor). If the CDT maps to an actual table directly, you need not worry about something like this.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel