You could achieve this by configuring a custom screen when Lookup XML for the drop down field is correctly specified. Follow the below steps. For an example, I have taken ‘Task’ screen.
1. Go to UI Designer in Smart client & open ‘Task’ screen
Click on the dropdown field you wish to configure
On the top left corner of the screen, edit the lookup XML as per your need
Select the correct Primary table & click on Add Data Constraints.
Specify the column, constraint & value
Save the screen & ‘Refresh cache(full).
Assign the screen to a Role & then the Role to the person record
Relogin & see for the desired values to popup in the dropdown field
I had a similar requirement so i set up my custom screen. It seems that it works well in smart client but, in web client, my drop-down fields doesn’t take into account the data constraints..
Please see if you are looking for something like this. I just created an example with REQUEST entity. Which I am populating request statuses, based on request type.
Note that, this works only for web client. Since screen events are not working in smart client.
Client script Example - SAJGLK_DYNAMIC_STATUS_DROPDOWN
showProgressIndicator(); var reqType = getControlValue('request','req_type');
var emptyOptions = []; var options = createCodeTableOption('',''); arrayPush(emptyOptions, options); setControlOptions('request', 'req_status', emptyOptions);
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.