Posts Tagged ‘query’

Amazing how these two play so well together! XM Cloud Components app brings a new revolutionary approach to building your pixel-perfect UI, with a rich toolset that covers almost any needs. With a Datasource feature, it can consume data structures of any complexity and so easily map fields from it to your bespoke front end. […]

In D & A Projects, building efficient SQL Queries is critical to achieving the Extraction and Load Batch cycles to complete faster and to meet the desired SLAs. The below observations are towards following the approaches to ensure writing SQL queries that meet the Best Practices to facilitate performance improvements. Tuning Approach Pre-Requisite Checks Before […]

Spring boot with ES Java API Client to Build and Execute Queries in Elasticsearch. Prerequisites: Knowledge in Java, Spring boot, Elasticsearch, Kibana. Concept: The purpose of this blog is to present an idea for connecting, constructing queries, and querying Elasticsearch through Java applications. What is Elasticsearch? Elasticsearch is a distributed, free and open search and […]

When integrating an on-premise system like an E-Business Suite application with an Oracle Enterprise Performance Management Cloud application, SQL queries can be used as means to extract the data from the source database. You can extract the data and then load the data directly to the EPM Cloud applications using the EPM Integration Agent. The EPM Integration Agent […]

As I continue my series on Maximo Data Loading, I move to another tool I have turned to many times, the Maximo MXLoader. This was developed by Bruno Portaluri while he was at IBM. As of February 2018, he is no longer with IBM, but his tool still holds a lot of value and is […]

In my last post on public queries, I talked about problems with some of the current setups of Maximo users public query management. As a Maximo system administrator, there are ways to manage this, but user training is often the number one way to get his right. Teach them to not use the Public Query […]

It’s happened in more places and implementations than I can count. A client uses Maximo, and a user, we’ll call him Bob, comes up with some great and useful queries. The easiest way to share it? Make it PUBLIC! This is great that Bob can share the query with everyone that uses Maximo. And then […]

Recently I’ve been working a lot with the Sitecore Content Search API and found myself writing a lot of code like this: var allTheThings = context.GetQueryable<Thing>().Where(x => x.TemplateId == Constants.Thing.TemplateId && x.IsSearchable); As we’re always looking for better ways to do things around here and my laziness started to prevail, I thought, “there has got […]

In my earlier post, User Admin Console (Classic UI) & Crashing Browsers, I discussed how business analysts and administrators can make use of queries to debug user and group-related issues in AEM. In relation to that topic, I noticed we have a business requirement to add users to AEM, but we do not have a requirement to remove users […]

I believe there is still use for the good old Query.SelectItems. You can do a lot with the content search API and you can do it a lot faster no doubt, but there are cases where you might still decide to use the good old Query. Anyway, even if only to have some fun exploring, […]