# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1270 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1271 --- ## [How to have fixed axes on a bar chart in a report](https://forum.inductiveautomation.com/t/how-to-have-fixed-axes-on-a-bar-chart-in-a-report/27207)
**Author:** [@marianjel\_11](https://forum.inductiveautomation.com/u/marianjel_11)\ **Replies:** 1\ **Last updated:** [August 6, 2019, 8:53pm UTC](https://forum.inductiveautomation.com/t/how-to-have-fixed-axes-on-a-bar-chart-in-a-report/27207 "2019-08-06T20:53:49Z")
I have a pareto graph in which I need the ‘y’ axis to be fixed at 24 and I don’t know how to do the script --- ## [PDF Viewer & Event Handlers](https://forum.inductiveautomation.com/t/pdf-viewer-event-handlers/26795)
**Author:** [@FLi](https://forum.inductiveautomation.com/u/FLi)\ **Replies:** 7\ **Last updated:** [August 6, 2019, 8:05pm UTC](https://forum.inductiveautomation.com/t/pdf-viewer-event-handlers/26795 "2019-08-06T20:05:30Z")
Hello everyone, I want to retrieve the active PDF page of the PDF Viewer component. I’ve already done this inside a script of a button: target = event.source.parent.getComponent('PDF Viewer') swingController = target.g… --- ## [Modbus TCP and SQLTag String](https://forum.inductiveautomation.com/t/modbus-tcp-and-sqltag-string/7485)
**Author:** [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\ **Replies:** 3\ **Last updated:** [August 6, 2019, 7:20pm UTC](https://forum.inductiveautomation.com/t/modbus-tcp-and-sqltag-string/7485 "2019-08-06T19:20:39Z")
Hi, A SQLTag, string type, 20 char. long, ex. HRS1:20. When you write it, let say '1234', so less than the 20 maxi. char, the empty char are replaced by space (x20), not null (x00), causing some difficulties to my plc. … --- ## [Backfeeding Data into a central Ignition gateway](https://forum.inductiveautomation.com/t/backfeeding-data-into-a-central-ignition-gateway/27202)
**Author:** [@Harikrishna\_Patadiya](https://forum.inductiveautomation.com/u/Harikrishna_Patadiya)\ **Replies:** 0\ **Last updated:** [August 6, 2019, 5:01pm UTC](https://forum.inductiveautomation.com/t/backfeeding-data-into-a-central-ignition-gateway/27202 "2019-08-06T17:01:28Z")
Hi, Here’s an interesting thought. The remote site has data from the past 2 years. We’re trying to spin up a central gateway (hosted on AWS or elsewhere) which will connect to the site gateway through the “Gateway Netw… --- ## [Remove orange rectangle focus on slider component](https://forum.inductiveautomation.com/t/remove-orange-rectangle-focus-on-slider-component/27183)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 1\ **Last updated:** [August 6, 2019, 2:09pm UTC](https://forum.inductiveautomation.com/t/remove-orange-rectangle-focus-on-slider-component/27183 "2019-08-06T14:09:54Z")
Hi How can I remove the orange rectangle focus on slider component permanently? --- ## [Using variables in a SQL WHERE IN() operator (scripting)](https://forum.inductiveautomation.com/t/using-variables-in-a-sql-where-in-operator-scripting/27130)
**Author:** [@hachjessed](https://forum.inductiveautomation.com/u/hachjessed)\ **Replies:** 9\ **Last updated:** [August 6, 2019, 11:49am UTC](https://forum.inductiveautomation.com/t/using-variables-in-a-sql-where-in-operator-scripting/27130 "2019-08-06T11:49:43Z")
I am trying to use a variable in a SQL SELECT query with an IN() operator in the WHERE clause. This is written in scripting on an action performed event handler of a button component. I am able to make this work with o… --- ## [Reseting table data](https://forum.inductiveautomation.com/t/reseting-table-data/17368)
**Author:** [@carolineuchoa.estuda](https://forum.inductiveautomation.com/u/carolineuchoa.estuda)\ **Replies:** 16\ **Last updated:** [August 6, 2019, 11:26am UTC](https://forum.inductiveautomation.com/t/reseting-table-data/17368 "2019-08-06T11:26:28Z")
Hello! Is it possible to create a button to reset the table data that is recorded until that moment, and start picking up new data from the time I press the button? In other words, I have a table recording 1 hour of re… --- ## [Partial Pixels Ignition 8.02](https://forum.inductiveautomation.com/t/partial-pixels-ignition-8-02/27163)
**Author:** [@kwingert](https://forum.inductiveautomation.com/u/kwingert)\ **Replies:** 7\ **Last updated:** [August 5, 2019, 8:29pm UTC](https://forum.inductiveautomation.com/t/partial-pixels-ignition-8-02/27163 "2019-08-05T20:29:10Z")
Is there a way to prevent objects height and width from having decimal places? I’m developing the project at the maximum resolution and I’m finding that the decimal places make it difficult to align objects correctly. T… --- ## [Alarm Page Navigation using Vision's Tab Nav](https://forum.inductiveautomation.com/t/alarm-page-navigation-using-visions-tab-nav/27162)
**Author:** [@ryanastiefes](https://forum.inductiveautomation.com/u/ryanastiefes)\ **Replies:** 2\ **Last updated:** [August 5, 2019, 9:05pm UTC](https://forum.inductiveautomation.com/t/alarm-page-navigation-using-visions-tab-nav/27162 "2019-08-05T21:05:36Z")
Ignition 7.8.5 I’m using the Project Templates “Vision Tab Nav” on a project and would like to interface components with the pressing of the Alarm Button in the top right corner but I cant figure out where the south do… --- ## [Ephemeral port exhaustion with 8.0.3 and 8.0.4](https://forum.inductiveautomation.com/t/ephemeral-port-exhaustion-with-8-0-3-and-8-0-4/27109)
**Author:** [@waldner](https://forum.inductiveautomation.com/u/waldner)\ **Replies:** 3\ **Last updated:** [August 5, 2019, 7:49pm UTC](https://forum.inductiveautomation.com/t/ephemeral-port-exhaustion-with-8-0-3-and-8-0-4/27109 "2019-08-05T19:49:09Z")
Happens with 8.0.3 rc2 and 8.0.4 nightly, OS is windows server 2016, both with designer and the vision client launcher. See the attached video for an example of what happens. Looking at netstat -a shows thousands of conn… --- ## [Prespective: Add values to dropdown from tag (Query based)](https://forum.inductiveautomation.com/t/prespective-add-values-to-dropdown-from-tag-query-based/27172)
**Author:** [@David.Bell](https://forum.inductiveautomation.com/u/David.Bell)\ **Replies:** 5\ **Last updated:** [August 5, 2019, 6:41pm UTC](https://forum.inductiveautomation.com/t/prespective-add-values-to-dropdown-from-tag-query-based/27172 "2019-08-05T18:41:03Z")
Hello, I cannot find any information on how to add values to a dropdown in Perspective using the tag (Query). This would be very helpful. I do not want to write a named query or manually add items. Thanks, David --- ## [Print out screens for use in manual](https://forum.inductiveautomation.com/t/print-out-screens-for-use-in-manual/27141)
**Author:** [@Marisa](https://forum.inductiveautomation.com/u/Marisa)\ **Replies:** 7\ **Last updated:** [August 5, 2019, 5:42pm UTC](https://forum.inductiveautomation.com/t/print-out-screens-for-use-in-manual/27141 "2019-08-05T17:42:38Z")
Is there any easy way to print out all the screens within a project? Also my customer has asked for this while the machine is in a container on the Pacific Ocean somewhere, so is there a way to print the screens out whil… --- ## [Client event script (keystroke) doesn´t run on screen2 (multiple monitors)](https://forum.inductiveautomation.com/t/client-event-script-keystroke-doesn-t-run-on-screen2-multiple-monitors/16733)
**Author:** [@lmis](https://forum.inductiveautomation.com/u/lmis)\ **Replies:** 4\ **Last updated:** [August 5, 2019, 5:02pm UTC](https://forum.inductiveautomation.com/t/client-event-script-keystroke-doesn-t-run-on-screen2-multiple-monitors/16733 "2019-08-05T17:02:45Z")
Hi, I have a project running on dual monitors. (open with system.gui.openDesktop(..) In my project I have a Client Event script, Keystroke Script. (that´s muting my Alarm Sound) Everything works fine when the prim… --- ## [Adding an option to sequel results](https://forum.inductiveautomation.com/t/adding-an-option-to-sequel-results/27169)
**Author:** [@ammermanbrittanyf](https://forum.inductiveautomation.com/u/ammermanbrittanyf)\ **Replies:** 2\ **Last updated:** [August 5, 2019, 3:46pm UTC](https://forum.inductiveautomation.com/t/adding-an-option-to-sequel-results/27169 "2019-08-05T15:46:11Z")
I am currently using this SQL Query to populate a drop down in ignition. SELECT DISTINCT VLAN FROM FA\_ECA\_MASTER ORDER BY VLAN ASC I was wondering if it was possible to add another row to the results. I have a few opti… --- ## [Auto-rotate through windows](https://forum.inductiveautomation.com/t/auto-rotate-through-windows/7388)
**Author:** [@dfarnes](https://forum.inductiveautomation.com/u/dfarnes)\ **Replies:** 8\ **Last updated:** [August 5, 2019, 3:24pm UTC](https://forum.inductiveautomation.com/t/auto-rotate-through-windows/7388 "2019-08-05T15:24:41Z")
Greetings All, I'm working on an existing project that will auto-rotate through several screens on a big screen TV. Below is the existing script, however it throws an "uncaught exception" error. I would appreciate any he… --- ## [Ignition Pie Chart](https://forum.inductiveautomation.com/t/ignition-pie-chart/27157)
**Author:** [@ammermanbrittanyf](https://forum.inductiveautomation.com/u/ammermanbrittanyf)\ **Replies:** 3\ **Last updated:** [August 5, 2019, 1:07pm UTC](https://forum.inductiveautomation.com/t/ignition-pie-chart/27157 "2019-08-05T13:07:55Z")
Hello. I am looking to use a pie chart for a visual analysis, however, I can't figure out how to get it to run. I was hoping to run a simply query like below: SELECT COUNT(VLAN) FROM FA\_ECA\_MASTER or SELECT VLAN FR… --- ## [Crash report on Ignition Edge on Moxa device](https://forum.inductiveautomation.com/t/crash-report-on-ignition-edge-on-moxa-device/26908)
**Author:** [@lorenzo.milesi](https://forum.inductiveautomation.com/u/lorenzo.milesi)\ **Replies:** 5\ **Last updated:** [August 5, 2019, 12:11pm UTC](https://forum.inductiveautomation.com/t/crash-report-on-ignition-edge-on-moxa-device/26908 "2019-08-05T12:11:12Z")
Hi. We’re doing some tests with Ignition 7.9.12 on Moxa devices. Unfortunately we’re occasionally noticing web interface crashes. It seems to happen more often when there are errors (like when the device is disconnecte… --- ## [Report Pie chart script option](https://forum.inductiveautomation.com/t/report-pie-chart-script-option/27144)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 1\ **Last updated:** [August 5, 2019, 11:59am UTC](https://forum.inductiveautomation.com/t/report-pie-chart-script-option/27144 "2019-08-05T11:59:16Z")
The Report Pie chart component has no scripting option and I need to scale(multiply value) my Tag Calculation query before passing to Pie chart. How can I do it? --- ## [Disable Edge License Through Scripting](https://forum.inductiveautomation.com/t/disable-edge-license-through-scripting/27143)
**Author:** [@wazzucoug763](https://forum.inductiveautomation.com/u/wazzucoug763)\ **Replies:** 0\ **Last updated:** [August 4, 2019, 3:19pm UTC](https://forum.inductiveautomation.com/t/disable-edge-license-through-scripting/27143 "2019-08-04T15:19:52Z")
I am looking at providing an edge device on a rental basis to a customer and then host his application in the cloud. They are a small customer with minimal IT support and are looking for a means of getting some specific… --- ## [Return data from Table in Perspective from user click](https://forum.inductiveautomation.com/t/return-data-from-table-in-perspective-from-user-click/27129)
**Author:** [@David.Bell](https://forum.inductiveautomation.com/u/David.Bell)\ **Replies:** 2\ **Last updated:** [August 3, 2019, 11:50am UTC](https://forum.inductiveautomation.com/t/return-data-from-table-in-perspective-from-user-click/27129 "2019-08-03T11:50:33Z")
Hello, I am trying to collect the data from a row that the user clicks on in Perspective (Ignition v 8.0.2). When a user clicks on a row of the table, I want to be able to use the values from each column in an SQL quer… --- ## [Dock open and close on breakpoint shift](https://forum.inductiveautomation.com/t/dock-open-and-close-on-breakpoint-shift/26157)
**Author:** [@NorthPoint](https://forum.inductiveautomation.com/u/NorthPoint)\ **Replies:** 7\ **Last updated:** [August 2, 2019, 7:10pm UTC](https://forum.inductiveautomation.com/t/dock-open-and-close-on-breakpoint-shift/26157 "2019-08-02T19:10:48Z")
I feel like this question has been sort of asked, but if there was an answer I didn’t understand it completely. I can see from forum posts that direct access to the actual window “size” is not available yet. So what I … --- ## [Passing dataset parameter to popup window, column types change to String](https://forum.inductiveautomation.com/t/passing-dataset-parameter-to-popup-window-column-types-change-to-string/27122)
**Author:** [@mriederer](https://forum.inductiveautomation.com/u/mriederer)\ **Replies:** 1\ **Last updated:** [August 2, 2019, 6:21pm UTC](https://forum.inductiveautomation.com/t/passing-dataset-parameter-to-popup-window-column-types-change-to-string/27122 "2019-08-02T18:21:14Z")
Hi, When I pass a dataset parameter into a popup window, all column types change to String. Is there a fix to this? Or maybe a simple work around that wont be confusing a year from now. Thanks! -Michael Ignition 7.9… --- ## [Alarm Journal Table - Bind Custom Dataset](https://forum.inductiveautomation.com/t/alarm-journal-table-bind-custom-dataset/17281)
**Author:** [@bfuson](https://forum.inductiveautomation.com/u/bfuson)\ **Replies:** 2\ **Last updated:** [August 2, 2019, 5:47pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-bind-custom-dataset/17281 "2019-08-02T17:47:44Z")
I'm attempting to bind a custom alarm dataset to an alarm journal table. Using .setAlarms(dataset) doesn't seem to work. The dataset gets changed briefly but is never refreshed in the table, and gets overwritten by the… --- ## [Pass In Parameters/Data to the Report Chart Script](https://forum.inductiveautomation.com/t/pass-in-parameters-data-to-the-report-chart-script/11432)
**Author:** [@WillMT10](https://forum.inductiveautomation.com/u/WillMT10)\ **Replies:** 4\ **Last updated:** [August 2, 2019, 3:23pm UTC](https://forum.inductiveautomation.com/t/pass-in-parameters-data-to-the-report-chart-script/11432 "2019-08-02T15:23:06Z")
I'm trying to do some "funky" things with the charts in a report to get them exactly how I was requested to make them. This requires that I fine tune the Range Axis on a chart when it loads. I'm trying to update the ra… --- ## [Alarm journal query returns displayPath as evt:Alarms Shelved when a tag is shelved](https://forum.inductiveautomation.com/t/alarm-journal-query-returns-displaypath-as-evt-alarms-shelved-when-a-tag-is-shelved/27117)
**Author:** [@slacasse](https://forum.inductiveautomation.com/u/slacasse)\ **Replies:** 0\ **Last updated:** [August 2, 2019, 2:34pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-query-returns-displaypath-as-evt-alarms-shelved-when-a-tag-is-shelved/27117 "2019-08-02T14:34:51Z")
I have a filter key of name == “Alarms Shelved”. Is the displayPath being incorrectly returned or is it posted in the database this way? all other entries have the displayPath shown correctly. Any help would be appre… --- ## [Oracle JDBC Not Closing Sessions](https://forum.inductiveautomation.com/t/oracle-jdbc-not-closing-sessions/27064)
**Author:** [@sean.jim](https://forum.inductiveautomation.com/u/sean.jim)\ **Replies:** 6\ **Last updated:** [August 2, 2019, 2:19pm UTC](https://forum.inductiveautomation.com/t/oracle-jdbc-not-closing-sessions/27064 "2019-08-02T14:19:31Z")
I’m having weird issues with my Ignition connection to our Oracle database where a new session is being opened for each new query that is sent from any client or designer. Our administrator has limited the number of sess… --- ## [Perspective table, history data binding](https://forum.inductiveautomation.com/t/perspective-table-history-data-binding/27041)
**Author:** [@fedde](https://forum.inductiveautomation.com/u/fedde)\ **Replies:** 2\ **Last updated:** [August 2, 2019, 1:00pm UTC](https://forum.inductiveautomation.com/t/perspective-table-history-data-binding/27041 "2019-08-02T13:00:34Z")
I want to get the tag history of one value from a UDT tag inside a perspective table and use a dropdown to choose what value to show in the table. I can’t find a way to select an indirect tag history binding in perspecti… --- ## [Ignition Alarm Issue](https://forum.inductiveautomation.com/t/ignition-alarm-issue/27108)
**Author:** [@kairongsen](https://forum.inductiveautomation.com/u/kairongsen)\ **Replies:** 0\ **Last updated:** [August 2, 2019, 9:10am UTC](https://forum.inductiveautomation.com/t/ignition-alarm-issue/27108 "2019-08-02T09:10:23Z")
Hi all, i have an issue regarding to alarm. We plan to make a system which an alarm is being triggered when tag value = 1,the user is able to temporary DISABLE with using a button (Maintenance button). When the alarm i… --- ## [Now(0) always return time in Tag expression](https://forum.inductiveautomation.com/t/now-0-always-return-time-in-tag-expression/27037)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 8\ **Last updated:** [August 2, 2019, 12:13am UTC](https://forum.inductiveautomation.com/t/now-0-always-return-time-in-tag-expression/27037 "2019-08-02T00:13:35Z")
Hi I define a tag expression with now(0) as expression. The problem is the value of tag in update in every second with current time. When I set now(0) it should mean it only run only once. why my tag value update ever… --- ## [File Upload directly to DB in Perspective](https://forum.inductiveautomation.com/t/file-upload-directly-to-db-in-perspective/27089)
**Author:** [@Joseph.Gardner](https://forum.inductiveautomation.com/u/Joseph.Gardner)\ **Replies:** 2\ **Last updated:** [August 1, 2019, 6:24pm UTC](https://forum.inductiveautomation.com/t/file-upload-directly-to-db-in-perspective/27089 "2019-08-01T18:24:43Z")
Is it possible to use the file upload component to store an image in a database? I want to convert the image via event.file.getBytes() store it then retrieve and convert this image back when I need it. [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1269) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1271)