查找

Article
· Nov 7 8m read

Understanding SQL Window Functions

Window functions in InterSystems IRIS let you perform powerful analytics — like running totals, rankings, and moving averages — directly in SQL.
They operate over a "window" of rows related to the current row, without collapsing results like GROUP BY.
This means you can write cleaner, faster, and more maintainable queries — no loops, no joins, no temp tables.

In this article let's understand the mechanics of window functions by addressing some common data analisys tasks.

Discussion (0)1
Log in or sign up to continue
Question
· Nov 7

Try catch throwing error not actually throwing error to DTL in test or when run via router

Trying to check date in DTL. 

Want to throw a custom error not the default one from the $ZDTH. It does in the try as will write "Error" when testing the DTL but the actual error not showing. Report errors is turned on.  I also tried the THROW logic from best practices but that doesn't work either. $SYSTEM.Status.DisplayError(status) does display what the error should be returned. 

 try 
 {
    set tDateH = $ZDATEH(tDateofDeath, 8)
 }
 catch ex 
 { 
  w "error"
 set status = $$$ERROR($$$GeneralError,"Custom error message")
 do $SYSTEM.Status.DisplayError(status)
 do $System.Status.DecomposeStatus(status)  
    quit  
 }
5 new Comments
Discussion (5)3
Log in or sign up to continue
Announcement
· Nov 7

Concours InterSystems « Réalisation des idées » 2025

Bonjour les développeurs,

Suite au succès retentissant du concours de l'année dernière, nous avons décidé de le renouveler. Bienvenue au

🏆 Concours « Réalisation des idées » 🏆

Soumettez une application mettant en œuvre une idée issue du portail InterSystems Ideas, ayant le statut Community Opportunity ou Future Consideration, créée avant la publication de cette annonce et nécessitant une programmation 😉

Durée : 17 novembre - 7 décembre 2025

Prix : $12,000$


Le sujet

Dans ce concours, nous attendons des applications qui mettent en œuvre n'importe quelle idée de votre choix issue du portail d'idées InterSystems et dont le statut est Opportunité communautaire ou Considération future, créée avant la publication de cette annonce.

Exigences générales :

  1. L'application ou la bibliothèque doit être entièrement fonctionnelle et originale. Il ne peut s'agir d'une simple importation ni d'une interface directe avec une bibliothèque existante écrite dans un autre langage (à l'exception du C++, où la création d'une interface IRIS nécessite un travail important). Elle ne doit pas être un copier-coller d'un projet existant ni inclure de code propriétaire. Elle ne peut pas utiliser les résultats de la rétro-ingénierie des produits d'InterSystems ni ceux de toute autre société. Veuillez consulter nos Conditions d'utilisation.
  2. Applications acceptées : nouvelles applications Open Exchange. Notre équipe examinera toutes les candidatures avant de les approuver pour le concours.
  3. L'application doit fonctionner soit sur IRIS Community Edition, soit sur IRIS for Health Community Edition. Les deux peuvent être téléchargés en tant que versions hôtes (Mac, Windows) à partir du site d'évaluation, ou peuvent être utilisés sous la forme de conteneurs extraits d'InterSystems Container Registry ou de Community Containers : intersystemsdc/iris-community:latest ou intersystemsdc/irishealth-community:latest .
  4. L'application doit être Open Source et publiée sur GitHub u GitLab.
  5. Le fichier README de l'application doit être en anglais, contenir le lien pour l'idée, les étapes d'installation, et soit la vidéo de démonstration ou/et une description du fonctionnement de l'application.
  6. Pas plus de 3 soumissions d’un développeur sont autorisées.

N.B. Nos experts auront le dernier mot quant à l'approbation ou non de la candidature au concours en fonction des critères de complexité et d'utilité. Leur décision est définitive et sans appel.

Prix ​​du concours :

1. Nomination des experts – les gagnants seront sélectionnés par l'équipe d'experts d'InterSystems :

