List of Contributions

MikRED97

Contact Details

MikRED97


My Content

1 to 20 of 50+ total

RE: FTOptix: Using a database query as a Key Value converter

Posted By MikRED97 Jul 08, 2026 09:55:04 AM
Found In Egroup: FactoryTalk Optix \ view thread
As is typical for me after my last post I was able to figure out what I needed to do not to long after posting. I believe I just need some time to get used to how some of the Optix API calls happen in addition to familiarizing myself some more with instances where things are Nodes vs Objects. The thing ...

RE: FTOptix: Using a database query as a Key Value converter

Posted By MikRED97 Jul 08, 2026 09:13:22 AM
Found In Egroup: FactoryTalk Optix \ view thread
I've now gotten to the point where I can create a Key-Value converter but now the thing I'm attempting to figure out is how remove existing key-value pairs, or update the data within them. It seems like the easiest thing to do would be to wholesale replace the "Pairs" ValueMapConverter type in the converter ...

RE: FTOptix: Using a database query as a Key Value converter

Posted By MikRED97 Jul 07, 2026 12:18:37 PM
Found In Egroup: FactoryTalk Optix \ view thread
After slightly more searching I was able to find what I was looking for in the Netlogic cheat sheet. It was just not in the place I was expecting it to be, I found it under dynamic links. I believe with that I have the tools to accomplish what I was looking to do. As always I really appreciate the ...

RE: FTOptix: Using a database query as a Key Value converter

Posted By MikRED97 Jul 07, 2026 10:16:16 AM
Found In Egroup: FactoryTalk Optix \ view thread
I appreciate the help though my brain is moving a bit slow currently, interacting with the database makes sense to me but the disconnect that I'm having at the moment is getting the information from the queryResult into the Key-Value Converter, that is unless you're suggesting just mapping the query ...

RE: FTOptix: Using a database query as a Key Value converter

Posted By MikRED97 Jul 07, 2026 09:22:05 AM
Found In Egroup: FactoryTalk Optix \ view thread
Could you either provide a bit of context or point me to an example of what you're referring to there? I'm guessing this would all be happening in netlogic? I would query the table with the information I need in netlogic, which I know how to do, but I'm not sure what needs to happen to get that information ...

RE: SQLite Queries in Netlogic

Posted By MikRED97 Jul 07, 2026 09:08:20 AM
Found In Egroup: FactoryTalk Optix \ view thread
Gotcha. I'll put that in my lexicon of things to consider, at least in this application using the Optix APIs is sufficient for my needs so I don't necessary need that ODBC Datastore.

RE: Optix DateTime, ISO 8601 and Logix AOI

Posted By MikRED97 Jul 07, 2026 08:58:00 AM
Found In Egroup: FactoryTalk Optix \ view thread
I also wanted to mention this for anyone who wasn't aware in Logix v34 or later there is a DT datatype that is compatible with the Datetime datatype in Optix without any addition modification. You can get this information from a logix controller by executing the following GSV rung.

RE: SQLite Queries in Netlogic

Posted By MikRED97 Jul 07, 2026 08:30:36 AM
Found In Egroup: FactoryTalk Optix \ view thread
@asemlucben an observation that I made just a moment ago since I don't normally use the ODBC Databases in most of my Optix applications so far that could be problematic in some situations depending on the size of the runtime license being used is that when that ODBC Datastore is created it consumes a ...

FTOptix: Using a database query as a Key Value converter

Posted By MikRED97 Jul 07, 2026 08:15:00 AM
Found In Egroup: FactoryTalk Optix \ view thread
In the application I'm working on a screen where the user can input a number in a spinbox and based off the value of the spin box other labels in the display other columns of the database based on the value selected in the spinbox. I was curious if there was a feature I wasn't privy to that would allow ...

RE: SQLite Queries in Netlogic

