go to post Alexander Koblov · Mar 24, 2017 Hi Amir. Some of items you mentioned are already in Atelier Support for using Studio wizards of a specific sever connection. Go to File -> New -> Other. Then Atelier -> New File -> Custom File. Choose connection and pick Server-side template. Also you can go to Tools-> Add-Ins or Tools -> Templates and run good old Studio Add-Ins or Templates Support for seeing a CSP page (like when we click on the globe icon and the CSP page opens) Hm, there is already globe icon on Atelier toolbar that opens CSP page. The 6th in that list http://docs.intersystems.com/atelier/latest/topic/com.intersys.eclipse.h... Support for seeing the other The 5th in that list http://docs.intersystems.com/atelier/latest/topic/com.intersys.eclipse.h... GitHub and CRLF / LF As I understand this configuration should be done on EGit side, by setting core.autocrlf = true for Windows installations. http://mike.meessen.biz/blog/?p=368
go to post Alexander Koblov · Mar 23, 2017 Or TO_CHAR. Depending if you need convert string -> date (TO_DATE) or date -> string (TO_CHAR)
go to post Alexander Koblov · Mar 16, 2017 Cool! It would be great to show articles only for particular Author in Article dropdown list once the Author is chosen.
go to post Alexander Koblov · Mar 15, 2017 I think you can construct pKey as $ListBuild of different values and parse them back in LoadForm. I don't think it's possible to add other parameters to LoadForm callback
go to post Alexander Koblov · Mar 10, 2017 At least please notice that Caché ObjectScript does not have operator precedence. Instead of if (c >= 128 && c <= 255) { you should write if (c >= 128) && (c <= 255) { the same with s:(c >= 128 && c <= 255) retval=$lg(map,(c-128))
go to post Alexander Koblov · Feb 6, 2017 Java binding is deprecated. http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...
go to post Alexander Koblov · Feb 3, 2017 ^%SYS.MONLBL is a great tool for profiling: http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...
go to post Alexander Koblov · Jan 31, 2017 First of all, this is bad sample of GROUP BY query, in my opinion: SELECT c1, c2 FROM table2 GROUP BY c1 You are grouping by c1, but also selecting c2. GROUP BY collects all rows with the same c1 into one row. Each group of row with the same c1 might have different values of c2. What particular value of c2 you want to get? Generally, if you query contains GROUP BY, SELECT should contain either expressions from GROUP BY, or aggregate functions. For example, following query is OK: SELECT c1, max(c2) FROM table2 GROUP BY c1 Having said all that, you might try to concatenate column1 and columnn2 SELECT column1, column2, column 3 FROM table WHERE column1 || '===' || columnn2 IN (SELECT c1 || '===' || c2 FROM table2 GROUP BY c1) ORDER BY column1 provided that values in these columns do not contain '===' Another possibility is: SELECT column1, column2, column 3 FROM table T1 WHERE EXISTS (SELECT 1 FROM table2 T2 WHERE T2.c1 = T1.column1 AND T2.c2 = T1.column2) ORDER BY column1 I think GROUP BY is not necessary in second case.
go to post Alexander Koblov · Jan 26, 2017 Hi Token. As I understand XML you provided in the beginning is the response to the SOAP request you are doing. If that's correct, than this response is not validated with XML Schema from provided WSDL. You should check with developers who maintain this SOAP service if WSDL you have is correct. Also you might try to change Parameter NAMESPACE = "http://192.96.222.19/"; in Class Data.SOAP.CardData to Parameter NAMESPACE = "http://111.12.123.11/"; Even if this helps, this would be temporary solution for one particular request, other might fail if you have not-correct WSDL.
go to post Alexander Koblov · Jan 25, 2017 Hi Token. a) Please notice, WSDL that you provided is not correct. For example, try to validate it in https://www.wsdl-analyzer.com/. Or, download SOAP UI and try to create SOAP project based on this wsdl. You'll see errors. I've tried to import this WSDL into 2012.2.5 and got following error: ERROR #6294: Cannot find message part in schema: Classname not found for http://halykws/::GetContractsExt b) Version you have is almost 7 years old. Please consider upgrading. Cache for UNIX (Red Hat Enterprise Linux 5 for x86-64) 2010.1.2 (Build 600U) Mon May 10 2010 23:28:54 EDT c) If you need further help with this, please open WRC issue. In any case, first thing you need to do is to have valid WSDL.
go to post Alexander Koblov · Jan 24, 2017 Hi Token. Can you please attach complete wsdl and provide version of Caché that you use ('write $zversion'). Did you use SOAP Client Wizard to generate SOAP client classes from WSDL?
go to post Alexander Koblov · Jan 24, 2017 Hi Thomas. Supported platforms for 2017.1 (http://docs.intersystems.com/documentation/ISP/ISP-20171.pdf#ISP_platfor...) lists 'Ubuntu 16.04 LTS for x86-64*' as server platform, so maybe there should be separate kit for Ubuntu, not Suse one.
go to post Alexander Koblov · Jan 23, 2017 Hi Rich. If you open project in Atelier Explorer it's right below classes, routines and CSP files: http://docs.intersystems.com/atelier/latest/topic/com.intersys.eclipse.h... Conn605:USER in this particular sample
go to post Alexander Koblov · Jan 23, 2017 Try to open following URL in browser on the machine where the Atelier is installed: http://server:57772/api/atelier/ What does it return? Check in web applications settings that /api/atelier is enabled. Check in System Dashboard that you have enough license units. UPD: I modified URL to http://server:57772/api/atelier/
go to post Alexander Koblov · Jan 23, 2017 Hi Token. Yes, you need to specify expected namespace for tag CardData. Do you know what it should be? How do you generate this XML? Please provide small code sample. Do you have XML schema definition for CardData? If yes, please provide it.
go to post Alexander Koblov · Jan 23, 2017 Thomas, what version of Ubuntu do you have? What version of Caché do you install? Please check with "Supported Technologies Information" section of documentation for this Caché version. For example, Caché 2016.2.1 supports Ubuntu 16.04 x86-64 as development platform (http://docs.intersystems.com/documentation/ISP/ISP-20162.pdf#ISP_platfor...) Yes, you need to use Suse kit.
go to post Alexander Koblov · Jan 23, 2017 Locale enuw has RAW translation table for reading from files. Some other locales, for example rusw, has UTF8 translation table. So when reading UTF8 in enuw locale you need to specify translation table explicitly. Or have locale with default file translation table UTF8.
go to post Alexander Koblov · Jan 20, 2017 Thank you Stephen, that helps a lot. You have valueColumn defined: valueColumn="ID" "Each time the table is refreshed, in each row Zen tests this logical value against the actual value that appears in the valueColumn in that row. Zen selects any row(s) that contain value in valueColumn" http://docs.intersystems.com/cache20162/csp/docbook/DocBook.UI.Page.cls?... However no ID column in query. So value of every row is empty string, that matches value of table for every row, so last row is hightlighted. You need either remove valueColumn="ID" or add ID column to query. Regards, Alexander.