🥇 1ère place - $5,000
🥈 2e place - $2,500
🥉 3e place - $1,000
🏅 4e place - $500
🏅 5e place - $300
🌟 6-10e places - $100

2. Gagnants de la communauté – candidatures qui recevront le plus de votes au total :

🥇 1ère place - $1,000 
🥈 2e place - $600
🥉 3e place - $300
🏅 4e place - $200
🏅 5e place - $100

❗ Si plusieurs participants obtiennent le même nombre de votes, ils sont tous déclarés gagnants et le prix est partagé entre eux.

❗ Les prix en espèces ne sont attribués qu'aux personnes pouvant justifier de leur identité. En cas de doute, les organisateurs contacteront le ou les participants pour obtenir des informations complémentaires.

 

Qui peut participer ?

Tout membre de la communauté de développeurs, à l'exception des employés d'InterSystems (sous-traitants ISC autorisés). Créer un compte !

Les développeurs peuvent s'associer pour créer une application collaborative. Autorisé de 2 à 5 développeurs dans une équipe.

N'oubliez pas de mettre en évidence les membres de votre équipe dans le README de votre application – profils d'utilisateurs DC.

Délais importants :

🛠 Phase de développement et d'inscription de l'application :

  • 17 novembre 2025 (00:00 EST): le concours commence.
  • 30 novembre 2025 (23:59 EST): la date limite de soumission.

 Période de vote:

  • 1 décembre 2024 (00:00 EST): le vote commence.
  • 7 décembre 2024 (23:59 EST): le vote se termine.

