Ben Langhinrichs

Photograph of Ben Langhinrichs

E-mail address - Ben Langhinrichs

Recent posts

Fri 3 Sep 2021

When Notes table data doesn't play nicely with others

Mon 21 Jun 2021

Custom Domino Extensions presentation

Thu 10 Jun 2021

Notes 12 without all the blue

June, 2022
   01 02 03 04
05 06 07 08 09 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30

Search the weblog

Genii Weblog

Delving deeper into your data - Intro

Fri 7 Jun 2019, 12:33 PM

by Ben Langhinrichs
We live in a data driven world, and finding the useful data means searching.. Google (aka Alphabet) is a hugely valuable company because they figured out how to offer better searching on data. When HCL/IBM wanted to reignite interest in Notes/Domino, one of their highly publicized new features was DQL, because it offers faster and better searches on data.
Yet, there are some searches on Domino data that are painfully hard to do or painfully slow to execute, For that reason, I wanted to do a series on how the Midas engine allows better, deeper searches into your data, and how it can harness DQL or other techniques to get at that data quickly and efficiently. Also, how the results can be delivered as JSON or XML or other formats, depending on what you need.
But rather than starting with a demo, I'm going to pose a few questions which will be addressed in the following posts.
1) How would I find all the product images in our offerings database that do not have corporate's dictated 1.91:1 aspect ratio or that are under 450 pixels wide?
2) How would I find all doclinks in our three sales dbs that point to our product db? Or the ones that don't?
3) How would I see what bullet point items we've used in the ten highest earning proposals? In the ten lowest earning?
4) Given our accessibility rules, which graphics in our four public-facing dbs have heights greater than 1 pixel but no alt text?
5) Are there any unredacted credit card numbers appear in our discussion and job posting databases? How about only in certain views?
6) Are there any zero size attachments in our discussion databases? Any greater than 10MG in size? How about greater than 4MG in size from before 2017?
Each of these should be answerable without writing a lot of code, ideally using a data-driven approach, and the results should be available in JSON or XML.
Inline GIF image

Copyright 2019 Genii Software Ltd.

What has been said:

No documents found

Have your say:

Name *:
e-mail addresses will not be displayed on this site
Comment *:

<HTML is not allowed>
Linking: Add links as {{http://xxx|title}}, and they will be activated once approved
Blocked? Unable to post a comment? Please read this for a possible explanation...