import {DbQuery} from '@dms'
import {Customer} from '@dms-bo'
const query = Customer.liveLinkQuery();
query.filter("Id=1123'");
query.filter("Revenue > 6000");
//more complex filter with parentess
query.filter("((Revenue > 6000 or Revenue=0) and (City='Sofia'))");
const result = await query.executeSelect();
//method chaining - e.g. calling several method on a single line
const result2 = await query.fields(['Id','Name','City','Revenue']).filter("City='Dubai'and Revenue>1234").executeSelect();