Remarque : Les développeurs peuvent améliorer leurs applications tout au long de la période d'inscription et de vote.

    Ressources utiles :

    ✓ Exemples d'applications et de bibliothèques :

    ✓ Modèles que nous vous suggérons de commencer par :

    ✓ Pour les débutants avec IRIS :

    ✓ Pour les débutants avec ObjectScript Package Manager (IPM) :

    ✓ Comment soumettre votre application au concours :

    Besoin d'aide ?

    Rejoignez la chaîne du concours sur le serveur Discord d'InterSystems ou discutez avec nous dans les commentaires de ce post.

    Nous avons hâte de voir vos projets! Bonne chance 👍


    En participant à ce concours, vous acceptez les conditions énoncées ici. Veuillez les lire attentivement avant de continuer.

     
     
    Discussion (0)1
    Log in or sign up to continue
    Question
    · Nov 7

    CCNP Certification Training | Cisco Certified Network Professional Course

    The CCNP Certification Training is designed for IT professionals who want to advance their careers in networking by mastering Cisco technologies and solutions. This program builds on foundational networking skills and provides hands-on experience in planning, implementing, and troubleshooting complex network infrastructures. Earning the Cisco Certified Network Professional (CCNP) credential demonstrates your ability to manage enterprise networks and positions you for high-level networking roles across industries.

    What is CCNP Certification?

    The Cisco Certified Network Professional (CCNP) certification validates advanced knowledge and skills in network implementation, security, automation, and troubleshooting. It is an industry-recognized credential offered by Cisco, one of the global leaders in networking solutions. This certification is ideal for professionals who have already achieved the CCNA (Cisco Certified Network Associate) certification or have equivalent networking experience.

    Why Choose CCNP Certification?

    Networking is the backbone of today’s digital world, and organizations rely on skilled professionals to maintain reliable and secure systems. The CCNP certification not only boosts your technical expertise but also enhances your credibility and career prospects. With this certification, you can qualify for roles such as Network Engineer, Systems Engineer, Network Administrator, IT Manager, and more. Cisco-certified professionals are highly valued by employers worldwide for their proven ability to manage complex network systems efficiently.

    Key Learning Objectives

    Through this training, learners will gain a deep understanding of advanced Cisco networking concepts, including:

    • Configuring and managing enterprise-level routing and switching
    • Implementing security, automation, and programmable networks
    • Troubleshooting complex network environments
    • Working with scalable and secure infrastructures
    • Applying advanced problem-solving and diagnostic techniques

    The course combines theoretical knowledge with practical lab sessions to ensure real-world application of skills.

    Who Should Enroll?

    This certification training is ideal for:

    • Networking professionals aiming to upgrade from CCNA to CCNP
    • IT administrators, support engineers, and network specialists
    • Professionals seeking global recognition in network management
    • Individuals preparing for the Cisco CCNP Enterprise exam

    Benefits of CCNP Certification

    • Global recognition as a certified networking expert
    • Hands-on experience with Cisco’s latest networking tools and technologies
    • Career advancement opportunities in top IT and telecom companies
    • Improved earning potential and professional credibility
    • Strong foundation for pursuing advanced Cisco certifications like CCIE

    Course Format

    The CCNP training is available both online and classroom-based, offering flexibility for working professionals. It includes interactive sessions, live labs, instructor-led modules, and exam preparation guidance. Learners can practice real-world scenarios using Cisco devices and simulators to build confidence and competence.

    Conclusion

    The CCNP Certification Training empowers you with the expertise to design, operate, and troubleshoot complex network infrastructures. Whether you’re seeking career growth, professional credibility, or advanced technical knowledge, this course provides the skills needed to excel in the ever-evolving networking industry. 

    Get certified with Sprintzeal

    Discussion (0)1
    Log in or sign up to continue
    Question
    · Nov 7

    Explore Ksubi’s 2025 Collection: Jeans, Jackets & More

     

    In the fast-paced world of fashion, where trends come and go overnight, Ksubi remains an unshakable icon of street culture and individuality. Known for its rebellious aesthetic and artful imperfection, Ksubi has built a global following that spans from runways to city streets. From its cult-favorite Ksubi jeans to its bold Ksubi shorts and effortlessly stylish Ksubi skirt, the brand continues to shape modern streetwear with a fearless attitude.

    The Story Behind Ksubi

    Ksubi was founded in 1999 by a group of creative Australian surfers—Dan Single, George Gorrow, and Gareth Moody—who were frustrated by the lack of well-fitting, unique jeans in the market. Rather than follow trends, they decided to create their own. This DIY attitude gave birth to Ksubi, a label that rejected conformity and embraced self-expression.

    The brand’s early runway shows were legendary for their shock value—like the one where models released live rats on stage, making headlines across Australia. But behind the theatrics was real innovation. https://ksubijean.com brought a raw, authentic approach to denim that stood out in a world dominated by polished, mass-produced fashion.

    The Signature Look of Ksubi

    Ksubi’s aesthetic is unmistakable—distressed denim, bold stitching, graffiti-inspired prints, and its iconic cross logo (two small plus signs). Every design feels intentionally imperfect, reflecting a sense of lived-in authenticity. The brand’s creative direction often blurs the line between fashion and art, with collections that push boundaries without losing wearability.

    Ksubi Jeans: The Core of the Brand

    The foundation of Ksubi’s identity lies in its Ksubi jeans. Over the years, they’ve become a symbol of youth rebellion and street-style coolness. Made from premium denim, each pair is carefully washed, faded, and distressed to achieve a one-of-a-kind finish.

    Popular styles like the Chitch, Van Winkle, Playback, and Hi N Wasted are designed to suit different fits and aesthetics. Whether you prefer slim silhouettes, relaxed cuts, or high-rise fits, Ksubi jeans deliver comfort without sacrificing edge.

    What truly sets them apart is their detailing—signature cross embroidery, branded hardware, and raw hems that evolve beautifully over time. These jeans don’t just fit your body; they adapt to your lifestyle.

    Celebrities such as Travis Scott, Kendall Jenner, and A$AP Rocky have all embraced Ksubi jeans, cementing the brand’s reputation in both streetwear and luxury fashion circles.

    Ksubi Shorts: The Perfect Blend of Casual and Cool

    When temperatures rise, Ksubi shorts take the spotlight. Crafted with the same attention to detail as their jeans, these shorts feature distressed finishes, ripped hems, and relaxed cuts that give off an effortlessly stylish vibe.

    For men, Ksubi shorts often come in faded denim and longer silhouettes, ideal for pairing with graphic tees or oversized hoodies. Women’s styles, on the other hand, include high-waisted cuts, frayed edges, and signature logo embroidery for a laid-back yet confident look.

    Whether you’re hitting the beach, heading to a festival, or just chilling in the city, Ksubi shorts provide the perfect mix of comfort and attitude.

    Ksubi Skirt: Denim with a Feminine Edge

    The Ksubi skirt perfectly captures the brand’s rebellious femininity. Unlike traditional denim skirts, these pieces feature edgy details—uneven hems, distressing, and subtle branding that make each skirt unique.

    The Ksubi skirt can be styled in countless ways: paired with a crop top for a night out, an oversized sweatshirt for casual cool, or a leather jacket for a rocker-inspired outfit. Its versatility makes it a must-have for anyone who wants to bring a bit of rebellion into their wardrobe without losing their sense of style.

    Ksubi’s Influence on Global Streetwear

    Ksubi isn’t just a clothing brand—it’s a cultural movement. The label has a deep connection to music, art, and youth subcultures. Collaborations with icons like Travis Scott, Juice WRLD, and The Weeknd have expanded Ksubi’s influence beyond fashion, turning it into a staple in the hip-hop and streetwear scenes.

    Its ability to bridge high fashion and street style has earned Ksubi a devoted following worldwide. From Los Angeles to Tokyo, fashion lovers recognize the distinctive aesthetic that Ksubi brings to denim.

    The Ksubi Design Philosophy

    At its core, Ksubi celebrates imperfection. Instead of chasing trends or seasonal fads, the brand focuses on creating timeless pieces with character. Each rip, fade, and patch tells a story—an intentional departure from the overly polished aesthetics of mainstream fashion.

    This design philosophy extends beyond denim. Ksubi’s collections often include oversized graphic tees, jackets, and hoodies, all carrying the same attitude of defiance and authenticity. The message is clear: fashion should be personal, expressive, and unapologetic.

    Why Ksubi Continues to Stand Out

    In a market filled with denim brands, Ksubi remains distinctive because it refuses to compromise its identity. The brand’s attention to detail, premium materials, and cultural relevance have helped it stay ahead of the curve.

    While others mass-produce for the sake of trends, Ksubi builds its collections around craftsmanship and attitude. The result? Clothing that feels alive—each piece carrying the essence of individuality.

    Styling Ksubi: From Street to Runway

    What makes Ksubi especially versatile is its adaptability across styles. Pair Ksubi jeans with a vintage tee and sneakers for a relaxed street look, or dress them up with a tailored blazer and boots for a more polished edge.

    For women, a Ksubi skirt styled with an oversized hoodie or leather jacket creates a perfect balance of bold and chic. And Ksubi shorts are your go-to for effortless summer fits—just add a cropped tank and chunky sneakers.

    Every piece encourages creativity, allowing you to mix and match while keeping that unmistakable Ksubi edge.

    The Future of Ksubi

    As streetwear continues to dominate global fashion, Ksubi’s influence only grows stronger. The brand has expanded its reach with flagship stores in major cities and continues to collaborate with creative talents who embody its rebellious energy.

    Looking ahead, Ksubi’s mission remains the same—to challenge the ordinary and redefine how people wear denim. With every new collection, it proves that authenticity never goes out of style.

    Final Thoughts

    Ksubi is more than just a label; it’s a statement of independence. Its collections—from the iconic Ksubi jeans to the versatile Ksubi shorts and edgy Ksubi skirt—speak to those who dare to express themselves boldly.

    Rooted in rebellion yet refined in craftsmanship, Ksubi continues to lead the charge in modern streetwear. It’s not about following trends—it’s about setting them. And that’s what makes Ksubi a true legend in the world of denim.

    Discussion (0)1
    Log in or sign up to continue