All
Accepted answers
Markus Kogler · Dec 13, 2023 go to post

You can set the "showQuery" Property to true - then you will see the sql statement above the tablepane.

Can you post the "DataExtractionCurrent" Method to see further details?

Markus Kogler · Feb 26, 2021 go to post

Hi Nigel,

after some attempts with the above suggestions I got it done with the following way:

  1. Built a custom ZEN loginForm (to add the "remember me" Checkbox)
  2. Used the "Delegated Authentication" mechanism in Caché (https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KE…)
  3. In the ZAUTHENTICATE objectscript routine you can write own code for authentication of the user
    1. here it is possible to check the "normal" Username, Password login
    2. and, if remember login was stored e.g in a cookie, login with a login token...

Thx

Markus Kogler · Jan 16, 2021 go to post

Hi Simon,

IIS doesn't know which server you want to use - this is handled by the CSP Gateway module.

To get this done you need individual application url paths for each server. In the CSP Web Gateway Management you can define a cache server for each application path:

Select Add Server and create a new server configuration for cache server (Y) 

Option 1:
http(s)://<host>/csp/... --> server X   (all url paths except /csp/api)
http(s)://<host>/csp/api --> server Y

  1. Select Application Access
  2. Create a new application configuration. (e.g /csp/api) and select the server (Y) as Server 0
  3. Edit the /csp application and select the server (X) as Server 0

Option 2:
http(s)://<host>/csp/... --> server X
http(s)://<host>/api /... --> server Y

In IIS add a new application (e.g api) and add the same handler mappings like for csp.

In the CSP Webgateway management you do nearly the same like in option 1, except that you create the new application for /api and map it to the server (Y)

See also: https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=GCGI_…