Posted By MikRED97 Jul 01, 2026 10:13:44 AM
Found In Egroup: FactoryTalk Optix \ view thread
Gotcha. I had an embedded database setup in the the project view already. In between my post and your reply I got it working with the Optix API calls but I'll add an ODBC Database and see if that lets me do it the way I had it originally planned. And to reiterate I was using Microsoft.Data.SQLite not ...

SQLite Queries in Netlogic

Posted By MikRED97 Jul 01, 2026 08:17:00 AM
Found In Egroup: FactoryTalk Optix \ view thread
I'm working on some slightly more complicated Data handling in netlogic where I'm dealing with data coming from a Rockwell PLC in conjunction with some data stored in a SQLite database that are used as enumerations for the data coming from the PLC. I tested the data handling C# code outside of optix ...

RE: FTOptix: Best Methods for Displaying PLC Data in a Matrix

Posted By MikRED97 Jun 19, 2026 09:53:00 AM
Found In Egroup: FactoryTalk Optix \ view thread
Both are things I've considered. I believe the most reasonable method and the one I considered the best in this situation is what you suggested first. As this is an application where depending on the customer where this project or a variant of it is deployed the number of rows and columns in the ...

FTOptix: Best Methods for Displaying PLC Data in a Matrix

Posted By MikRED97 Jun 18, 2026 02:47:00 PM
Found In Egroup: FactoryTalk Optix \ view thread
I'm working on converting an older dot-net program over to an optix program and a portion of that includes tables or datagrids in optix terms. The thing that makes this a bit more interesting is that the data coming from the PLC uses multiple Single dimensional arrays as columns and in some cases those ...

RE: FTOptix: Accessing Logix Tag Based Alarms Alarm Group and Alarm Class properties for use in Event Logger

Posted By MikRED97 Jun 04, 2026 07:27:00 AM
Found In Egroup: FactoryTalk Optix \ view thread
@Ash it does appear as those options must have become available in one of the 1.7 updates.

RE: FTOptix: Accessing Logix Tag Based Alarms Alarm Group and Alarm Class properties for use in Event Logger

Posted By MikRED97 Jun 03, 2026 06:12:00 PM
Found In Egroup: FactoryTalk Optix \ view thread
@ASH I'll take a look at that because I believe that would likely work for my use case. I haven't taken a look at it since 1.6 so it may be that it was added in 1.7 because last time I looked it I don't remember the RAAlarmData object being available in the UI for under the alarm condition, specifically ...

RE: FT Optix: Combo Box with Query doesn't retain PLC value when Optix is restarted

Posted By MikRED97 May 06, 2026 08:35:00 AM
Found In Egroup: FactoryTalk Optix \ view thread
I originally was using an enumeration for the combo box though that using that doesn't provide the functionality of using a where clause to filter the second combo box in each set as Luben pointed out in this post, which is hunch as a part of what is causing this behavior in conjunction with your idea ...

FT Optix: Combo Box with Query doesn't retain PLC value when Optix is restarted

Posted By MikRED97 May 05, 2026 04:44:00 PM
Found In Egroup: FactoryTalk Optix \ view thread
I have two sets of two combo boxes where the first combo box in a set determines the values available in the second combo box. The interesting thing that I have found with this particular use case is that when I link the selected value of the second combo box to a PLC tag when I restart the optix ...

Optix: Combo Box with Query doesn't retain PLC value when Optix is restarted

Posted By MikRED97 May 05, 2026 04:43:39 PM
Found In Library: FactoryTalk Optix

RE: FTOptix: How to use Where Clause in Query for Combo Box with Node Based Model

Posted By MikRED97 May 04, 2026 03:24:00 PM
Found In Egroup: FactoryTalk Optix \ view thread
Thanks for the info there. I've moved to using objects in a folder so I can have that functionality without having to setup a DB that would have to be initialized each time the project is deployed to a new device. So to do what I am wanting currently this is the method I have used for those following ...

FTOptix: How to use Where Clause in Query for Combo Box with Node Based Model

Posted By MikRED97 May 04, 2026 08:22:28 AM
Found In Library: FactoryTalk Optix