Photo is pretty self explanatory. I am getting range fields in my dialog prompt that I do not wish to be there? Can anybody tell me why they are showing up?
*This post is locked for comments
Hi,
I prefer to clear all the ranges on the datasource ReqTrans and add the required ranges through code like below
QueryBuildDataSource qbdsReqTrans;
QueryBuildRange qbr;
qbdsReqTrans = this.Query().dataSourceTable(tableNum(ReqTrans));
qbdsReqTrans.clearRanges();
qbr = SysQuery::findOrCreateRange(qbdsReqTrans, fieldNum(ReqTrans, Plan*));
Resetting the usage data and clearing the cache did not work. I tried manually hiding the range in the AOT for the specific field that was being displayed. That worked, but then two other random fields are added as ranges. ???
BEFORE - dialog
CHANGE made
AFTER - dialog
Hi,
Please clear the usage data and refresh the cache to check if this range gets cleared. If you are not sure, from where the extra range is getting added probably you can remove range using the below code:
this.Query().dataSourceTable(tableNum(ReqTrans)).clearRange(fieldNum(ReqTrans, Plan*));
No, all of the query was done in the AOT. there is a small select statement in the fetch, but nothing that deals with the query itself. Thanks, Tim
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156