Good day people
I am struggling to get this right. I need to filter the query to exclude the two values in the datasource when viewing the form, but I'm getting the following errors.
Code:
[ExtensionOf(formDataSourceStr(FormControlFieldSelector, FormControlFieldSelector))]
final class FormControlFieldSelector_Extension
{
public void init()
{
next init();
QueryBuildDataSource qbds;
qbds = this.query().dataSourceName(tableStr(FormControlFieldSelector));
qbds.name('FormControlFieldSelector');
qbds.addRange(fieldnum(FormControlFieldSelector, Field)).value(strFmt('((%1.%2 != %3) && (%1.%2 != %4))',
qbds.name(),
fieldStr(FormControlFieldSelector, Field),
queryValue('Basic'),
queryValue('Cost')
));
}
}
Results:

I appreciate your help.