Execute query rule in dropdown from UI values

Question

Hello, 
 I am trying to populate a dropdown by executing a query rule that is based on a CDT. I would need UI values to be passed as parameters to the query rule and populate dropdown dynamically when the user input value changes. Issue is the value does not change when passed to query rule as a parameter and seems to take the original value only. 
 Below is the code that I got so far: 
 a!textField( label: "Mfg Org", labelPosition: "ADJACENT", value: ri!expediteline.item_mfg_org_code, saveInto: { a!save( local!mfgShipMethods,rule!EXP_GetMfgShipMethodsByOrg(local!itemMfgOrgCode,if(isnull(ri!expediteline.mfg_source_org_code_2), if(ri!expediteline.mfg_source_org_code=local!itemMfgOrgCode,ri!expediteline.ship_from,ri!expediteline.mfg_source_org_code),ri!expediteline.mfg_source_org_code_2)) ), a!save(local!itemMfgOrgCode,ri!expediteline.item_mfg_org_code) }, refreshAfter: "UNFOCUS", required: true, readonly: false, validations: {} ) 
 Here I am trying to save the text field value from UI into a local variable and pass as parameter to the query rule. 
 Thanks

Abhay Giri · Accepted Answer

Hi, 
 
It is best example of usage of load and with function . You can also try the below way , instead of query rule i created a rule which simply contains array.

getName rule have below : 
 
load( 
 
local!data:{{id:"1",Name:"Abc1"}, 
{id:"1",Name:"Abc2"}, 
{id:"2",Name:"Abc3"}, 
{id:"2",Name:"Abc4"}, 
{id:"3",Name:"Abc5"}, 
{id:"4",Name:"Abc6"}, 
{id:"4",Name:"Abc7"}},

index(index(local!data,"Name",null),wherecontains(ri!id,touniformstring(index(local!data,"id",null)))) 
 
 ) 
And interface will have this code : 
 
load 
( 
local!Name:null,

{ 
 
 a!textField( 
 label:"Endter Id", 
 value:ri!id, 
 saveInto: 
 { 
 ri!id, 
 
 a!save(local!Name,rule!findingNotNullAttributes(id: ri!id))

} 
 
 ), 
 
 a!dropdownField( 
 label:"Name", 
 placeholderLabel: "--select--", 
 choiceLabels: local!Name, 
 choiceValues: local!Name 
 ) 
 
}

) 
So now in your case instead of getName, call your rule and pass the value.