Hello everybody,
today I want to leave a post on how to change all emails, which are contained in Acumatica. For this purpose you may use script below:
UPDATE contact SET email = email + '.ts' UPDATE socontact SET email&...
Hello everybody,
today I want to leave a short note on how to use F-BQL version of PXSelect in Acumatica.
In past it was common to have this line of code in your graph:
public PXSelect<Student1> Students;
In new F-BQL introduced new construction, SeleftFrom. Proper way of using i...
Hello everybody,
here is just short post on how to download DAC Schema browser which I recently opensourced.
You'll need two steps:
1. Navigate in your browser to link https://github.com/YuriyZaletskyy/DacSchemaBrowser 2. Click on Star as displayed on screenshot (this is optional step):
&nb...
Hello everybody,
today I want to share single line of code, which I found recently while digging Acumatica source code with reflector. Sometime you may need to know if there is some or antoher Acumatica table available. For example if you create some customization plugin. How to find out if there...
Hello everybody,
Today I want to leave a short notice on how to call Cancel button of Acumatica from inside C# code:
graph.Clear();
That is it, Clear method is binded to button Cancel in Acumatica. Besides that Clear method will reload current data record from database and rolls back changes of C...
Hello everybody,
today I want to say a bit more about usage of attribute PXUIRequired as previous article on my blog wasn't very easy to follow by some of my readers.
Take a look on presented code sample:
public class sOOrderType : Constant<string>
{
public const&n...
Hi everybody,
today I want to give one more definition of Group by of SQL language which for me is very explanatory.
Group by statement produces a record for each unique combination of group by columns list and ommiting other columns of tables.
Also you can apply aggregate functions to other colu...
Hello everybody,
here I want to leave a short line on how to extend Perist method of your own graph.
I described once long time ago how to override Save action in your extension, but sometime it can be needed to override Persist in your own graph.
Sometime it can be necessary. Below goes sample o...
Hello everybody,
today I want to leave another post about internals of Acumatica, about which you may heard something like "Never try it at home". In another words, sometime you may need to do the following in Acumaitca:
Insert directly into database ( for this purpose I'd recommend you to use P...
Hello everybody,
today I want to write a few words with code samples on how to work with Screen based web API in Acumatica.
Stage preparation
Before you go, first step that is needed is to have Acumatica instance ready. So install Acumatica with sales demo database.
As mentioned in the titl...