List of Contributions

Fox

Contact Details

Fox


My Content

1 to 20 of 31 total

Change in how Studio 5000 Interpret EDS files in newer versions

Posted By Fox Mar 12, 2024 11:59:00 AM
Found In Egroup: Automation Control \ view thread
Newer versions of Studio 5000 have changed how they interpret EDS files for some devices. In the latest version, they don't show up as an array of inputs, but rather as individual words. They even change the data type from what's configured in the module properties. Is there a workaround for this ...

RE: Optix SQL Querry Counting ORDER BY not working

Posted By Fox Mar 08, 2024 09:45:00 AM
Found In Egroup: Advanced Software \ view thread
Got it working! Here's the final SQL query: SELECT LastRecipeLoaded, COUNT(*) AS RecipeCount FROM "RecipeHistory" GROUP BY "LastRecipeLoaded" ORDER BY RecipeCount DESC The only real difference here is i used the AS keyword to assign count an alias. I had tried this previously but the reference ...

RE: Optix SQL Querry Counting ORDER BY not working

Posted By Fox Mar 07, 2024 08:46:14 PM
Found In Library: Advanced Software

RE: Optix SQL Querry Counting ORDER BY not working

Posted By Fox Mar 07, 2024 08:46:00 PM
Found In Egroup: Advanced Software \ view thread
Hey Shane - here's the sample file I've been playing around with if you'd like to take a look. I'd like to use as much standard functionality as possible, but do you have an example of how you would do this with netlogic? I havnt had much luck with Netlogic, and even small modifications have crashed ...

RE: Optix SQL Querry Counting ORDER BY not working

Posted By Fox Mar 07, 2024 08:31:57 PM
Found In Egroup: Advanced Software \ view thread
I also double-checked the GROUP BY clause and that does function in the data grid's query. Here's the results without the GROUP BY clause... All elements in the table are counted together. And here's the results with the GROUP BY clause:

RE: Optix SQL Querry Counting ORDER BY not working

Posted By Fox Mar 07, 2024 08:24:28 PM
Found In Egroup: Advanced Software \ view thread
Have you found any documentation regarding these queries only accepting "waterered down" SQL querys? This seems go against what even the help documentation discusses. So i did a few tests on a more "normal" SQL query in another data grid. For this first test, ran a basic query using ORDER BY in the ...

RE: Optix SQL Querry Counting ORDER BY not working

Posted By Fox Mar 07, 2024 08:59:50 AM
Found In Egroup: Advanced Software \ view thread
So the query has to have a sort order somewhere, whether it be in the query string or the order by in one of the columns order by fields. Removing it from both fields will produce an error that an ORDER BY clause is missing. This is true even if a tag in the Sorting column is filled in for the overall ...

RE: Optix SQL Querry Counting ORDER BY not working

Posted By Fox Mar 07, 2024 07:07:40 AM
Found In Egroup: Advanced Software \ view thread
Hey Shane, Thanks for the responce. I would have thought the ORDER BY in the query would have taken care of sorting the whole grid, but i went ahead and tried the method you suggested as well. Below is a screenshot of the results after changing that. It's still not sorting by the count. Any other ...

RE: Optix SQL Querry Counting ORDER BY not working

Posted By Fox Mar 06, 2024 09:57:00 PM
Found In Egroup: Advanced Software \ view thread
Hmm.. looks like even the lower case vs upper case isnt the only issue.. its still sorting by recipe name

Optix SQL Querry Counting ORDER BY not working

Posted By Fox Mar 06, 2024 08:10:00 PM
Found In Egroup: Advanced Software \ view thread
I have a data grid thats pulling the history recipes loaded (data logger that looks for a value change in the active recipe). I want it to count the number each recipe loaded over the last 100 or so recipe changes. For that limit i was just going to adust the record limit in the database. Anyway, ...

RE: Optix Recipe Selection

Posted By Fox Mar 06, 2024 10:36:00 AM
Found In Library: Advanced Software

RE: Optix Recipe Selection

Posted By Fox Mar 06, 2024 10:36:00 AM
Found In Egroup: Advanced Software \ view thread
Hey Desta, Try this one. There are 3 different data grids between the recipe selection screen and recipe editor screen. One of the data grids on the right of the recipe selection screen is a time stamped history of the last 10 recipes loaded. You can select and load a recipe from any of the data gri ...

RE: Optix Recipe History

Posted By Fox Mar 01, 2024 06:31:12 AM
Found In Egroup: Advanced Software \ view thread
Hi asemlucben, Can you please elaborate in that?

RE: Optix Recipe Selection

Posted By Fox Feb 29, 2024 03:16:00 PM
Found In Egroup: Advanced Software \ view thread
Ok, so I got this issue figured out as well. Feeling pretty accomplished today even though i spent all day fighting this. lol. So in the data grid, the selected item (Pointer) only outputs the Node ID, which in this case wasnt very helpful. I needed the Name of the recipe as a string. What i missed ...

Optix Recipe History

Posted By Fox Feb 29, 2024 02:46:00 PM
Found In Egroup: Advanced Software \ view thread
I want to do a few more things with recipes. Any help on how i might get started on these? Display the current recipe name (thats been sent to the PLC) Track the last 5 recipes used, and be able to recall them directly from that list Track the top 5-10 most frequently used recipes, and be able ...

RE: Optix Recipe Selection

Posted By Fox Feb 29, 2024 02:30:42 PM
Found In Egroup: Advanced Software \ view thread
Second issue then is how do i make this work with the data grid. It doesnt have the same variables as the list box, for example, the selectedvalue is not a variable in the data grid. So i need a way to extract the "name" string in the data grid of the selected entry and once i have that i should be able ...

RE: Optix Recipe Selection

Posted By Fox Feb 29, 2024 01:53:57 PM
Found In Egroup: Advanced Software \ view thread
Ok so one update.. using the user selection changed event on the list box, i added the CopyFromStoreRecipe method and it works just fine on that, and copies the recipe selected to the edit model when clicking each item in the list box. I think we can call this part resolved, although i'd love to know ...

RE: Optix Recipe Selection

Posted By Fox Feb 29, 2024 01:40:06 PM
Found In Egroup: Advanced Software \ view thread
So that variable is just referencing back to the recipe schema itself, not a specific recipe in the recipe schema. Same goes for the variable in the owner object (panel). It just ties back to the recipe schema itself. So to tackle one problem at a time, i decided to start with a list box and get it ...

Optix Recipe Selection

Posted By Fox Feb 28, 2024 03:31:00 PM
Found In Egroup: Advanced Software \ view thread
So having users select from a drop down list to select a recipe doesnt seem ideal if you have a lot of recipes. I'm asuming for normal operation, the typical operator would go to a recipe selection screen, select a recipe out of a data grid list, hit apply, and that recipe would be loaded to the PLC. ...

Circular Guage - add unwind / rollover property??

Posted By Fox Feb 07, 2024 08:58:00 AM
Found In Egroup: Advanced Software \ view thread
In Factoytalk Optix, is it possible to create a modified circular guage base control that supports unwind/rollover? For example, The index position on a rotaty axis is 52.5 degrees. I want the lower limit of the circular guage to read 232.5 and the upper limit to read 52.5, with the 360 degree position ...