So why cant @hmwillett just use that instead of the BO?
1 Like
They explain why they have that table.
3 Likes
Wellllll fine.
#UnjustifiedRant. 
4 Likes
When I need to find a field, I use the Help File that @hkeric.wci (I think?) made. You can use it like a searchable data dictionary
4 Likes
What happened to “you’ll just know!”… sigh
So DB structures are like porn?
“Hard to define, but you know it when you see it”
2 Likes
I plead the fifth.
3 Likes
1 Like
2 Likes
Shame, indeed. I was even at your Insights presentation. LOL
4 Likes
I think you can also go blind looking at them…
2 Likes
Another thing I do is I have installed CMDER on the Server then I can grep server binary files and then I know which ones to use .NET Reflector or on the Client.
Example - Client Side Only:
What it indicates is that there is a Method, Class or String matchin the text
Lets search for an Error or Warning String
Lets see who has something with Negative*Quantity
Lets see who has something with OrderHed.PONum within the Client Adapters/UIApps etc…
It helps knowing which DLL to .NET Reflect on or JustDecompile.
You can also map the UNC Path of Server Assemblies to a Drive Letter and use it from your PC. By the way grep is FAST and I mean fast, once it caches your directory you get instant results.
6 Likes
Just download cmder full version, extract it to C:\cmder then run it and pin it to your taskbar and that should become your new command prompt. You can also do Powershell in it, also it will remember your history of commands if you use arrow key up. It has a few binaries like curl, grep, tail, less, find, cat, ls, git… you can always add more into the C:\cmder\bin folder.
2 Likes
Does the grep support regex expressions.
(And yes, I know saying “expression” after regex, is like saying “LCD Display”)
Yes its exact linux replica, its even as fast and you can grep 100 1gb files easily and fast, has alot of flags.
I also use it for my coding projects, or for example to find that one BPM I exported that contains something.
2 Likes
Im going to have to give this a look. I’ve got a 1.2 GB XML that I need to extract particular branches from. There could several hundred thousand of these branches. And my text editor that supports files that big, doesn’t support mult-line regex 
Can I use redirection to direct the output to a new file? Like: the pseudo command:
grep "<tag-abc>(.*?)</tag-abc>" file.xml >> tag1.xml
Edit: assuming I use the appropriate switches to get just the matching text returned
1 Like
I also use it during ERP Administration to grep ServerLogs for “fatal, exception” You can also add -A and -B to also show you before and after lines.
// once you find a result show me also the 2 lines after and 2 lines before.
grep -ri -A2 -B2 "exception" *
1 Like