go to post Evgeny Shvarov · Jul 21, 2016 Hi Greg!We do not support this type of posts anymore.Code packages should be placed as code snippets, gist or github repos. See details here.But thank you! We'll delete this artefact.
go to post Evgeny Shvarov · Jul 19, 2016 Hi Greg!Subscriptions are not ideal at this moment and we are working to make them better.Your suggestions are quite reasonable we'll try to introduce them to the subscription module soon.Thanks!
go to post Evgeny Shvarov · Jul 19, 2016 Hi, Greg!Thanks for the request! Yes, you are right. It's very helpful option and we have this task in our backlog.
go to post Evgeny Shvarov · Jul 18, 2016 Hi, Sergey! Thanks for the answer!Yes, it's the possible reason. But the problem also appears on Unicode installations too. See my answer below.
go to post Evgeny Shvarov · Jul 18, 2016 Hi, Randy! It's a known issue. The problem is that DSW(DeepSeeWeb) contains some unicode symbols in UI and they come from CSP Gateway in ISO 1859-1 codepage, which is not Unicode obviously. It happens because in your NLS scheme (I believe it is enuw) there is the default setting for non-CSP files that they should go in ISO 1859-1. While it is not fixed in the release, it is fixable two ways: 1. Copy index.html to index.csp and try to connect to it same way you do with index.html page. Symbols should go in Unicode now. 2. Write your current codepage setting in CSP Gateway for the files: zw ^%SYS("CSP","DefaultFileCharset") This setting should be "utf-8". If there is another setting, save it somewhere and change to "utf-8" So this should fix it: set ^%SYS("CSP","DefaultFileCharset")="utf-8"
go to post Evgeny Shvarov · Jul 14, 2016 Hi, Mike!There is no option to delete your own posts now. But you can unpublish them.
go to post Evgeny Shvarov · Jul 13, 2016 Hi, Rustam!A lot of Caché code parts (classes, mac and int routings, DFI's etc) are stored in the database itself, not in files. They should be exported some way to be presented in files.I see you have already the way to export classes, so I believe you can repeat similar code logic to export mac and int code part into the files in the same or another OS folder.
go to post Evgeny Shvarov · Jul 12, 2016 Sorry, Cheng Cheng!Got the idea now: you wanted Sum function for each Product Category, and Avg function for All Products in the same pivot)And this use case of IIF and LEVEL_NUMBER solves the task. Great! Thanks!
go to post Evgeny Shvarov · Jul 12, 2016 Hi, Cheng! Thank you for the explanation! Great use case, btw. Now it's more clear with your initial post. It would be great if you include Level_number in the query too to see what rows has different Level_number. Like this: WITH MEMBER measures.[with avg summary info] AS 'IIF(Product.CurrentMember.Properties("LEVEL_NUMBER") = 1, AVG(Product.[Product Category].Members, measures.[amount sold]), SUM(Product.[Product Category].Members, measures.[amount sold]))' MEMBER measures.[total count] AS 'SUM(Product.[Product Category].Members)' SELECT {Product.[Product Category].Members, [Product].[All Product]} ON 1, {Product.CurrentMember.Properties("LEVEL_NUMBER"),measures.[with avg summary info],measures.[total count]} ON 0 FROM Holefoods I suppose 'All Product' level should have the Sum of all Product levels. But in your example 'All product' lesser than 'Snack' for example.
go to post Evgeny Shvarov · Jul 11, 2016 One more hint from Russian forum:%GCMP - Compares two globals in the same or different namespace.
go to post Evgeny Shvarov · Jul 11, 2016 HI, Cheng! Thanks, great example!What is the "LEVEL_NUMBER"? Is it a kind of internal property?
go to post Evgeny Shvarov · Jul 11, 2016 That depends on property collation. For EXACT/ TRUNCATE/SQLSTRING collation, yes "val" should exactly match the value of the property (compared part of the value), case sensitive. For SQLUPPER - no.Should I see this collation setting in Index or in property definition? And what is the default setting - SQLUPPER?
go to post Evgeny Shvarov · Jul 7, 2016 Thank you, Benjamin!It is still so much to work to make email notifications really helpful.We'll try to fix the issues in some next releases.
go to post Evgeny Shvarov · Jul 7, 2016 Thank you, Eduard. We plan to add Member Collaboration page with posts and comments and I think this page will be changed to the link of Member's collaboration of yourself and will go with pagination.So it will be fixed in some next releases.
go to post Evgeny Shvarov · Jul 6, 2016 ClassMethod PropertyGetStored(id) For datatype properties this method returns their logical value, for object properties, it returns the id. It’s a wrapped global reference to the class data global and the fastest way to retrieve the singular property value. This method is only available for stored properties. Eduard, you say it's the fastest way to take the value. Did you measure it?
go to post Evgeny Shvarov · Jul 6, 2016 The interesting question would be - why not traverse index global to get id instead of using SQL?Really good question...Another question what is the sense to check "val" for IS NULL for Unique Index?So, "val" should exactly match the value of property, case sensitive?
