Finance | Project Operations, Human Resources, ...

Forcing query to use QUERY USED instead of PREVIOUSLY USED QUERY

(0) Share

Report

Posted on by Kauto

2,699

Hi,

This might be easy but asking for reference.

I am executing the QueryRun class to instantiate an instance of a query.

I am calling the QueryRun.Prompt() so the user can add additional range values etc.

I am also setting some ranges on the fly in the query object just before I execute queryRun.

My question is simply, how do I force the parameter in the SELECT QUERY to use QUERY USED instead of the cached usage data value PREVIOUSLY USED QUERY?

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Kauto 2,699 on at

Like (0)

Report

Ignore this - I have found that if I use SysQueryRun instead of QueryRun class I get the parameter promptLoadLastQueryUsed() and setting that to False will result in the QUERY USED parameter being set instead of a cached or saved from usage data.

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

Hi Kauto,

Although you have found the solution through SysQueryRun.

Try calling QueryRun.reset() method and check whether its help your scenario.

Thanks,

Girish S.

Was this reply helpful? Yes No