Hi all,
Is there any way to have the dropdown list filtered field.Like i have a form where i need have the field with dropdown for all the project category of only Items.Right now its appearing with all the list of categories like item,hour,feetransaction types…But in that i would like to display the list of items which has only items as transaction types and display the samePlease let me know where can i write the method for the same.
.
Hi Sindu.
You have to Write in ExecuteQuery Override Method in FormDatasource.ExecuteQuery…
public void executeQuery()
{
Query q=this.query();
QueryBuildDataSource qbds;
QueryBuildRange qbr;
;
qbds=q.dataSourceName(identifierstr(TableName));
if(qbds)
{
qbds.clearRange(fieldnum(TableName, FieldName));
qbr=qbds.addRange(fieldnum(TableName, FieldName));
if(qbr)
{
qbr.value(queryvalue(CategoryName::item));
}
}
super();
}
/////////////////////
Don’t Forget to Verify
Regards
Saadullah
Thanks a lot for the quick reply.I will try this below sample and will let you knw