发布新帖

查找

InterSystems 官方
· 二月 11, 2021

Advisory: Incomplete Query Results with ‘ORDER BY <row ID field> DESC’ – HealthShare

#提醒 #Health Connect #HealthShare #InterSystems 官方

February 11, 2021 – Advisory: Incomplete Query Results with ‘ORDER BY <row ID field> DESC’ – HealthShare

InterSystems has corrected a defect that can cause incomplete query results.  This defect affects the platforms underlying HealthShare and HealthShare Health Connect:

  • InterSystems IRIS and InterSystems IRIS for Health 2019.1.0, 2019.1.1, and 2020.1.0

See Alert: Incomplete Query Results with ‘ORDER BY <row ID field> DESC’ for further detail

Customers using HealthShare Personal Community should evaluate the number of proxy relationships they have established or removed. Customers that have established or removed proxy relationships more than 64,000 times are at risk for this defect.

Other than Personal Community, this defect does not affect query logic in the HealthShare or HealthShare Health Connect software.  However, Customers that have developed custom queries using the functions provided by InterSystems IRIS for Health, could be affected if they have the following HealthShare products and versions:

  • HealthShare 2019.2, 2020.1 and 2020.2
  • Health Connect 2019.1.0, 2019.1.1, 2020.1.0

A query can trigger the defect only if it meets all of the following conditions:

  • The query contains an ORDER BY clause sorting in descending (DESC) order.
  • The field used for that sorting is the table’s row ID.
  • The query contains conditions on multiple indexed fields.
  • The query selects data from only one table.

Users can modify an individual query to ensure correct results by replacing:

ORDER BY <row ID field> DESC

with

ORDER BY <row ID field>+0 DESC

The corrections for this defect are identified as DP-402745 and DP-403046 and will be included in all future product releases. They are also available via Ad hoc distribution from the InterSystems Worldwide Response Center (WRC).

This advisory is also on the InterSystems Product Alerts and Advisories page

If you have any questions regarding this advisory, please contact the Worldwide Response Center (WRC) at support@InterSystems.com or  +1.617.621.0700.

讨论 (0)0
登录或注册以继续
InterSystems 官方
· 二月 11, 2021

Alert: Incomplete Query Results with ‘ORDER BY <row ID field> DESC’

#提醒 #Health Connect #InterSystems IRIS #InterSystems IRIS for Health #InterSystems 官方

February 11, 2021 – Alert: Incomplete Query Results with ‘ORDER BY <row ID field> DESC’

InterSystems has corrected a defect that can cause incomplete query results. This defect affects:

  • InterSystems IRIS and InterSystems IRIS for Health 2019.1.0, 2019.1.1, 2019.2, 2019.3, 2019.4, 2020.1.0, 2020.2, and 2020.3
  • HealthShare Health Connect 2019.1.0, 2019.1.1, 2020.1.0
  • HealthShare Products 2019.2, 2020.1 and 2020.2

(In HealthShare and HealthShare Health Connect, this defect only affects Personal Community with 64,000 patient proxies and possibly customer-built custom queries. For more details on how this defect affects HealthShare, please see Advisory: Incomplete Query Results with ‘ORDER BY <row ID field> DESC’-HealthShare)

A query can trigger the defect only if it meets all of the following conditions:

  • The query contains an ORDER BY clause sorting in descending (DESC) order
  • The field used for that sorting is the table’s row ID
  • The query contains conditions on multiple indexed fields
  • The query selects data from only one table

You can modify an individual query to ensure correct results by replacing

ORDER BY <row ID field> DESC

with

ORDER BY <row ID field>+0 DESC

Note that some InterSystems search utilities, including the Interoperability Message Viewer, use queries that could be affected by this defect and cannot be edited. The only way to mitigate this defect system-wide is to install a version that includes the corrections.

The corrections for this defect are identified as DP-402745 and DP-403046 and will be included in all future product releases. They are also available via Ad hoc distribution from the InterSystems Worldwide Response Center (WRC).

If you have any questions regarding this alert, please contact the Worldwide Response Center.

讨论 (0)0
登录或注册以继续
问题
· 二月 3, 2021

Extracting last value in a repeating field

#数据转换语言（DTL） #Ensemble

Hi,

I have a PV1 repeating field that can contain multiple or a single value. I'd like to always pull the last value in the field but am not sure how to configure this in my DTL.

The repeating field is in PV1:50().1

Could somebody shed some light on this?

 

Examples:

|15081942~15081951~15108961~15280550|

|15081947|

|15081939~15081940|

 

Thanks

5 Comments
讨论 (5)2
登录或注册以继续
问题
· 二月 2, 2021

How do I pull a class from a connected IRIS server to my local machine using VSCode for editing?

#VSCode

Hi -

I know this is very "newby" of me, but here goes..

I have moved some classes onto my server, but these have never been in VSCode as edited files, and I'm just not finding the magic command or button or drop-down that says "pull this file from the server and make me a local copy to edit. I can see the class files on the server using the ObjectScript plugin - but I just can't find out where to make a local copy for editing

 

Thanks

2 Comments
讨论 (2)2
登录或注册以继续
公告
· 二月 2, 2021

Developer Community Release, January 2021

#版本 #开发者社区官方

Hi Developers!

This is a release of how did we improve the Developer Community in January 2021. The key features:

  • Twitter account support
  • New personal user profile page
  • New user posts page
  • New user replies page
  • New user followers page
  • New user following page

See the details below.

Twitter account support

Now you can add your Twitter account to your member profile. Go to your profile and click edit - there you will find an input field for a link to your Twitter account.  

New personal user profile page

With the new design, you can now see all the user's achievements on every user's page – User statistics block.

Add DC users to your favorites and subscribe to their activity, write Direct Messages in one click and see their pages on Open Exchange and other social networks.

New user posts page

When viewing a user's posts, you can filter them by post type.

New user replies page

From the replies page, you can now navigate to the post page where the reply was written and also easily view the user's accepted answers.

New user page of followers and following

And meet new features added when browsing your followers and following members. You can easily add them to your favorites, view their profile, or send them a message in one click.

Enjoy the new features!

And you are very welcome for new enhancement requests and bug reports.

Stay tuned!

2 Comments
讨论 (2)0
登录或注册以继续