Random range fields in dialog prompt

(0) Share

Report

Posted on by cowboyott

204

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

I have the same question (0)

All responses (4)

Answers (0)

cowboyott 204 on at

Like (1)

Report

RE: Random range fields in dialog prompt

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

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report

RE: Random range fields in dialog prompt

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*));

Was this reply helpful? Yes No
cowboyott 204 on at

Like (0)

Report

RE: Random range fields in dialog prompt

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

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (1)

Report

RE: Random range fields in dialog prompt

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*));

Was this reply helpful? Yes No