Programatically Open a UX by Name/Alias

[ChristopherG]

No luck finding a relevant thread on this topic. Appreciate it if someone can point me in the right direction.

Most of our system reports have a popup ux used to set filters and to run the report call. Each ux is report specific with filtered pulldowns etc.

If I have an sql based grid listing all report names, could I also store a reference to the report specific ux and then open it from the grid?

For clarity each row of the grid would open a different UX.

[cavj1]

Not sure if this would help but I have a reports table that acts like a lookup table. Then based on the values on my UX I lookup what report to pull. I'm using Reportal with Crystal Reports but I would think the process could work with other reporting applications.

[Russell Craycraft]

I know very little about Grids, but you could build a list that has all of the report names, then put a button on each with a JavaScript Action that would open it's respective report.

[mikeallenbrown]

You can in fact open a UX from a grid. Then that UX can open a report. I'm headed out the door right this moment otherwise I'd write a sample for you. Maybe once I am back.

[ChristopherG]

Thank you everyone.

cavj1 it sounds like the reverse of what I am trying to do but interesting never the less!

Russell Craycraft Thats indeed the objective but whether using list or grid, I need each grid/list row button to first open a report specific config ux. Theoretically this would be based on a reference to the component stored in the same table.

mikeallenbrown I think perhaps your answer is similar to Russells. Opening the same UX from each report row is not an issue. Problem bit is opening a different report specific ux for each report row

[mikeallenbrown]

Thank you everyone.

mikeallenbrown I think perhaps your answer is similar to Russells. Opening the same UX from each report row is not an issue. Problem bit is opening a different report specific ux for each report row

I see now. When the UX is opened pass the report reference you have in your grid into a UX argument. Using a JavaScript run the report you need in the UX.

Short Video Demo: https://drive.google.com/file/d/1Pev...ew?usp=sharing

I uploaded the sample components here and SQL script with data.

[madtowng]

Without getting too involved, I'd guess {dialog.object}.getParentObject() or {dialog.object}.getTopParentObject() would be quite useful.
If you want to avoid the mess of grid row, {dialog.object}.setStateInfo['<variable name>'] will be quite helpful.

[Russell Craycraft]

Just to clarify, are you just wanting a report that has a list with all report names, and then a way to open the report? See below image:
image.png
I'm a visual person, so if you could provide any images or a quick drawing even of what you want that'd allow me to be more helpful.

[ChristopherG]

mikeallenbrown

The principle structure of your code is correct, but ommits the tricky bit. I need each grid row to open a different ux, one specific to the report listed in the row.

For this to work I will have to know the Alias (or ID) of each report specific UX (see 'ReportUXName' field below) and programatically use it to open the component. This is important because reports typically use diverse filters and each need their own UX.

Below is an amended version of your db design:

USE [SandBox]

GO

/****** Object:  Table [dbo].[reports]    Script Date: 1/27/2024 9:18:21 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[reports](

[ID] [int] NOT NULL,

[CustomerName] [nvarchar](100) NULL,

[ReportName] [nvarchar](50) NULL,

[ReportUXName] [nvarchar](50) NULL,

PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

INSERT [dbo].[reports] ([ID], [CustomerName], [ReportName]) VALUES (1, N'Customer A', N'REPORT1', N'rep_1_ux')

INSERT [dbo].[reports] ([ID], [CustomerName], [ReportName]) VALUES (2, N'Customer B', N'REPORT2', N'rep_2_ux')

INSERT [dbo].[reports] ([ID], [CustomerName], [ReportName]) VALUES (3, N'Customer C', N'REPORT3', N'rep_3_ux')

INSERT [dbo].[reports] ([ID], [CustomerName], [ReportName]) VALUES (4, N'Customer D', N'REPORT4', N'rep_4_ux')

INSERT [dbo].[reports] ([ID], [CustomerName], [ReportName]) VALUES (5, N'Customer E', N'REPORT5', N'rep_5_ux')

INSERT [dbo].[reports] ([ID], [CustomerName], [ReportName]) VALUES (6, N'Customer F', N'REPORT6', N'rep_6_ux')

INSERT [dbo].[reports] ([ID], [CustomerName], [ReportName]) VALUES (7, N'Customer G', N'REPORT7', N'rep_7_ux')

INSERT [dbo].[reports] ([ID], [CustomerName], [ReportName]) VALUES (8, N'Customer H', N'REPORT8', N'rep_8_ux')

INSERT [dbo].[reports] ([ID], [CustomerName], [ReportName]) VALUES (9, N'Customer I', N'REPORT9', N'rep_9_ux')

INSERT [dbo].[reports] ([ID], [CustomerName], [ReportName]) VALUES (10, N'Customer J', N'REPORT10', N'rep_10_ux')

GO
​

[ChristopherG]

Just to clarify, are you just wanting a report that has a list with all report names, and then a way to open the report? See below image:
image.png
I'm a visual person, so if you could provide any images or a quick drawing even of what you want that'd allow me to be more helpful.

Russell Craycraft in principle yes but not to open the report directly, rather to open a report specific ux with filters. That UX in turn will open the report.

[ChristopherG]

Without getting too involved, I'd guess {dialog.object}.getParentObject() or {dialog.object}.getTopParentObject() would be quite useful.
If you want to avoid the mess of grid row, {dialog.object}.setStateInfo['<variable name>'] will be quite helpful.

madtowng thank you I'll take a look

[ChristopherG]

Essentially is comes down to the question:

Is it possible to store a reference to a specific Alpha Component in an sql table column, display the sql table in an AA grid, and then open the referenced component programatically, using a button in the grid row.

[mikeallenbrown]

I don't think you need the UX name in a database. I mean, you could do that if you want.


Grid Button

Ashampoo_Snap_Sunday, January 28, 2024_8h55m11s.png


Grid Javascript Actions
Each action would open a separate UX.

Ashampoo_Snap_Sunday, January 28, 2024_8h55m39s.png

[madtowng]

Christopher,
Are you using javascript actions to open the different UX components ?
Are you planning to use data from the grid for the reports ?

[madtowng]

The quick answer is yes, you can open a grid programmatically based on a value in a grid.
You can even reference data from the grid without needing to know the grid alias.
The code below is from one of my UX components that is opened from a grid.

js = <<%txt%


var parentPTR = {dialog.object}.getParentObject();
var topPTR = {dialog.object}.getTopParentObject();
var vbPTR = parentPTR.getControl('search_items_VB');
var custID = parentPTR.getValue('hiddenfkclients')
var filteredArray = [];

topPTR.stateInfo['masterItems'] = JSON.parse(topPTR.stateInfo['masterItems'])
{dialog.object}.stateInfo['newItem'] = <itemJSON>;
topPTR.stateInfo['masterItems'].push({dialog.object}.stateInfo['newItem'][0])
parentPTR.stateInfo['localItems'] = topPTR.stateInfo['masterItems'];


filteredArray = parentPTR.stateInfo['localItems'].filter( (cust) => {
    //if(Number(cust.seq) >= 670){debugger;}
    return  cust.fkclient == custID
})
parentPTR.stateInfo['filteredCustItems'] = filteredArray;

topPTR.stateInfo['masterItems'] = JSON.stringify(topPTR.stateInfo['masterItems'])
vbPTR.populate(filteredArray,false,false );
//parentPTR.showContainerWindow(ele,'SEARCH_ITEMS');
//gebugger;
parentPTR.setValue('partnum',_d.PARTNUM);
{dialog.object}.buttonClick('CLICKCLOSE');
parentPTR.setFocus('QUANTITY')
%txt%​