All
Accepted answers
Virat Sharma · May 31, 2024 go to post

Awesome!

Do you have dashboard file for this example. If yes, please share the same.

Virat Sharma · Jan 26, 2023 go to post

Query Plan:

Relative cost = 21418093

Read master map SQLUser.RecordsMASTER, looping on id and ~{330}*10(qw).

For each row:

 Read master map SQLUser.Orders.Orders, using the given idkey value.
 Read master map SQLUser.OrderedBooksMASTER, using the given idkey value.
 Read master map SQLUser.BooksMASTER, using the given idkey value.
 Read master map SQLUser.OrderedRecordsMASTER, using the given idkey value.
 Output the row.

Index is on property qw and not on er

Virat Sharma · Jan 26, 2023 go to post

indices is qw (in both class) but not on er.

Not sure of %parallel mode. How does this work? is this something similar to running the job in background.

Virat Sharma · Jan 26, 2023 go to post

Query Plan:

Relative cost = 21418093

Read master map SQLUser.RecordsMASTER, looping on id and ~{330}*10(qw).

For each row:

 Read master map SQLUser.Orders.Orders, using the given idkey value.
 Read master map SQLUser.OrderedBooksMASTER, using the given idkey value.
 Read master map SQLUser.BooksMASTER, using the given idkey value.
 Read master map SQLUser.OrderedRecordsMASTER, using the given idkey value.
 Output the row.

Index is on property qw and not on er

Virat Sharma · Jan 26, 2023 go to post

Query Plan:

Relative cost = 21418093

Read master map SQLUser.RecordsMASTER, looping on id and ~{330}*10(qw).

For each row:

 Read master map SQLUser.Orders.Orders, using the given idkey value.
 Read master map SQLUser.OrderedBooksMASTER, using the given idkey value.
 Read master map SQLUser.BooksMASTER, using the given idkey value.
 Read master map SQLUser.OrderedRecordsMASTER, using the given idkey value.
 Output the row.

Index is on property qw and not on er

Virat Sharma · Jan 26, 2023 go to post

please consider these as typo while writing the query here. I have typed the correct one below

Records.asa

Books.id=Records.id

Books.id=OrderRecords.id

Virat Sharma · Jan 16, 2023 go to post

Hi Enrico,

Yes it's a cache table (but running query using inner join to get the data from multiple tables) .

Invoking query through  System Management Portal (in logical mode).

Virat Sharma · Sep 11, 2019 go to post

I tried to %Buildindices but it failed. Display Error method shows [Method not implemented].

##class(User.School).RollNoMarksExists(RollNo, Marks)

##class(User.School).RollNoMarksOpen(RollNo, Marks, , .sc)

I tried this above method but it is showing the below error.

Error #5002: Cache Error : <COMMAND>%Open+18^Library.Persistent.1

What does this mean??

Virat Sharma · Sep 11, 2019 go to post

##class(User.School).RollNoMarksExists(RollNo, Marks)

##class(User.School).RollNoMarksOpen(RollNo, Marks, , .sc)

I tried this above method but it is showing the below error.

Error #5002: Cache Error : <COMMAND>%Open+18^Library.Persistent.1

What does this mean??

Virat Sharma · Sep 11, 2019 go to post

I tried to %Buildindices but it failed. Display Error method shows [Method not implemented].

##class(User.School).RollNoMarksExists(RollNo, Marks)

##class(User.School).RollNoMarksOpen(RollNo, Marks, , .sc)

I tried this above method but it is showing the below error.

Error #5002: Cache Error : <COMMAND>%Open+18^Library.Persistent.1

What does this mean??

Virat Sharma · Mar 9, 2019 go to post

Thanks for the reply. This is only for the date i guess not timestamp, is there any direct command for this.

 But Now i want this way

I want the data between (2019-3-09 07:00:00.00 to 2019-3-09 10:00:00.00)

if task run at 10:00 am ( i will set End time : 2019-03-09 10:00:00 (with the help of above 3 commands) but how to set the start time which i need of 2019-03-09 07:00:00 means i have to go 3 hours before of current timestamp).

Also my property is type of %Timestamp only . Which command i can use to subtract the currenttimestamp with 3 hours .