Form Parameter Query Reset in Live Environment

(0) Share

Report

Posted on by Safeer PS

507

Dear All,

Recently I have developed a report and moved to Live. Later I edited the query range of report and again imported to Live. now this time I am getting output of report whenever I do reset of query. Please see below pic.

My question : Do I have to do reset in every users while implementing this report.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

RE: Form Parameter Query Reset in Live Environment

Reset button only applies changes to your user account, but in fact it does a change in the background in the SysLastValue table. So what you need to do is drop the entries in there belonging to your report objects for all users within Table Browser or SQL.

Was this reply helpful? Yes No
Safeer PS 507 on at

Like (0)

Report

RE: Form Parameter Query Reset in Live Environment

My question is how to delete Form Query cache of each and every user.

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

RE: Form Parameter Query Reset in Live Environment

I already answered that above. Drop them from SysLastValue.

Was this reply helpful? Yes No
Safeer PS 507 on at

Like (0)

Report

RE: Form Parameter Query Reset in Live Environment

How can I access SysLastValue atble and delete usage data of form query values from this table will delete only my user data. Will it delete all users data.

Was this reply helpful? Yes No
Verified answer

B K Sharma 737 on at

Like (0)

Report

RE: Form Parameter Query Reset in Live Environment

Got To AOT - System Documentation - explore it open Tables - search for SysLastValue,

Here you just right click and click to Add-ins and click to Table Browser. It will open the table data and delete all the data here.

Thanks

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
RE: Form Parameter Query Reset in Live Environment

Hi,

Either you can delete from UI (or) through a job.

Navigate to the path AOT > System Documentation > SysLastValue> select all and delete.

Job:

static void SysLastValue(Args _args) { SysLastValue sysLastValue; delete_from sysLastValue; }

Was this reply helpful? Yes No