I am creating a dataset to display information in a table. When i am done, i would like to clear or delete all rows in the dataset. what is the best way to do this? I can use system.dataset.deleteRow() but then i need to know how many rows are in the dataset and i can’t figure out how to get that e…

Do you really need to clear the dataset or can you just set the tables data property to a new empty dataset?

As Kevin suggests, it looks like the dataset clears itself (after populating the table.data) so there is no need to “clear” the dataset. Nonetheless, if you need the number of records in the dataset you can use the len function after converting to a PyDataSet: numOfRecords = len(system.dataset.toP…

Thanks, both are useful. I have another question regarding populating the table (dataset). I have a bunch of tags in various folders, the tags are simply numbered 1, 2, … 60, etc. Not all folders have all 60 tags. Currently i pass the folder path and then loop through the 60 possible tag names an…

how about using system.tag.readAll? save all of your folder names in a database table, then write a script that will generate all of the possible tagnames and put them into a string sequence. from there run something like this*** I reread your post and I cant tell if you wanted to just check the tag…

Thanks for the good suggestion, it does work better and i am going to use it but unfortunately still does work that well (still slow) only because not only do i need the tag value but i also need its .AlertDisplayPath. i need this information to describe the point to the user as the path really does…

[quote=“scott_rister”]Thanks for the good suggestion, it does work better and i am going to use it but unfortunately still does work that well (still slow) only because not only do i need the tag value but i also need its .AlertDisplayPath. i need this information to describe the point to the user a…

try something like this query = "select displayname, devicename FROM junk" if event.propertyName in ["devices", "refresh"]: newData = [] header = ["Displayname", "Devicename", "tag1", "tag2", "tag3", "tag4", "tag5"] res = system.db.runQuery(query) tagPaths = [] for row in res: …

I want to display a message when no data on table component, something like below but it’s not working, plz let me know how to mention for table if nodata if (LotId!="" or MatlAutoId!=None) and vtable==dataset[0x6]: self.props.emptyMessage.noData.text="No Data Found" self.props.emptyMessage.noD…

Great way and more readable. I just did this due how easily it was to implement. Thanks for your input! # clear table and wait 1 second, to show user things are happening self.getSibling("RandomTagTableName").props.data = "" time.sleep(1)

[image] jacque_trahan: time.sleep(1) This is the opposite of showing a user things are happening. Consider toggling the visibility of an icon, and/ or animating it with CSS so that the page conveys action instead of appearing to be frozen with data suddenly missing.

Inductive Automation Forum

Clearing a dataset?

Ignition

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled