PS Query & SQL

Hi Query experts!

My friend @Sue Cerrato provided me with a great query, based on record PSPNLFIELD, that will show the records/fields associated with a given page.

I wanted to see if anyone has taken this a step further and created a query to show the process name + type for the page (if it's a page associated with a process).

Basically, we're trying to figure out how to provide some App Designer-style information to those who do not have App Designer!

Thanks,

Nicole

Hi Query experts!

My friend @Sue Cerrato provided me with a great query, based on record PSPNLFIELD, that will show the records/fields associated with a given page.

I wanted to see if anyone has taken this a step further and created a query to show the process name + type for the page (if it's a page associated with a process).

Basically, we're trying to figure out how to provide some App Designer-style information to those who do not have App Designer!

Thanks,

Nicole

Hi Query experts!

My friend @Sue Cerrato provided me with a great query, based on record PSPNLFIELD, that will show the records/fields associated with a given page.

I wanted to see if anyone has taken this a step further and created a query to show the process name + type for the page (if it's a page associated with a process).

Basically, we're trying to figure out how to provide some App Designer-style information to those who do not have App Designer!

Thanks,

Nicole

Keep in mind that a process is associated with a component, not a page. One way to get from a page to a process would be to first join PSPNLFIELD to PSPNLGROUP (on the field PNLNAME) to get all of the component(s) in which the specified page is included and then join PSPNLGROUP  to PRCSDEFNPNL (on the field PNLGRPNAME) to get all of the process definition(s) that are associated with those component(s). Just be aware that there are other ways that a process may be associated with a page (such as via a Command Pushbutton or a PeopleCode event), so this may not give you an all-inclusive list.

Hi Query experts!

My friend @Sue Cerrato provided me with a great query, based on record PSPNLFIELD, that will show the records/fields associated with a given page.

I wanted to see if anyone has taken this a step further and created a query to show the process name + type for the page (if it's a page associated with a process).

Basically, we're trying to figure out how to provide some App Designer-style information to those who do not have App Designer!

Thanks,

Nicole

Hi everyone,

I worked on this a few hours ago and it seems to be ok-ish but I welcome feedback:

SQL:

SELECT DISTINCT A.PNLNAME, A.PNLFLDID, A.LBLTEXT, A.RECNAME, A.FIELDNAME, B.PNLGRPNAME, D.PRCSTYPE, D.PRCSNAME, C.OBJECTOWNERID
  FROM (((PSPNLFIELD A LEFT OUTER JOIN  PSPNLGROUP B ON  A.PNLNAME = B.PNLNAME ) LEFT OUTER JOIN  PSPRSMDEFN C ON  C.PORTAL_NAME = 'EMPLOYEE' AND C.PORTAL_URI_SEG2 = B.PNLGRPNAME ) LEFT OUTER JOIN  PS_PRCSDEFNPNL D ON  D.PNLGRPNAME = C.PORTAL_URI_SEG2 )
  WHERE ( A.PNLNAME LIKE :1
     AND A.FIELDNAME <> ' '
     AND A.FIELDNAME <> 'PSXLATITEM'
     AND A.RECNAME NOT LIKE '%FUNCLIB%'
     AND A.RECNAME NOT LIKE '%WRK%'
     AND A.RECNAME NOT LIKE '%DERIVED%')

Keep in mind that a process is associated with a component, not a page. One way to get from a page to a process would be to first join PSPNLFIELD to PSPNLGROUP (on the field PNLNAME) to get all of the component(s) in which the specified page is included and then join PSPNLGROUP  to PRCSDEFNPNL (on the field PNLGRPNAME) to get all of the process definition(s) that are associated with those component(s). Just be aware that there are other ways that a process may be associated with a page (such as via a Command Pushbutton or a PeopleCode event), so this may not give you an all-inclusive list.

Hi Query experts!

My friend @Sue Cerrato provided me with a great query, based on record PSPNLFIELD, that will show the records/fields associated with a given page.

I wanted to see if anyone has taken this a step further and created a query to show the process name + type for the page (if it's a page associated with a process).

Basically, we're trying to figure out how to provide some App Designer-style information to those who do not have App Designer!

Thanks,

Nicole

I will request something else from a friend:

this appears to work well for Classic pages but not necessarily for Fluid; does anyone have any suggestions?

Thanks!

Hi everyone,

I worked on this a few hours ago and it seems to be ok-ish but I welcome feedback:

SQL:

SELECT DISTINCT A.PNLNAME, A.PNLFLDID, A.LBLTEXT, A.RECNAME, A.FIELDNAME, B.PNLGRPNAME, D.PRCSTYPE, D.PRCSNAME, C.OBJECTOWNERID
  FROM (((PSPNLFIELD A LEFT OUTER JOIN  PSPNLGROUP B ON  A.PNLNAME = B.PNLNAME ) LEFT OUTER JOIN  PSPRSMDEFN C ON  C.PORTAL_NAME = 'EMPLOYEE' AND C.PORTAL_URI_SEG2 = B.PNLGRPNAME ) LEFT OUTER JOIN  PS_PRCSDEFNPNL D ON  D.PNLGRPNAME = C.PORTAL_URI_SEG2 )
  WHERE ( A.PNLNAME LIKE :1
     AND A.FIELDNAME <> ' '
     AND A.FIELDNAME <> 'PSXLATITEM'
     AND A.RECNAME NOT LIKE '%FUNCLIB%'
     AND A.RECNAME NOT LIKE '%WRK%'
     AND A.RECNAME NOT LIKE '%DERIVED%')

Keep in mind that a process is associated with a component, not a page. One way to get from a page to a process would be to first join PSPNLFIELD to PSPNLGROUP (on the field PNLNAME) to get all of the component(s) in which the specified page is included and then join PSPNLGROUP  to PRCSDEFNPNL (on the field PNLGRPNAME) to get all of the process definition(s) that are associated with those component(s). Just be aware that there are other ways that a process may be associated with a page (such as via a Command Pushbutton or a PeopleCode event), so this may not give you an all-inclusive list.

Hi Query experts!

My friend @Sue Cerrato provided me with a great query, based on record PSPNLFIELD, that will show the records/fields associated with a given page.

I wanted to see if anyone has taken this a step further and created a query to show the process name + type for the page (if it's a page associated with a process).

Basically, we're trying to figure out how to provide some App Designer-style information to those who do not have App Designer!

Thanks,

Nicole