Webpage auto update issue

[erpadmin_pspl]

i have a web page in www folder of my custom app in which i am showing list of document by fetching data from database which are submitted but when i cancel any document then also it showing in my web page why?? it is solved by bench clear-cache or bench migarte ?? why ??

1. i submitted the document:
   
   

2.it show in my custom webpage in www folder

3.i cancelled the document.

4. why cancelled is showing

5 .i run command in bench console

6. Now my code is working ?? why??

Repo Link → in which issue is coming → https://github.com/rehanansari26/File-Sharing/blob/main/file_sharing/www/drawing_list.html

As discussed in this post →
https://discuss.frappe.io/t/editing-webpages-not-reflecting-changes/34026/6

it is solved in Development Environment but when i push my app in Production then i am facing same issue ?? what to do in production mode ?

[NCP]

Hi @erpadmin_pspl,

add more filter after status:

doctatus: 1

I hope this helps.

Thank You!

[erpadmin_pspl]

but it is working when i run bench clear-cache in bench console in production?

[NCP]

use

bench build --force

Then check it.

[TurkerTunali]

You should add docstatus: 1 filter to your get_all() method like:

context.drawing_permissions = frappe.db.get_all('Drawing Permission',{'attached_to_name': context.supplier, 'docstatus': 1, 'status': 'Shared'}, pluck='name') or None

[erpadmin_pspl]

this also not working.
it will work when i do bench migrate or bench clear-cache

[erpadmin_pspl]

@TurkerTunali @NCP docstatus : 1 also not working in production mode.

[erpadmin_pspl]

Any other solutions, it happed when i cancelled the document then also it is showing in the webpage.

[ankush]

Did you try adding no_cache=1? Somewhere your results are probably cached.

[erpadmin_pspl]

sorry for posting it in github issue and thank you for it is working now.