I’m trying to lock a sortField by code without hidding it to the user in the selection screen.
Is it possible?
chooseLines.query().dataSourceTable(tablenum(SalesTable)).rangeField(fieldnum(SalesTable, giroType)).status(RangeStatus::LOCKED); //work
chooseLines.query().dataSourceTable(tablenum(SalesTable)).sortField( fieldNum(salestable, salesId)).status(SortStatus::LOCKED); ; //dont work
chooseLines.query().dataSourceTable(tablenum(SalesTable)).rangeField(fieldnum(SalesTable, giroType)).status(RangeStatus::LOCKED); //work
if its work then why to to post here …???
The range is working but not the sort.
Cannot be locked. What you exactly trying to do?
I’m sorting a query by code before the query selection popup up. The user is then able to see that sort.
I know I can clear sort and put the sort I want after, but I would prefer if the user could see the sort and not be able to change it.
I don’t see an option to stop it. We can make the AllowAdd property to No field , but this can even restrict the user from adding any ranges.