from my point of view, writing and reading from a flat-file is a good one. but instead of that if you take backup whole database and use it wherever you want.  because it would be a generic one. do you face any problems with the backup?

Hi,

   we are updating the data using an update query via the management portal. Globals need to change then we are using the terminal to change it. Recently, started to Visual studio code extension of SQL Tools. but frequently check and update the above would not work out. each time change query parameters. so we created a zen page to do the CRUD operations to the particular table. 

In each item in production having a category property if you specify the value . using the value you can able to filter using Category.

 

 

Step 1: Create a custom persistent class to pass

Example :

Class FileRequest Extends %Persistent

{

Property FilePath As %String(MAXLEN=1000);

Property FileName As %String(MAXLEN=1000);

}

Step 2: Create a custom business operation and inside that request argument please use the above class.

Step 3: now modify the ..Adapter.FilePath using request.FilePath and ..Adapter.FileName using request.FileName

Step 4: Before sending to business operation create the object for the request class and pass it as the first parameter in SendRequestSync or SendRequestAsync.

please try the below steps 

1) go to view -> command palette

2) select "Intersystems server manager: Store password in the key chain" from the list

3) click the + symbol on the right side

4) after that, enter unique definition name, IP address and port 

5) finally enter the username and password