filter List in CFL

ivin

hi experts,
i have a UDF column, i want to add a CLF into it. but the list is depend on the value of other column. how can i do it ?
Thanks for the answer

Sebastian Schweer

Hi Ivin,

 

can't you create a dynamic Select?

 

Something like: "Select CardCode, CardName From OCRD WHERE Date = " + DateColumn.Value + " AND Country = " + CountryColumn.Value

 

But, for this solution, you still have to make the CLF Field by Code and not by the wizard.

 

TextEdit textEditCFL = TextEdit.CreateNew("TextEditCF");

new SwissAddonFramework.UI.Dialogs.ChooseFromList(new SwissAddonFramework.UI.Dialogs.ChooseFromList.SQLQuery("SELECT CardCode, CardName FROM OCRD"), "CardCode", true, false, textEditCFL); 

 

Best Regards,

 

Sebastian