All
Accepted answers
Neerav Verma · Feb 17, 2020 go to post

Hi Eduard,

The query is not a problem as the same query runs fine when we run on sql browser via smp. 

There is one flow with two threads

1. Goes and calls a workflow operation , thus creating the workflow task response etc.

2. Hang (Delay in BPL) for few seconds and then calls the query with session. And this query gives null result. But same query with same parameters runs fine in sql browser.

We are going to open the task request object with the id and persist its values for audit trail / historical data / reporting (it will be a mix of task request / response values + lot of others). As long as we get the TaskRequest ID we are good

May be is there a simple example with just one flow, 2 sequences as explained above? 

Neerav Verma · Feb 13, 2020 go to post

In condition if you type

Document. 

 (Don't miss the period) 

It should show you list of all your request properties to choose from.

Neerav Verma · Feb 12, 2020 go to post

On that note, I had one question.

ForceSyncSend is true.

Let's say I have 2 transform & send in one rule. If first transform is successful and sends to first target and that target returns a false in a response status property as 0 - Can we stop all next sends to not do anything depending on the response or should the first target throw an exception instead of sending 0 in a response property. 

Neerav Verma · Feb 12, 2020 go to post

Hi James,

You must have seen the documentation of rules, they are not supposed to handle responses. They are only there to "ROUTE". Responses need to be handled in BP's 

Neerav Verma · Feb 12, 2020 go to post

Hey Jeffrey, In routing engine if you say Yes to - Force Sync Send this could be avoided, isn't it?

Neerav Verma · Feb 12, 2020 go to post

From a sql inbound adapter, if you call a hl7 routing engine, it will get the request message you set it up in your service, but not hl7 which has DocType. As marc said ,you need to user the general routing engine and check for properties of your request class there.

Neerav Verma · Feb 12, 2020 go to post

System Administration - Security - SSL/TLS Configurations.

Have you made a configuration for your service?

Neerav Verma · Feb 12, 2020 go to post

In the routing engine, you can transform and send one message to as many transformations and targets you want to.

Neerav Verma · Feb 5, 2020 go to post

What a beautiful piece of work and I can see the amount of effort put into it.

I read 25% of it and then lost track.  Let me ask a few questions to understand where are we going with it.

1. Is it only AI specific or does it imply on our day to day implications as well.

2. Eg for time, we try to store UTC time so everything is generalized but is there any other dimension eg weight, currency, length which has such a standard which is universal for eg there is not UW (Universal Weight ) . We can't even say Universal Kilogram or Pound.  Only with time all speak in hours and seconds but nothing else. so how do we solve it??

Neerav Verma · Feb 4, 2020 go to post

Hi Henrique,

Does jasper reports run one time or is it real time.

What I intend to have is a real time report embedded in the zen page.  not a pdf. i mean a downloaded pdf may be a plus, but not the endpoint

Any thoughts?

Neerav Verma · Feb 4, 2020 go to post

hahaha exactly.  this single alphabet codes goes top of my head. need extra cups of coffee when debugging a code like that. Meant only for the masters. 

Neerav Verma · Feb 4, 2020 go to post

HI Eduard, I always felt PostConditionals are just plain confusing.  It can easily be argued that it's one line and simple but in my personal opinion I would rather use an if / else with braces with proper indentation. We are not living in mumps time, so do have the luxury of having some extra spaces and tabs.

Neerav Verma · Feb 4, 2020 go to post

I am bit late in the thread but still may be worth it to answer

- I use it always from the SQL Browser. 

I did had a post about it too on DC a week or two back, asking how relevant those plans and answers I got were that the plans are not super relevant, what matters most is the response time. 
Feedback : What I would love to have from these plans is also a suggestion, how you get in db2 / oracle etc telling us what indexes or improvements in query we can make to make the performance better. 
alternate plans - yes, i know it exists.  only when i feel the query is super slow, i actually go and take a look at it. not otherwise

if the alternate plan button was right there  next to show plan, it will be used more.  Infact all the sql optimization tools should be next to the query window on sql browser. that's where it belongs.

Neerav Verma · Feb 4, 2020 go to post

HI, have you considered making a stored procedure that gets called to display the list ??

Neerav Verma · Jan 17, 2020 go to post

Thanks @Evgeny Shvarov 
With deepsee web it seems there should be least amount of learning as I assume, it should be pretty much same as the deepsee now.

Will it be a smooth transition from current to new version?

Can I incorporate it in the zen app?

There is a Windows version to it right?

Neerav Verma · Jan 16, 2020 go to post

For this current one the execution in both cases is almost same . 

Both are .05 ms
That's what made me thinking that 99% difference in relative cost should have had at least 50% impact on time.

Neerav Verma · Dec 25, 2019 go to post

Merry Christmas dear friend.

You have been a great help over the years.

Wishing you great success and joy 

Neerav Verma · Dec 20, 2019 go to post

Good article and post.

If I understand it correctly, this is the server side of building rest service for CRUD activity.

Is there an article that explains the UI side of it?

What I be keen would be  Cache/IRIS independent UI solution connecting to this Rest Service.  So if cache was turned off and that service was routed to something else, it should still work.

Neerav Verma · Dec 20, 2019 go to post

Hi,

Do we have to buy DevExtreme licence and download their executable for it?

Neerav Verma · Dec 19, 2019 go to post

Hi Henrique,

This looks really good.

Before I dive further into your post, may I ask just one or two simple questions

1. Is the only connection to cache here is the Rest Services ?

For eg. if I replace the cache rest url and replace it with another one.. which is sending exactly same data . will it work?

2. Do we need to install something on the system for the same ?

3.  Do your files have an extension of .html or something else?
4. Is it correct to say that there is no Angular or node.js involved??

Many thanks

Neerav Verma · Dec 19, 2019 go to post

Hi Udo,

I had never heard of Typo3 before today. It seems good but I think a more known tool would be more acceptable in the organization.

Aim of app is to present data in a well formatted manner internally within the organization with the ability to do some simple updates

Thanks

Neerav Verma · Dec 19, 2019 go to post

Do we need to have a .csp or .zen to make this work ??

What if I  want to have a webapp totally out of Cache , with cache just being the data provider via sql or rest.

Thanks

Neerav Verma · Dec 19, 2019 go to post

HI,

I still haven't read the article but I will first thing tomorrow in detail.

Is there any node.js used to fetch the data???

Is any bootstrap involved too to beautify it??

Neerav Verma · Dec 19, 2019 go to post

Hey Benjamin

For starters even 50,000 rows of data displayed , searchable and paginated would be good enough. Can always build on that 

Do you have any sample where I can build upon?

Neerav Verma · Dec 16, 2019 go to post

When you make a system dsn for intersystems cache type and press test connection. Does it succeed?

Neerav Verma · Dec 15, 2019 go to post

Thanks Anil,

One question before I give this a try

Your method MyPackage.MyClass.GetDetails()
Is this returning a result set with some query eg Select col1, col2 from TAble1??

Neerav Verma · Dec 12, 2019 go to post

Hi Timothy, do you have any sample code that you can share?

How much data were you loading in your tables