Display status of a running process in PeopleSoft

So I have a button in a page wherein when it is pressed, it kicks off a process, specifically an application engine. As we all know, when an app engine runs, it is being shown in the process monitor page.

What I want to do is on that same page that I have, the status of the application can be displayed or seen. That part of the page should look like this (see photo 1).

Solution

fetch the runstatus of your process from the table PSPRCSRQST.

The runstatus is an XLAT value. See the table PSXLATITEM where fieldname='RUNSTATUS' for the description of the runstatus

Filter rows using Row number and partition by columns and a business logic
How to check the existence of related records in group by query?
I can't call the data properly into my html page
SQL triggers column updating sequence
Return entries within last 24 hours of a specific date time in SQL
Codeigniter using LIKE with WHERE in SQL query
Case causing ORA-01790: expression must have same datatype as corresponding expression error
Create multiple OR LIKE conditions on the same column using CodeIgniter query building methods
Script to save varbinary data to disk
Excel VBA create 2 temp tables and enter the output into a third temp table and output to excel sheet
Generate report converting rows into column using multiple tables
How to debug SSIS package in SQL Server Management Studio 2017?
Update multiple column of a SQL table based on another table
How to sum 2 values from different queries?
"ERROR: invalid input syntax for type numeric: NULL" postgresql
"The big SQL RegEx": How do I RegEx split an easy SQL query (SELECT ... INTO ... FROM ... WHERE ... GROUP BY ... HAVING ... ORDER BY)?
VBA To Parse Userform Name In Method
Match a list of patterns using SQL IN and LIKE
DuckDB: how do I use the result of a query on `DESCRIBE` to `SELECT` from a table?
Delete all similar rows except first one
Installing MySQL on the D: drive instead of C:
Adding an index to query result
Update records in a SharePoint List by SQL via VBA/ADO?
Return rows where column value is final superset of preceding rows
Is there any intuitive reason why SQL syntax is handled in this order?
Assign Updated Time when a specific column change in SQL
Converting bytes to kilobytes/megabytes
Insert multiple rows at once with CodeIgniter's active record method
JOIN query causes column name collisions in SELECT * clause
Conditionally add an OR WHERE IN () condition using CodeIgniter's query building methods