# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1638 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1639 --- ## [Date Time and SQL](https://forum.inductiveautomation.com/t/date-time-and-sql/3858)
**Author:** [@WildeKurt](https://forum.inductiveautomation.com/u/WildeKurt)\ **Replies:** 1\ **Last updated:** [January 13, 2012, 10:26pm UTC](https://forum.inductiveautomation.com/t/date-time-and-sql/3858 "2012-01-13T22:26:30Z")
I've defined the following script: def logEventGlobal (msg): import system # Logs an event to the LogGlobal database... from java.util import Date currentDate = Date() curDateStr = system.db.dateFormat(currentDat… --- ## [Find/Replace](https://forum.inductiveautomation.com/t/find-replace/3849)
**Author:** [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\ **Replies:** 1\ **Last updated:** [January 13, 2012, 7:38pm UTC](https://forum.inductiveautomation.com/t/find-replace/3849 "2012-01-13T19:38:25Z")
Was searching for binding to a Dynamic Property when this popped up "UncaughtNullPointerException" Ignition v7.3.3 (b570) --- ## [Tag Bindings/Expressions in alarm description strings](https://forum.inductiveautomation.com/t/tag-bindings-expressions-in-alarm-description-strings/3845)
**Author:** [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Replies:** 1\ **Last updated:** [January 13, 2012, 7:36pm UTC](https://forum.inductiveautomation.com/t/tag-bindings-expressions-in-alarm-description-strings/3845 "2012-01-13T19:36:28Z")
This already exists in the form of the Alert Message Subject in the Notification Settings for alarms, but we'd like to see the same functionality for the 'Alert Name' or display string. If anything about alarms is to cha… --- ## [Set Window to Always Updating](https://forum.inductiveautomation.com/t/set-window-to-always-updating/3856)
**Author:** [@Nate.Olson](https://forum.inductiveautomation.com/u/Nate.Olson)\ **Replies:** 4\ **Last updated:** [January 13, 2012, 7:01pm UTC](https://forum.inductiveautomation.com/t/set-window-to-always-updating/3856 "2012-01-13T19:01:19Z")
Is there a way to set a window to always updating? I have a table that is populating based on client event scripts, but if that window isn't in the foreground the tables won't update. --- ## [Project Required Roles](https://forum.inductiveautomation.com/t/project-required-roles/3848)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 6\ **Last updated:** [January 12, 2012, 5:38pm UTC](https://forum.inductiveautomation.com/t/project-required-roles/3848 "2012-01-12T17:38:45Z")
Why does the project property required roles require the user to have all the roles specified? for instance I have a role called "managers" and i have a role called "supervisors. when i set a project to require roles "… --- ## [Set Communication to all PLC to read only](https://forum.inductiveautomation.com/t/set-communication-to-all-plc-to-read-only/3837)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 6\ **Last updated:** [January 11, 2012, 9:30pm UTC](https://forum.inductiveautomation.com/t/set-communication-to-all-plc-to-read-only/3837 "2012-01-11T21:30:23Z")
What would the steps be to configure the gateway to only read devices and not write? I think it has to be done with security authentication, roles and OPC-UA settings, but it is not very clear in the manual. I curren… --- ## [Indirect dataset](https://forum.inductiveautomation.com/t/indirect-dataset/3838)
**Author:** [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\ **Replies:** 2\ **Last updated:** [January 11, 2012, 2:43am UTC](https://forum.inductiveautomation.com/t/indirect-dataset/3838 "2012-01-11T02:43:49Z")
Is it possible to use a dataset as an indirect tag using the row and column? We have many facilities so instead of passing parameters from one container to another, it would be nice to config all of the facilities in on… --- ## [Local serial port access camera control](https://forum.inductiveautomation.com/t/local-serial-port-access-camera-control/3730)
**Author:** [@shawn\_75](https://forum.inductiveautomation.com/u/shawn_75)\ **Replies:** 3\ **Last updated:** [January 11, 2012, 1:52am UTC](https://forum.inductiveautomation.com/t/local-serial-port-access-camera-control/3730 "2012-01-11T01:52:34Z")
I'd like to be able to control a Pelco pan/tilt base while using the IP camera viewer. The Pelco D protocol is very straightforward and openly available. I simply need to send hex messages out the serial port. The D p… --- ## [Confirm Binding](https://forum.inductiveautomation.com/t/confirm-binding/3842)
**Author:** [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\ **Replies:** 1\ **Last updated:** [January 11, 2012, 1:34am UTC](https://forum.inductiveautomation.com/t/confirm-binding/3842 "2012-01-11T01:34:53Z")
Deleted a few dynamic property tags that was bound to components. A Confirm window popped up asking if it's ok to sever the bindings. The problem is that the window is way too big and I can't press the OK button. Did … --- ## [Adding row full of None values to table](https://forum.inductiveautomation.com/t/adding-row-full-of-none-values-to-table/3843)
**Author:** [@porksmash](https://forum.inductiveautomation.com/u/porksmash)\ **Replies:** 1\ **Last updated:** [January 11, 2012, 12:06am UTC](https://forum.inductiveautomation.com/t/adding-row-full-of-none-values-to-table/3843 "2012-01-11T00:06:10Z")
Edit: Nevermind, fixed, sorry! I have a table and a button. The button adds a row to the table when pressed. If the table has a row selected, it makes a copy of that row and inserts the copy below the selected one. If … --- ## [Horizontal Slider on table component?](https://forum.inductiveautomation.com/t/horizontal-slider-on-table-component/3839)
**Author:** [@scott\_rister](https://forum.inductiveautomation.com/u/scott_rister)\ **Replies:** 1\ **Last updated:** [January 10, 2012, 9:06pm UTC](https://forum.inductiveautomation.com/t/horizontal-slider-on-table-component/3839 "2012-01-10T21:06:40Z")
I have a table with more columns than i have room to display without the use of a slider. Is there a way to configure it to use a horizontal slider? I cant seem to find one. Thanks, Scott --- ## [Easy Chart Pens](https://forum.inductiveautomation.com/t/easy-chart-pens/3836)
**Author:** [@peadair](https://forum.inductiveautomation.com/u/peadair)\ **Replies:** 2\ **Last updated:** [January 10, 2012, 4:06pm UTC](https://forum.inductiveautomation.com/t/easy-chart-pens/3836 "2012-01-10T16:06:17Z")
Hi, If i set a pen on my easy chart to min/max on the Table/Mode and then export that data in excel format for a months values i get 2 values for each hour, and if i set it to average i get just one value per hour. I … --- ## [Alarm Path Filters](https://forum.inductiveautomation.com/t/alarm-path-filters/3833)
**Author:** [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Replies:** 2\ **Last updated:** [January 9, 2012, 4:59pm UTC](https://forum.inductiveautomation.com/t/alarm-path-filters/3833 "2012-01-09T16:59:26Z")
Is there a way to have multiple path filters on the Alarm Summary component? I would like to display two groups of alarms on one alarm summary. --- ## [Accessing Server Clock](https://forum.inductiveautomation.com/t/accessing-server-clock/3830)
**Author:** [@davisr19](https://forum.inductiveautomation.com/u/davisr19)\ **Replies:** 2\ **Last updated:** [January 6, 2012, 9:57pm UTC](https://forum.inductiveautomation.com/t/accessing-server-clock/3830 "2012-01-06T21:57:35Z")
What is the best way to access the server's clock time from an expression? I am currently using the now() function but it gets its time from the client PC clock. --- ## [Transaction Group missing Data](https://forum.inductiveautomation.com/t/transaction-group-missing-data/3671)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 14\ **Last updated:** [January 6, 2012, 5:22pm UTC](https://forum.inductiveautomation.com/t/transaction-group-missing-data/3671 "2012-01-06T17:22:44Z")
Last night we changed one of our transaction groups from a 60 second poll rate to a 1 second poll rate. When we came in today to look at the data we saw missing sections of data. The data seems to be some what consiste… --- ## [Issues when Changing Database](https://forum.inductiveautomation.com/t/issues-when-changing-database/3824)
**Author:** [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\ **Replies:** 3\ **Last updated:** [January 5, 2012, 7:01pm UTC](https://forum.inductiveautomation.com/t/issues-when-changing-database/3824 "2012-01-05T19:01:36Z")
Changed the database from Express to mssql only to discover that the sql history tags, that were previously enable to store history, got disabled. Dumped the csv and found the "History Enable" set to false and no "Prima… --- ## [Hanging SQL Queries](https://forum.inductiveautomation.com/t/hanging-sql-queries/3766)
**Author:** [@jmartell](https://forum.inductiveautomation.com/u/jmartell)\ **Replies:** 3\ **Last updated:** [January 5, 2012, 6:18pm UTC](https://forum.inductiveautomation.com/t/hanging-sql-queries/3766 "2012-01-05T18:18:50Z")
I have an application running version 7.2.8. We have a redundant setup of ignition servers and a separate MS SQL Server for history data. Every couple of weeks we have to restart the Ignition service because we accumul… --- ## [Dropdown mouseClicked event](https://forum.inductiveautomation.com/t/dropdown-mouseclicked-event/3823)
**Author:** [@porksmash](https://forum.inductiveautomation.com/u/porksmash)\ **Replies:** 3\ **Last updated:** [January 5, 2012, 6:01pm UTC](https://forum.inductiveautomation.com/t/dropdown-mouseclicked-event/3823 "2012-01-05T18:01:17Z")
I'm trying to use a mouseClicked event on a Dropdown List to run a script, which in turn queries a db table and returns a data set for the dropdown to display. My problem is that the mouseClicked even't doesn't fire if t… --- ## [Scripting Function to Retrieve List of SQLTags](https://forum.inductiveautomation.com/t/scripting-function-to-retrieve-list-of-sqltags/3534)
**Author:** [@dep05d](https://forum.inductiveautomation.com/u/dep05d)\ **Replies:** 2\ **Last updated:** [January 5, 2012, 11:35am UTC](https://forum.inductiveautomation.com/t/scripting-function-to-retrieve-list-of-sqltags/3534 "2012-01-05T11:35:41Z")
I'd like to request a new scripting function that would return a list of tags from the gateway into a dataset. I imagine the dataset would look like a subset of columns from the csv export file. I store a lot of lists i… --- ## [How to get rid of "old" deleted tag records in sqlth\_te](https://forum.inductiveautomation.com/t/how-to-get-rid-of-old-deleted-tag-records-in-sqlth-te/3784)
**Author:** [@vahterto](https://forum.inductiveautomation.com/u/vahterto)\ **Replies:** 4\ **Last updated:** [January 4, 2012, 6:38pm UTC](https://forum.inductiveautomation.com/t/how-to-get-rid-of-old-deleted-tag-records-in-sqlth-te/3784 "2012-01-04T18:38:49Z")
Hi When making sets of tags and using copy/paste method if tag contains history enable Ignition will make records ind sqlth\_te table as expected but if deleting those tags all recors remain. I can understand that this … --- ## [Large blob insert into database reboots Gateway](https://forum.inductiveautomation.com/t/large-blob-insert-into-database-reboots-gateway/3811)
**Author:** [@cgz](https://forum.inductiveautomation.com/u/cgz)\ **Replies:** 2\ **Last updated:** [January 4, 2012, 5:08pm UTC](https://forum.inductiveautomation.com/t/large-blob-insert-into-database-reboots-gateway/3811 "2012-01-04T17:08:02Z")
Hello, In our case, roughly like 10-15MB file (which probably translates to 20-30MB actual encoded data), when put to database from a client using SQL INSERT, will cause Gateway to reboot. system.db.startTransaction(… --- ## [Datasource on edit pens for click to graph](https://forum.inductiveautomation.com/t/datasource-on-edit-pens-for-click-to-graph/3819)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [January 4, 2012, 1:08am UTC](https://forum.inductiveautomation.com/t/datasource-on-edit-pens-for-click-to-graph/3819 "2012-01-04T01:08:09Z")
what should the correct line of code be in ignition? address = fpmi.system.getGatewayAddress() source = fpmi.net.httpGet("http://%s/gateway/Gateway?tab=datasources" % address) --- ## [Script Ordering](https://forum.inductiveautomation.com/t/script-ordering/3814)
**Author:** [@PeteV](https://forum.inductiveautomation.com/u/PeteV)\ **Replies:** 0\ **Last updated:** [December 30, 2011, 2:11pm UTC](https://forum.inductiveautomation.com/t/script-ordering/3814 "2011-12-30T14:11:08Z")
It would be nice if you could reorder the scripts as they appear in the list or if they automatically sorted alphabetically. That way I could group my scripts logically so it would be easier to find the script I'm looki… --- ## [Comments within expressions](https://forum.inductiveautomation.com/t/comments-within-expressions/3813)
**Author:** [@cgz](https://forum.inductiveautomation.com/u/cgz)\ **Replies:** 1\ **Last updated:** [December 29, 2011, 3:18pm UTC](https://forum.inductiveautomation.com/t/comments-within-expressions/3813 "2011-12-29T15:18:32Z")
Is this possible already or anytime soon available? I've noticed that, for various reasons, the expressions I've come across were not always self-explanatory, so being able to throw in a comment, spot on, would be nice… --- ## [7.2.1 (b6516) : Mobile Module Connection reset](https://forum.inductiveautomation.com/t/7-2-1-b6516-mobile-module-connection-reset/2600)
**Author:** [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\ **Replies:** 16\ **Last updated:** [December 28, 2011, 4:50pm UTC](https://forum.inductiveautomation.com/t/7-2-1-b6516-mobile-module-connection-reset/2600 "2011-12-28T16:50:25Z")
Hi, I’m unable to launch a mobile project from my mobile. Running from a regular client is ok, but not with iPhone or Android nor iPad. Below is the sequence : VMCreator starting 1 new client VMs. Client vm 90285409… --- ## [Easy Chart Export Data](https://forum.inductiveautomation.com/t/easy-chart-export-data/3808)
**Author:** [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\ **Replies:** 2\ **Last updated:** [December 27, 2011, 5:42pm UTC](https://forum.inductiveautomation.com/t/easy-chart-export-data/3808 "2011-12-27T17:42:44Z")
Exported data has no time stamp, only year and day for all data points. i.e. 2011-12-24 0:00 Also, had to rename the xls to xlsx to open in Oo. Just passing time waiting for Santa. --- ## [After Gateway restart Alert message goes back to default](https://forum.inductiveautomation.com/t/after-gateway-restart-alert-message-goes-back-to-default/3752)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 5\ **Last updated:** [December 23, 2011, 6:57pm UTC](https://forum.inductiveautomation.com/t/after-gateway-restart-alert-message-goes-back-to-default/3752 "2011-12-23T18:57:27Z")
I have an alert that goes off every 4 hours with this expression: if(ExtractHour(now())%4=0&&ExtractMinute(now())=0,1,0) I have the notification settings to use a custom alert message with a subject of CO2 Tank Level i… --- ## [Batch Edit of Component Security Parameters](https://forum.inductiveautomation.com/t/batch-edit-of-component-security-parameters/3231)
**Author:** [@AlexW](https://forum.inductiveautomation.com/u/AlexW)\ **Replies:** 5\ **Last updated:** [December 23, 2011, 6:45pm UTC](https://forum.inductiveautomation.com/t/batch-edit-of-component-security-parameters/3231 "2011-12-23T18:45:19Z")
If I am designing and wish to edit the security settings of a bunch of selected controls, I can only do this individually. Feature request is to allow editing component security if I have ctrl+clicked on more than one … --- ## [Simulator tags](https://forum.inductiveautomation.com/t/simulator-tags/2173)
**Author:** [@NorthPoint](https://forum.inductiveautomation.com/u/NorthPoint)\ **Replies:** 4\ **Last updated:** [December 23, 2011, 6:29pm UTC](https://forum.inductiveautomation.com/t/simulator-tags/2173 "2011-12-23T18:29:25Z")
Does anyone have a list of the items provided by the Simulator device, what range they work in, etc? --- ## [Alert logs](https://forum.inductiveautomation.com/t/alert-logs/3803)
**Author:** [@scott\_rister](https://forum.inductiveautomation.com/u/scott_rister)\ **Replies:** 4\ **Last updated:** [December 23, 2011, 5:40pm UTC](https://forum.inductiveautomation.com/t/alert-logs/3803 "2011-12-23T17:40:35Z")
I'm having difficulty working with an alert database table. i cant get the table to create automatically so i have created manually. most things appear to be working but i can not get the column Alert\_Log\_Id to populate.… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1637) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1639)