Lets Make Learning AX Easy

Hi Everyone, I have been using sysquery for various purpose without knowing its exact use. Recently i had to write a lookup in a form but the lookup has to filter only those records with empty value for one particular field. For example, If we have four fields (F1, F2, F3 and F4) in the table Table. To create a basic lookup we have the following code: Query query = new Query(); SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(Table), this); sysTableLookup.addLookupField(fieldNum(Table, F1)); sysTableLookup.addLookupField(fieldNum(Table, F2)); qbds = query.addDataSource(tableNum(Table)); sysTableLookup.parmQuery(query); sysTableLookup.performFormLookup(); Assume there is requirement that i need to filter only those records whose value is empty. Let us take we need to filter only those records with empty value F3. Then below is lookup code for the same. Query query = new Query(); SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(Table), this); s...