Kinetic App Studio Layer location in database

Kinetic ERP
,
1

I am trying to locate Application Studio Layers in the Kinetic database.
My task is to go through our customizations and move from generic-ly named UD columns to new ones with meaningful names.
So, I must locate every reference to a handful of columns like [OrderHed].[ShortChar02]

Despite my best efforts I have no clue where to look.

Currently I leverage a BAQ to search BPMs for specific content.
Is there any way to do something similar for our custom layers?

The app layers is just one search.
The next place I need to update are dashboards, and then reports after that.
This is going to be fun.

2 Likes
2

I doubt the table that holds layer data is available to BAQ. There are many tables that a BAQ can not access.

Edit: Looks like it’s XXXDef

3

Think this should take care of most of your needs. (Thanks @jgiese.wci and @klincecum )

https://www.epiusers.help/t/findincode-db-baq-or-why-we-all-love-jgiese-wci/104658?u=evan_purdy

2 Likes
4

Table XXXDef has the goods, you want to parse XXXDef.Content which contains the raw json for layers. Iirc this is accessible from BAQ but certainly from efx. My dev tools dashboard can do a linq query for this lookup too.

4 Likes
5

Does it make your coffee yet? :laughing:

One tool to rule them all, and in the darkness . . .

1 Like
6

I had some suspicion it might be in there.
I have been poking around a little today.
Feels like a scavenger hunt.

1 Like
7

I use Epicor’s Task Agent to make my coffee! It makes every morning exciting. Sometimes, I get coffee. Sometimes, I don’t. Sometimes, another Customer is brewing a coffee and my coffee has to wait. Life is like a box of chocolates!

6 Likes
8

Or “Sorry your coffee machine is under maintenance, please wait for an all clear message before proceeding”

9

A long time ago, if I recall correctly they used to live in the filesystem…