Posts by Neerav Verma on InterSystems Developer Community

Question

Neerav Verma · May 10, 2019

Adding Parameter to FilterQuery

In our table, we have a column cities, which has a filter which displays the cities of a state depending on the state

For simplicity let's assume we have a page

Property State As %String = "CA"

Our filter should run this query to show all cities of state ca

#ZEN #Caché

0 9

0 491

Question

Neerav Verma · Apr 12, 2019

Method Performance Statistics

Hello All,

There are few tools for SQL optimization available and even query builder has Show Plan to give us an estimation of the resources needed to execute.

For Methods - Is there anything similar ??

I would like to see a similar approach as to the time taken for method to execute.

Is Studio Debugger only option ??

#Caché

0 2

0 346

Question

Neerav Verma · Mar 26, 2019

Iterating Ens.Request to create a JSON

Let's say we have a class

AbcRequest extends Ens.Request, PropertiesBaseAbstractClass(has all my properties common to all request)

Prop1

Prop2 and so on

Now in my Business Operation

I want to make a json dynamically from this request.

Yes obviously I can do is

Set requestDefinition = ##class(%Library.CompiledClass).%OpenId("MyCreateRequest")
Set JsonObject = ##class(%DynamicObject).%New()

#Caché #Ensemble

0 3

0 361

Announcement

Neerav Verma · Mar 15, 2019

Intersystems Technologies : Connect with fellow individuals

Hello All,

I have been associated with Intersystems technologies for over a decade working on Cache, Zen, Ensemble etc.

This is a very niche field and a lovely community. I wanted to extend my hands to connect with people who are of same field or related to it.

Here is my linkedin profile. Pls feel free to send me an invite or drop me a message

https://www.linkedin.com/in/vneerav/

#Other

0 3

0 259

Question

Neerav Verma · Mar 5, 2019

PrimaryKey vs Idkey

Just wondering an Insight in the difference between these two indexes

IdKey / PrimaryKey
=================

Property Identifier As %Integer

Index Index1 on Identifier [Idkey]

Index Index2 on Identifier [PrimaryKey]

What's the difference?

1. If I don't have Index1 and only have Index2, then cache does still make its own id.
So how and why do I ever use the PrimaryKey. In Joins ??

#Data Model #Indexing #SQL #Caché

1 4

0 1.1K

Question

Neerav Verma · Mar 2, 2019

Parent/Child Vs One/Many

Just curious to know about the pros and cons of Parent/Child Vs One/Many.

We do use a bit of both.
One big reason we use Parent child is we feel if we delete one global, it gets rid of all child data too and all parent child data is stored in one global. Much easier to manage.

#Data Model #Caché

0 4

0 803

Announcement

Neerav Verma · Feb 21, 2019

Creating JSON From SQL

1. Define Persistent Class
Call utility class to fetch json via query.

Class Test.JSONFromSQL Extends (%Persistent, %Populate)
{

#JSON #SQL #Caché

0 1

0 357

Question

Neerav Verma · Feb 1, 2019

DeepSee passing Filters in Dashboard URL

-- We have our Pivot ready for some data for all accounts. And we want to now filter it by Account

[Account].[H1].Account.&[1]

It works fine at the pivot level and it filters the records. We save the pivot with no filter values as we want users to decide the Account they want to filter for

-Now If i save this pivot without a value of a filter , then obviously it has all records and I want to filter it at the Dashboard level on my page.

URL I am passing

#InterSystems IRIS BI (DeepSee)

0 2

0 258

Question

Neerav Verma · Jan 4, 2019

AWS SES (Simple Email Service)

I am just curious if someone has used this service to send Alert emails through AWS / Ensemble

I have verified 2 email ids - One to send. One to receive

Have also configured an access key for the email smtp server and added the credential to ensemble

but I get this error