topic Re: Getting grid row ID via script in Fusion Manage Forum

Getting grid row ID via script

pxedust — Fri, 29 Mar 2024 19:20:41 GMT

I've been searching the forums and while I see the question has been asked, the answers are other ways to achieve what the OP is attempting without the need for that ID, and a reference to it being rowID, which doesn't work.

Is the system-assigned ID for a grid row available?

Re: Getting grid row ID via script

philipfrench — Fri, 29 Mar 2024 20:38:52 GMT

Could you write a few words to explain what you are trying to do, that needs script to know the grid rowID?

I have written a lot of scripting related to grids, and I never needed the rowID. I suspect there may be an easier way to achieve what you want.

Re: Getting grid row ID via script

pxedust — Fri, 29 Mar 2024 21:08:04 GMT

Hey, long time no chat! 🙂

Several fields in the grid are being passed to the next workspace (ECO or task, depending). The short answer is that the row ID, if available, allows identifying the source of the information without requiring user input in a comments field. For example, if we're creating 2 dozen new products out of the project the resulting ECOs have no automated means to determine which ECO corresponds to its originating grid line. The user would need to manually do that instead of just pulling up the ECO in one window and the grid in another when they do those first edits of the ECO to provide scope.

Re: Getting grid row ID via script

philipfrench — Mon, 01 Apr 2024 13:50:09 GMT

Can you add a column to the grid to hold the link (RO picklist) to the Eco generated, or a column to store the ECO ID (from the sequencer I hope you're using to name the ECO) ?

Or just add a column to store a number/string that you generate yourself? Effectively your own row id?

I suspect I have not understood your case properly.

As an absolute last resort you could perhaps call the grid API using the script, but don't be surprised if you end up deadlocking and timing out.

Re: Getting grid row ID via script

pxedust — Tue, 02 Apr 2024 13:46:31 GMT

The additional columns are the next best option, but they'd need to wait till our next round of updates. The ability to just grab the row ID since it already exists would have been quick and easy. Thank you for confirming that getting to it isn't, however - I spent a good deal of time digging for it. 🙂