# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1258 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1259 --- ## [Change gradient color step in expression](https://forum.inductiveautomation.com/t/change-gradient-color-step-in-expression/28215)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 5\ **Last updated:** [September 12, 2019, 5:57pm UTC](https://forum.inductiveautomation.com/t/change-gradient-color-step-in-expression/28215 "2019-09-12T17:57:09Z")
Hi I want to change fill color of vector object in expression. The problem is the color is gradient in 3 step and I don’t know how to set new gradient color for each step by using expression language. Is this possible? … --- ## [User object functions](https://forum.inductiveautomation.com/t/user-object-functions/28211)
**Author:** [@tyrel.parker](https://forum.inductiveautomation.com/u/tyrel.parker)\ **Replies:** 5\ **Last updated:** [September 12, 2019, 5:11pm UTC](https://forum.inductiveautomation.com/t/user-object-functions/28211 "2019-09-12T17:11:21Z")
I’m trying to use the system.user.editUser function, but according to the documentation (https://docs.inductiveautomation.com/display/DOC80/system.user.editUser) I need to edit the user object with methods that don’t see… --- ## [Search Historian with WHERE clause](https://forum.inductiveautomation.com/t/search-historian-with-where-clause/23541)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 6\ **Last updated:** [September 12, 2019, 5:01pm UTC](https://forum.inductiveautomation.com/t/search-historian-with-where-clause/23541 "2019-09-12T17:01:42Z")
I would like to be able to search for values in the historian that meet certain criteria, for example: all values for a given tag where the value is between a high and low limit. Is this possible with any of the built in… --- ## [Table information](https://forum.inductiveautomation.com/t/table-information/28152)
**Author:** [@DD\_Chelsea](https://forum.inductiveautomation.com/u/DD_Chelsea)\ **Replies:** 3\ **Last updated:** [September 12, 2019, 4:53pm UTC](https://forum.inductiveautomation.com/t/table-information/28152 "2019-09-12T16:53:59Z")
Hello guys, good morning. I have a table where im registering the last 30 consoles sold, that table is not from a database. I’m using the cell update binding to register the data. Now i want to display that data on a n… --- ## [Writing tag value in the table which is created by dataset](https://forum.inductiveautomation.com/t/writing-tag-value-in-the-table-which-is-created-by-dataset/28214)
**Author:** [@spatel](https://forum.inductiveautomation.com/u/spatel)\ **Replies:** 2\ **Last updated:** [September 12, 2019, 3:54pm UTC](https://forum.inductiveautomation.com/t/writing-tag-value-in-the-table-which-is-created-by-dataset/28214 "2019-09-12T15:54:48Z")
I have a data set that I created that is linked to the table shown in pic 1. I have a tag that has a value, and I need to write that value to column 1, row “Clock#”. I have no idea how to write a piece of data to a p… --- ## [Connecting Central Server to Igntion Edge](https://forum.inductiveautomation.com/t/connecting-central-server-to-igntion-edge/28209)
**Author:** [@jparsons](https://forum.inductiveautomation.com/u/jparsons)\ **Replies:** 0\ **Last updated:** [September 12, 2019, 2:27pm UTC](https://forum.inductiveautomation.com/t/connecting-central-server-to-igntion-edge/28209 "2019-09-12T14:27:48Z")
I am trying to connect an ignition edge client to a central server through MQTT. I can’t find any information anywhere on how to do so. I have both the server and the edge gateway up and going. I have the MQTT distribut… --- ## [Ldap authentication "gateway username" and users in different OU different username suffixes](https://forum.inductiveautomation.com/t/ldap-authentication-gateway-username-and-users-in-different-ou-different-username-suffixes/28208)
**Author:** [@alfred\_dussault](https://forum.inductiveautomation.com/u/alfred_dussault)\ **Replies:** 0\ **Last updated:** [September 12, 2019, 1:58pm UTC](https://forum.inductiveautomation.com/t/ldap-authentication-gateway-username-and-users-in-different-ou-different-username-suffixes/28208 "2019-09-12T13:58:45Z")
Hi folks, I have an interesting problem that may be fixable. but I’m not sure what the workaround should be. I am using multiple “AD/internal user sources” against an LDAP server, (not AD) in order to accommodate authe… --- ## [System.opc.browse and system.opc.browseSimple read timeout](https://forum.inductiveautomation.com/t/system-opc-browse-and-system-opc-browsesimple-read-timeout/18258)
**Author:** [@cmaynes](https://forum.inductiveautomation.com/u/cmaynes)\ **Replies:** 1\ **Last updated:** [September 12, 2019, 11:58am UTC](https://forum.inductiveautomation.com/t/system-opc-browse-and-system-opc-browsesimple-read-timeout/18258 "2019-09-12T11:58:31Z")
How we have things setup: A machine has a Siemens PLC We have a RedLion DSPLE unit to do the protocol conversion to Allen Bradley, which supports browsing We have our Allen-Bradley PLC tags mapped to the Siemens tags thr… --- ## [Unable to start the gateway](https://forum.inductiveautomation.com/t/unable-to-start-the-gateway/28194)
**Author:** [@arjunas](https://forum.inductiveautomation.com/u/arjunas)\ **Replies:** 3\ **Last updated:** [September 12, 2019, 11:56am UTC](https://forum.inductiveautomation.com/t/unable-to-start-the-gateway/28194 "2019-09-12T11:56:58Z")
HI , We use Ignition 7.9.7 and the Gateway has stopped and logs error for every 10 sec the log error is com.inductive automation.ignition.gateway.web.util.Localized MessageException: The data store has reached its max… --- ## [Classic Chart date range](https://forum.inductiveautomation.com/t/classic-chart-date-range/28175)
**Author:** [@pascal](https://forum.inductiveautomation.com/u/pascal)\ **Replies:** 2\ **Last updated:** [September 12, 2019, 7:04am UTC](https://forum.inductiveautomation.com/t/classic-chart-date-range/28175 "2019-09-12T07:04:45Z")
Hello, I’m torturing myself with the Classic Chart component. I have a dataset with one value per week (starting on monday). Here is the Chart and the Dataset used to populate this chart. What I would like is to ha… --- ## [Getting a query from a query](https://forum.inductiveautomation.com/t/getting-a-query-from-a-query/28185)
**Author:** [@DD\_Chelsea](https://forum.inductiveautomation.com/u/DD_Chelsea)\ **Replies:** 2\ **Last updated:** [September 11, 2019, 7:26pm UTC](https://forum.inductiveautomation.com/t/getting-a-query-from-a-query/28185 "2019-09-11T19:26:39Z")
Good morning guys. I’m trying to gather information about a table in my database. The information of the database is the following: I’m trying to gather a count of “NEXT MAX” of the last 10 rows of my table. my qu… --- ## [Report: Timeseries Chart (Domain values in X axis)](https://forum.inductiveautomation.com/t/report-timeseries-chart-domain-values-in-x-axis/27982)
**Author:** [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Replies:** 1\ **Last updated:** [September 11, 2019, 5:59pm UTC](https://forum.inductiveautomation.com/t/report-timeseries-chart-domain-values-in-x-axis/27982 "2019-09-11T17:59:14Z")
Good afternoon. In Ignition 8.0.3, in a “timeseries chart” (report), I’m trying to show the domain values (datetimes) of data source in X Axis, but the values ​​that are being displayed do not match the values ​​of the … --- ## [Translator for Sybase Anywhere 12](https://forum.inductiveautomation.com/t/translator-for-sybase-anywhere-12/5810)
**Author:** [@Blackcat](https://forum.inductiveautomation.com/u/Blackcat)\ **Replies:** 9\ **Last updated:** [September 11, 2019, 5:06pm UTC](https://forum.inductiveautomation.com/t/translator-for-sybase-anywhere-12/5810 "2019-09-11T17:06:48Z")
Hi All, I just made a connection between Ignition and a Sybase database. I chose "Generic" for default translator, connexion is OK but some request creates errors. I think I need to create a new database translator but… --- ## [Gradient color for style Area in easy chart](https://forum.inductiveautomation.com/t/gradient-color-for-style-area-in-easy-chart/28161)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 1\ **Last updated:** [September 11, 2019, 3:55pm UTC](https://forum.inductiveautomation.com/t/gradient-color-for-style-area-in-easy-chart/28161 "2019-09-11T15:55:36Z")
Hello I want to use gradient color in easy chart for style area. Red color for high value and blue to lower value. Right now easy chart only accept solid color for style area. Is there any way to force it by using java… --- ## [Link image to source file on mapped or E: drive in Perspective](https://forum.inductiveautomation.com/t/link-image-to-source-file-on-mapped-or-e-drive-in-perspective/28178)
**Author:** [@David.Bell](https://forum.inductiveautomation.com/u/David.Bell)\ **Replies:** 2\ **Last updated:** [September 11, 2019, 3:53pm UTC](https://forum.inductiveautomation.com/t/link-image-to-source-file-on-mapped-or-e-drive-in-perspective/28178 "2019-09-11T15:53:58Z")
Hello, has anyone been able to point to an image on mapped or E: drive in Perspective? Thanks! David --- ## [Change image displayed based of off row user selects from table](https://forum.inductiveautomation.com/t/change-image-displayed-based-of-off-row-user-selects-from-table/27585)
**Author:** [@David.Bell](https://forum.inductiveautomation.com/u/David.Bell)\ **Replies:** 6\ **Last updated:** [August 20, 2019, 3:16pm UTC](https://forum.inductiveautomation.com/t/change-image-displayed-based-of-off-row-user-selects-from-table/27585 "2019-08-20T15:16:30Z")
Hello, I want to display different pictures based on the data in a table that the user clicks. For example, if I have the following table Row Image 1 Click to show a flower 2 Click t… --- ## [Question for HMI data real-timely update if using SQLBridge database](https://forum.inductiveautomation.com/t/question-for-hmi-data-real-timely-update-if-using-sqlbridge-database/28162)
**Author:** [@dawei.liu](https://forum.inductiveautomation.com/u/dawei.liu)\ **Replies:** 2\ **Last updated:** [September 11, 2019, 3:30pm UTC](https://forum.inductiveautomation.com/t/question-for-hmi-data-real-timely-update-if-using-sqlbridge-database/28162 "2019-09-11T15:30:14Z")
Hi, For some HMI widgets display (its data are come from PLC OPCUA server), we want to use SQL Bridge to store the PLC OPC tags in the database table, and HMI widgets retrieve the data from the table( Just want to isola… --- ## [SQLBridge and Indirect Tags](https://forum.inductiveautomation.com/t/sqlbridge-and-indirect-tags/20947)
**Author:** [@BillS](https://forum.inductiveautomation.com/u/BillS)\ **Replies:** 2\ **Last updated:** [September 11, 2019, 8:19am UTC](https://forum.inductiveautomation.com/t/sqlbridge-and-indirect-tags/20947 "2019-09-11T08:19:18Z")
Hello, I'd like to have some more generic Transaction groups. We have 4 groups of things things that are identical. Using the same Data Types layout differing only by a key field that corresponds on both the Tag Nam… --- ## [Displaying the same data from a database table in multiple columns of a Perspective Table](https://forum.inductiveautomation.com/t/displaying-the-same-data-from-a-database-table-in-multiple-columns-of-a-perspective-table/28172)
**Author:** [@azoraian](https://forum.inductiveautomation.com/u/azoraian)\ **Replies:** 0\ **Last updated:** [September 11, 2019, 2:35pm UTC](https://forum.inductiveautomation.com/t/displaying-the-same-data-from-a-database-table-in-multiple-columns-of-a-perspective-table/28172 "2019-09-11T14:35:40Z")
Hello, I’m working on a Perspective Table that is populated by a SQL Query of a Database Table. Each row in the DB Table has a unique ID, which I’m hoping to use inside my Perspective Table in four separate columns to p… --- ## [Python bug or python bug?](https://forum.inductiveautomation.com/t/python-bug-or-python-bug/22246)
**Author:** [@jose.granero](https://forum.inductiveautomation.com/u/jose.granero)\ **Replies:** 7\ **Last updated:** [September 11, 2019, 7:32am UTC](https://forum.inductiveautomation.com/t/python-bug-or-python-bug/22246 "2019-09-11T07:32:22Z")
I have the following code to create a new dataset from an existing one, and I can’t figure out why the resulting dataset has the same data for every row. The problem arises at the end, although the variable Newdata chang… --- ## [Connect the SCADA sites to main sites](https://forum.inductiveautomation.com/t/connect-the-scada-sites-to-main-sites/28136)
**Author:** [@ido](https://forum.inductiveautomation.com/u/ido)\ **Replies:** 4\ **Last updated:** [September 11, 2019, 4:04am UTC](https://forum.inductiveautomation.com/t/connect-the-scada-sites-to-main-sites/28136 "2019-09-11T04:04:32Z")
We are trying to find a proper way to connect the SCADA sites to the main sites. Last time we’ve done temporary link using VSAT technology, the connection wasn’t so stable and we don’t really understand why ? Can you t… --- ## [Help Menu on Ignition Designer V8](https://forum.inductiveautomation.com/t/help-menu-on-ignition-designer-v8/28125)
**Author:** [@manutchaisrichai](https://forum.inductiveautomation.com/u/manutchaisrichai)\ **Replies:** 2\ **Last updated:** [September 11, 2019, 1:46am UTC](https://forum.inductiveautomation.com/t/help-menu-on-ignition-designer-v8/28125 "2019-09-11T01:46:07Z")
The help information from F1 or from Help menu in Ignition designer is not available during internet is ofline. How can I have using help in Ignition designer when I do not have the Internet connection. --- ## [Label problem with big characters](https://forum.inductiveautomation.com/t/label-problem-with-big-characters/28154)
**Author:** [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\ **Replies:** 0\ **Last updated:** [September 10, 2019, 8:24pm UTC](https://forum.inductiveautomation.com/t/label-problem-with-big-characters/28154 "2019-09-10T20:24:21Z")
I’m having problem with labels in Ignition 8.0.3. I’m using label to show big arial letter (size 60). And the last letter is truckated. Lookl: Any ideas? --- ## [Historian archive](https://forum.inductiveautomation.com/t/historian-archive/28150)
**Author:** [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\ **Replies:** 0\ **Last updated:** [September 10, 2019, 7:01pm UTC](https://forum.inductiveautomation.com/t/historian-archive/28150 "2019-09-10T19:01:25Z")
Hello all, Is it possible to automaticly backup the volume created by the historian? Let’s say: Database max space is 1 TB 1TB mean about 30 months of data. We can live with 30 months of live values Partitionning is c… --- ## [Issue and potential bug with system.dataset.toCSV](https://forum.inductiveautomation.com/t/issue-and-potential-bug-with-system-dataset-tocsv/28142)
**Author:** [@mcgheeiv](https://forum.inductiveautomation.com/u/mcgheeiv)\ **Replies:** 0\ **Last updated:** [September 10, 2019, 4:18pm UTC](https://forum.inductiveautomation.com/t/issue-and-potential-bug-with-system-dataset-tocsv/28142 "2019-09-10T16:18:25Z")
Ignition 8.0.4 system.dataset.toCSV in US vs Belgium. I am using the following to generate CSV for export. The project is used in both the US and Belgium with very different results in both places. csv = system.dataset… --- ## [Gateway Timer Script Limits](https://forum.inductiveautomation.com/t/gateway-timer-script-limits/28138)
**Author:** [@ClemsonTim80](https://forum.inductiveautomation.com/u/ClemsonTim80)\ **Replies:** 6\ **Last updated:** [September 10, 2019, 4:13pm UTC](https://forum.inductiveautomation.com/t/gateway-timer-script-limits/28138 "2019-09-10T16:13:12Z")
Can anyone provide details in terms of maximum script length ? I currently have a Gateway Timer Script that apparently has exceeded some limits. When I select “Apply” I get: Warning: The script for timer script: ‘Event… --- ## [Viewing vision project from a client's website](https://forum.inductiveautomation.com/t/viewing-vision-project-from-a-clients-website/28111)
**Author:** [@JohnMck](https://forum.inductiveautomation.com/u/JohnMck)\ **Replies:** 1\ **Last updated:** [September 10, 2019, 3:30pm UTC](https://forum.inductiveautomation.com/t/viewing-vision-project-from-a-clients-website/28111 "2019-09-10T15:30:37Z")
I’m guessing that the answer to this is either very simple or very complicated… I have a client (municipal water plant) that has a general city web site. Within that website users can log into a secure web page. From … --- ## [Suggestion to improve tag change scripts](https://forum.inductiveautomation.com/t/suggestion-to-improve-tag-change-scripts/6096)
**Author:** [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Replies:** 5\ **Last updated:** [September 10, 2019, 3:28pm UTC](https://forum.inductiveautomation.com/t/suggestion-to-improve-tag-change-scripts/6096 "2019-09-10T15:28:29Z")
would it be possible to add functionality to use a sql query to build the tag list in the tag change script? What I am after is the ability to add new tags to the tag change script without having to go into the design… --- ## [Ignition and OPCUA WAGO (PFC200)](https://forum.inductiveautomation.com/t/ignition-and-opcua-wago-pfc200/28016)
**Author:** [@apimente](https://forum.inductiveautomation.com/u/apimente)\ **Replies:** 10\ **Last updated:** [September 10, 2019, 2:32pm UTC](https://forum.inductiveautomation.com/t/ignition-and-opcua-wago-pfc200/28016 "2019-09-10T14:32:29Z")
Hello, We’re trying to connect Ignition to a WAGO PLC. As maybe you know, wago and his software eCockpit provide his own OPCUA server (inside the PLC) so we want to use it. In youtube there is the following tutorial b… --- ## [Question for string to color mapping in the dropdown list](https://forum.inductiveautomation.com/t/question-for-string-to-color-mapping-in-the-dropdown-list/28098)
**Author:** [@dawei.liu](https://forum.inductiveautomation.com/u/dawei.liu)\ **Replies:** 2\ **Last updated:** [September 9, 2019, 3:31pm UTC](https://forum.inductiveautomation.com/t/question-for-string-to-color-mapping-in-the-dropdown-list/28098 "2019-09-09T15:31:22Z")
Hi, I want to implement a feature in dropdown list to choose different color such as green, red, blue. The drop-down list will show two columns, one column for the description of color, one column for the color itself.… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1257) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1259)