search through bpm'online objects

How to Search Through Your bpm'online Objects

Our customers’ businesses are continuously evolving, and we, as the support team, are regularly enhancing customizations to support the evolution.

I recently reviewed some customizations to determine the impact of the changes on the overall data structure. It was necessary to start with a list of the bpm’online tables and fields relevant to the desired changes. However, extracting this information can be quite difficult, mainly because fields can be spread over multiple areas of functionality. I needed to get at a list of database objects(tables) that were related in some way to "Accounts" and involved custom "investment" related objects in bpm'online. The criteria for this list was:

  • The object name could be "Account"
  • The object name contained "Account" but had a prefix of "TAI" OR contained the word "Investment"
  • It should not contain the words "Tag", "Folder", "File" as these are auto created system objects that would not be impacted.

Here is what the filtering for that looked like in bpm’online:

sales velocity

Fortunately, we have an app that connects to bpm'online and could get me exactly what I needed without having to manually extract and comb through all the system data.

Once we defined what was needed and hit the “Apply” button, the system returned exactly what was necessary to tackle our customizations.

sales velocity

To document the information, I simply clicked on the "Export" button to create a csv file that I could instantly send out to my team.


Allen D'Souza's picture
Allen D'Souza
Senior CRM Consultant

Allen is a senior CRM consultant at Technology Advisors Inc. He spends most of his time designing solutions using InforCRM, StarfishETL, and SQLServer. He also specializes in data migrations from-and-to Microsoft Dynamics CRM and Allen has been involved in large implementations for prominent players in the real estate, telecom, manufacturing, and publishing industries. Prior to working at Technology Advisors, Allen worked as a Microsoft application developer in the Accounting space. Outside of work, he likes to meditate, play his guitar, and eat chocolate.

Related Articles

August 30, 2019

You can set up a gauge widget in bpm’online to track progress towards a goal in the Dashboards section, on the Dashboards within any other section, or on a record page. In this example, we will set up a widget on a new Dashboard tab in the Dashboards section.

Start by creating or editing the dashboard tab (or record page) where you want to add the gauge. Add a Gauge widget to the page or tab.

bpm'online new dashboard

August 28, 2019

There’s been a lot of buzz recently about low code, no code, and citizen developers. With all the pressures for faster development cycles, stronger tech support, and better business applications, it’s no wonder people are getting excited at the prospect of citizen developers.