TACTIC Open Source
how to filter completion? - Printable Version

+- TACTIC Open Source (http://forum.southpawtech.com)
+-- Forum: TACTIC Open Source (http://forum.southpawtech.com/forumdisplay.php?fid=3)
+--- Forum: TACTIC Discussion (http://forum.southpawtech.com/forumdisplay.php?fid=4)
+--- Thread: how to filter completion? (/showthread.php?tid=100)



how to filter completion? - EricTsuei - 04-23-2020

I know completion is a wdg, and is there any ways to filter them on advance search? like completion is greater than 80%


RE: how to filter completion? - remkonoteboom - 04-26-2020

Because this is a dynamically calculated value done in python, you cannot search or order by it. It would have to calculate the value for this to be possible. For this to be efficient it would have to either be a column or an aggregate table (or more recently, we use have started to standardize a jsonb column called "data" on all stypes) that contains this kind of information. The values are calculated on a change trigger or some external script (run daily for example). At this point, it can be ordered or searched for.


RE: how to filter completion? - EricTsuei - 04-27-2020

ok, this method seems I am using right now, I use javascript to cal completion myself and update values to the asset column, but each time I want to sort or filter, I should run this js again.