Hello there : i have found a way to get the top most account of a given child account (i have created a sqlserver function) but now, i want to execute that sql script from my clientmodule : SELECT * FROM fnGetMasterAccount("<child account id>")
How can i execute it and get the record obtained from ExtJS client module (ESQ?) ?
The passwords are stored encrypted in the SysAdminUnit table. You can directly change the password through the database only if you know its hash. The simple sql query would look like this:
update SysAdminUnit set UserPassword = 'your_hash'
where name = 'Supervisor'
In case you do not have access to the admin user and need to reset the password I would recommend you to contact the system administrator or a support team.
Please check the instructions on how to work with collections within [Read data element]. This will help you to implement your own process.
Algorithm of the work with a collection from Read data:
1.Disable the formula validator in business process designer. You can open the console and execute the following script for that:
var featureCode = "UseProcessFormulaServerValidation";
require(["FeatureServiceRequest"], function() {
var featureRequest = Ext.create("Terrasoft.FeatureServiceRequest", {code: featureCode});
featureRequest.updateFeatureState({
forAllUsers: true,
state: Terrasoft.FeatureState.DISABLED // ENABLED
}, ()=>console.log("Done"));
});
2. In [Read data] element go to extended options and tick:
Read first = true
Number of records to read = 100 //Number of records available in a collection.
3. Create a process parameter with EntityCollection type and map it to the resulting collection of [Read data]. This parameter does not exist out of the box, but you can create it manually.
Example:
[#MyRead.Resulting collection#]
* MyRead – [Read data] element header.
* Resulting Collection - added manually
4. Assign a process parameter to a new variable in ScriptTask. Here is the example how to process the collection:
MyEntity process parameter with EntityCollection type. Parameter value= [#MyRead.Resulting collection#]
MyResult - string parameter. You can store record IDs from the collection. Then this parameter is shown on the auto generated page for the testing purposes.
Hi Lisa. Its been a few yrs since your reply. Is there a better way to do this in the product now? The code you have mentioned writes to the DB and triggers an execute.
I'm trying to create a dashboard to compare our sales pipeline to our forecast data. I've created the opportunity series of the dashboard; however, I'm stuck on the forecast portion. Is creating this dashboard possible? And if it is, can someone please explain how I'd go about creating it? I've created all of the other dashboards we need, but this one has me stuck. Help!
Unfortunately, there is no option to create a dashboard based on the [Forecasts] section because it uses tables of other sections in the Data Base. As an alternative, you can build charts on objects of [Opportunities] and [Invoices].
We have registered the suggestion to allow building the dashboards based on the forecasts directly. Our R&D team will consider it for the further releases.
I need construct a batchquery but in one column is necesary constuct a string with the id of the object. How can call the id object in the insert?
var insert = Ext.create("Terrasoft.InsertQuery", {
rootSchemaName: "Entity"
});
insert.setParameterValue("EmailURL", "?entityid=" + //Need put the Id of object Entity//, this.Terrasoft.DataValueType.TEXT);
bq.add(insert);
