Am I able to script the filtering functionality on a power table? I have a datasource (Sepasoft) that can’t be manipulated, and I would like to remove rows on condition. I can do this manually in runtime, but I’d like to be able to have the table load with this filter in place. Thanks

Knew I had this lying around somewhere: [image] Programmatically-applied PowerTable Filters Ignition model = self.getTable().getModel().getActualModel() from com.jidesoft.grid import SingleValueFilter class newFilter(SingleValueFilter): def isValueFiltered(self, …

Thanks Paul. However next question, and I know this is out of your ‘jurisdiction’… but say this wasn’t a power table, but was actually a Sepasoft model, specifically the PMIDowntimeTable class: do you know how I would apply the same thing to this? I can’t find the javadoc for their modules which is…

Well, the top-level class is a unique class that extends a basic ‘panel’ - that means the actual component you interact with is almost certainly composed of various underlying objects. If you’re lucky, one of those will be a Jidetable, and the code I linked will still work, you’ll just have to injec…

Genius! I’ll hold onto that function, very handy! Got it, there’s a power table embedded into the component :slight_smile: # add to Sepasoft OEE Downtime Table 'initialise' extension function: def setFilter(self, col, target): model = self.getTable().getModel().getActualModel() model.clearFilter…

I have and power table with a time data col, user col, and description col. I’m using EDGE and I need to filter the time column between choose dates previously! Anybody Can help me to do that, because I used the last script but it is not working

Script filtering on Power Table

Ignition

paul-griffith March 27, 2019, 11:59pm 2

Knew I had this lying around somewhere: