Blog to learn: Apriso

DELMIA APRISO

Apriso Desktop Client
Apriso Process Builder
Global Process manager
Archive
Apriso Configuration Manager

Certificates:

Apriso Brand Essentials Program
Apriso Foundation
Apriso Process Builder
Complex Assembly Production
Repetitive Production
Quality
Maintenance
Warehouse Shipping
Time & Labor

GPM Entity tables:

PB_Project

Operation

Operation_Header

Operation_Link

Standard Table

Role

Employee

EmployeRole

Group_

Product

Product_Group

Resource_

Resource_Labor

Equipment

Serial_No

Wip_order

Wip_order_Type

Wip_order_Status

Wip_Operation

Container

Container_Class

Inventory2

Warehouse

Warehouse_Location

Text

Text_Translation

Literal

Literal_Translation

Literal_Dictionary

Literal_Dictionary_Translation

Text_Translation

Unit

Unit_characteristic

Who Columns:

Createdon

Creatdby

Lastupdateon

Lastupdatedby

Active

Referenceid

Rowversionstamp

Lastdeleteon

LastDeletedby

LastArchiveon

LastArchivedby

APRISO Configuration Manager

a. WebAddress : App101

b. Database Configurations:

c. Reporting Service

d. Literal Provider

e. Security

Apriso Desktop client:

• Company

• Facility

• Department

• Warehouse

• Warehouse Location

• Warehouse Location Class

• Warehouse Location Relation

• Location Relationship Class

• Location Lookup

• Zone

• Work center

• Equipment Explorer

• Equipment Class

• Resource Explorer

• Container

• Container Class

• Container Lookup

• Reason Code

• Reason Class

• Reason Type

• Product Maintenance

• Employee Maintenance

• Group

• Group Class

• Work Instructions

• Work Instruction Class

• UOM Maintenance

• Role

• Skill

• Dictionary Links

• Dictionary Translation

• System Parameter & list

• Advanced Determination Designer

• Advanced Determination value Editor

• Flex Part Configuration

• Machine Integrator Configuration

• Machine Integrator Monitoring

• Disposition

• Disposition Content

• Disposition Line

• Disposition Reading

• Disposition Test

• Disposition Test Sample

• Approval Cockpit

• Dispatching Board

• Production Line

• Order

• Operation

• Order Line

• Order Status History

• Order Type

• Machine Time Cockpit

• Maintenance Cockpit

• Maintenance Order

• Maintenance Calendar

• Maintenance Template

• Time Manager Cockpit

• Weighing & Dispensing Cockpit

APRISO MES Folder Configurations

a. Labels Definitions

C:\Program Files\Dassault Systemes\DELMIA Apriso 2019\Labels Definitions

.prn File

.Xml File

b. Report Definitions(Standard Reports of Attendance, Producton, Labor, Quality, Warehouse)

.rpt File

.Xml File

c. Services

MI Service

Maintenace Service

Job Scheduler & Executor Service

PB Service

GPM Service

d. WebSite

CentralConfiguarion

Portal

WebService

MI(Machine Integrator)

Adv:

Data Acquisition

Alaram & Notifications

Automatic Logging

Simulations

OPC Server Communication:

Connector

DataSource

PointGroup

Point

GPM(Global Process Manager)

Types:

a. Generate From Selection

b. Generate Cumulative

c. Generate Differential

Create GPM:

1.Goto GPM --> Console Tree --> Projects -->Create New Folder(LineAllocation)

-->Right Click LineAllocation Folder --> New Projects --> Give Project Name(LineAllocation)--> ok

2.Click LineAllocation Project --> then Click Add Item-->Select Screen -->select Scren

Similarly(Layout, View, Operation and other dependies)

3.then Finaly Generate Cumulative -->ok, Now GPM is Ready.

4.Go to Package Repository-->Generated --> select Generated Package -->Save it

Package Actions:

a. Executing

b. Pending

c. History

Deploy the GPM:

a. Received

b. Loaded

c. Generated

Load GPM File

Right Click --> Package Repository -->Righ Click-->load from file --> select file -->ok

right click the package --> deploy

FlexPart Configuraion

Url Generate for Page

URL Generate

PB-->Right click screen--> publish As FlexPart--> create and Save

ADC-->Administration-->SystemAdministration-->MenuMaintenance-->select Screen -->save

Process Builder:

Entity Manager :
It is contains List of Process, Operation, View, Layout, Screen

Entity Status :
	1. Design In Progress 
		a. The new entity created and can not be execute.
	2. Development In Progress
		a. While working on the development
	3. Compiling In Progress
		a. Temporary status occur between status change
	4. On Hold 
		a. Put on hold
	5. Cancelled
		a. If it defection or no longer user we can cancel it
	6. Prototype 
		a. Used for testing purpose
		b. We can move back to design in Progress
	7. Active  - cannot move back to design or development status

Project Manager

• Project :

○ File -> New -> Project (Name & Revision)

○ Open the Project from Project manager -> Right click project -> Add module

○ Add reference of another module

• Screen:

○ File -> New -> Screen (Name, Revision, Project, Module)

○ Screen (Name, Revision, Title, Description, Layout, On-initialize, On-Load)

• Layout:

○ Using Panel we can design the screen

○ we can divide multiple panels

○ View are liked to panel.

○ Like header, Title, tabs, Filter, context, footer

• View:

○ Header - Header, Button on view

○ Form

Action and Forms

Button and control on view, Generic portal Form.

View Action Type:

□ Button (Primary)

□ Button (Secondary)

□ Calculated

Cannot be displayed

Routing can be added as a view and Operation action triggered based on business logic

□ Tab

□ Numeric - for mobile view

○ General

Button on a view and Business control

Tab, Grid, Tree, Visualization

○ Html - Button on a view and HTML editor

○ Html Header - Header, Button on a view and HTML editor

• Operation

○ Generic

Business components and user interface components

○ View

rendering section of screen and only one user interface elements.

○ Action

can not any user interface components, only for action which contain business logic

○ Change

used with form type and it is called after change the textbox, Dropdown, Radio, Checkbox

○ Validate

to validation

○ Data

retrieve data from Database

○ Initialize

to initialize a screen

○ Extension

○ Process

for transaction

○ Interface

triggered by FI Invocation schema that maps interface

• Function :

Input to Output

User Formula

Web service

SQL Query

Stored Procedure

Determination

Sub Operation

Sub task

Submit Print Request

Business Control

Show Message

Apriso Message

Message Broker

MI Script

DAL Query

MDX Query

Process :

○ Top of process model.

○ Collection Of process Operation, Resources, Materials

Operation:

○ Child entity of Process

○ Collection of Steps, Resources, Materials

Step:

○ Child entity of Operation

○ Work instruction with collection of function. Resources, Materials

Function:

○ Child entity of step.

○ Business logic, collection of Input and Output.

Input :

○ data received by function

Output :

○ Data sent by function

Function :

• Call Webservice :

CustomHeaders - Content-Type :application/json;

Payload - json input

Url - https:test.com/inventory

BC :

• Send Mail : SendEmailToEmployee_v3 -> FromEmailAddress, ToEmailAddress, Subject, Message, SMTPServer (mandatory fields)

• Get Translation : GetDictionaryItemTranslation - DictionaryItemCode, LanguageID

• Set MI Points : SetList

• Get MI Points : GetList

Modules Type(PB)

f. Production

1.Bill Of Material

Component

Componenet_...

2.Genealogy

Genealogy

Genealogy_Detail

3.Recipe

Component

Recipe

Recipe_Status

Recipe_Characterstic

Validation_Status

Validation_entity_type

4.Wip Orders

Wip_Order

Wip_Order_cONTAINER

Wip_Order_Lot

Wip_Order_Relation

Wip_Order_Status

Wip_Order_Type

Work_Flow_Status

5.Work Instructions

Operation_Step+Work_Instruction

Unit

Work_Instruction

Work_Instruction_Class

6.Operations

Progress_Status

Wip_Componenet

Wip_Container

Wip_Operations

Wip_Operation_Step

Wip_Req_Resource

Work_Center

Wip_Operation_...

g. Quality

1.Issue Management

Capa

Capa_Class

Capa_Status

Capa_Link

Capa_Step

Capa_Task

2.Quality Defect

Quality_Defect

Quality_Defect_Location

Quality_Defect_Type

Quality_Defect_Status

Unit_Document

3.Quality Inspection

Disposition

Disposition_Class

Disposition_Content

Disposition_Line

Disposition_Resource

Disposition_Status

Disposition_Test

Disposition_type

Disposition_User_Status

4.Quality Planning

Inspection_Plan

Inspection_Line

Inspection_Plan_Class

Inspection_Plan_Group

Quality_Gate

Inspection_Severity

h. Maintenance

Main_Order_Task

Maint_Template

Maint_Template_Task

Resource_Maint_Task_Template

Resource_Maint_Task_Schedule

i. Warehouse

1.Inventory

2.Packaging

3.Transactions

4.Counting

j. Time and Labour

1.Attendance

Attendance

Attendance_Status

Employee_Class

Employee_Facility

Pay_Cycle

Pay_Rule

2.Calendar

Calendar

Calendar_Type

Calendar_Day

Employee_Calendar

3.Labour

Labor

Labor_Detail

Labor_Status

Lbor_Type

Work_Center

Labor_Code

4.Schedule

Employee_Work_Schedule

Employee_Break_Schedule

Facility_Work_Schedule

Schedule_Type

Schedule_Status

5.Shifts

Work_Shift

Break_Type

Work_Shift_Type

Types Of Entity

1.Screen

2.Layout

3.View

4.Operation

5.Process

6.ActionScript

7.Project

Entity Status

a. Active

b. Prototype (Ctrl + Shift + P)

c. Developemt in Progress(Ctrl + Shift + G)

d. Design in Progress(Ctrl + Shift + D)

e. On Hold

f. Cancelled

Validate(Ctrl + Shift + V)

Compile(Ctrl + Shift + B)

SubType of View

g. General

h. Form

i. Header

j. Html

k. Html Header

Type of Operation

a. Generic

b. View

c. Action

d. Change

e. Validate

f. Data

g. Iniyalize

h. Extension

i. Process

j. Interface

k. Labor

l. Machine

m. Background

SubType of Process

a. Discreate Production

b. Sequenced Production

c. Production Rework

d. Corrective Maintenance

e. Predictive Maintenance

f. Stablity testing

g. Quality Recall

h. Supplier release

i. Supplier Purchase

j. Warehouse Replenishment

k. Receiving

Session Variables

Step to step data transfer

External Variables

Screen to Screen, View to view data transfer

System Parameter Variables

Configued static data with Key & Value.

Project Manager

Entity Manager

List of Created and Modified Entity

ActionScript Manager

Bisiness Component Repository

Dictonary Manager

Add and Manage Dictonary items

SystemParameter & List Manager

Confiured Syated Parameter List

Determination Manager

Configued static and Dynamic data with with Multiple columns(DET2_ViewName).

Web Service Manager

Work Instructions

Change Management

Instead on one configure alternative Material and etc..

Quality Spectifications

Function

Input/Output

Show Message

Sql Query

Stored Procedure

Sub Operation

User Formula

WebService

Submit Print Request

Sub Task

Business Componenet

Business Control

Determination

Steps

Add functions

Input/Output Parameter

Add input

Add outpt

Add Pair

Routing

Route one step to another step basedon condition

Label Printing(QR/Bar code)

Generete QR and BAR code

Scheduled Jobs

Select Values From System Parameter

SELECT spv.Value_ AS Image

FROM System_Parameter sp

INNER JOIN SYSTEM_PARAMETER_VALUE spv ON sp.ID = spv.SystemParameterID

WHERE sp.Name = 'PRY_MBL4_MATERIAL_IMAGE'

Array Concodinate

Out_SelectedWipOrderNo = CurrentSelectedWipOrderNo.Concat(PreviousSelectedWipOrderNo).ToArray();

Remove List of data From Array

List<string> rest = Selected_WipOrderNo.Except(ReSelected_WipOrderNo).ToList();

FinalSelected_WipOrderNo = rest.ToArray();

Read the Inputs to ScreenInterface

$Context.inputs.Product

Set Output From ScreenInterface

$Context.outputs.Product

Js Code:

• Write Console log in Browser (Js) :

var msgObj = JSON.parse(msg);

if ($Context.inputs.ConsoleLogEnabled) {

console.log("Leftover data:");

console.log(msgObj);

}

• Apriso Popup Dragable:

$View.onLoaded(function(){

$('.apr-popup').css({"top": "90px" , "margin-top":"10px"}).draggable({ cursor: "move",

containment: "body",

scroll: false,

iframeFix: true,

handle: ".apr-popup-head"

});

</script>

Remove the data from Array

Array.prototype.remove = function(x)

{

var i;

for(i in this)

{

if(this[i].toString() == x.toString())

{

this.splice(i,1)

}

Compare Two Array

function compareArrays(arr1, arr2)

{

return $(arr1).not(arr2).length == 0 && $(arr2).not(arr1).length == 0;

};

EX: var compereProductFamilyArray = compareArrays(SelectedProductNo, Ext_ProductFamily) ? 'true' : 'false'

Add Selected table row value to Array

var SelectedProductNo = [];

$("table tr.selected").each(function ()

{

var data = $(this).find("td:eq(1)").text();

SelectedProductNo.push(data);

});

Tab View in HTML(GenericPortalTab)

<span>{_inlineTabTitleList[i]}</span>

<span data-flx-filter="_inlineNotifyCountList[i] > 0" class="TabNotify" data-portal-id="{Panel}{_inlineTabList[i]}">{_inlineNotifyCountList[i]}</span>

</button>

</div>

Disable the button

$("button[value='MANAGE']").prop("disabled", false);

Table row click event

$(".DynamicGrid table tbody").delegate("tr", "click", function()

{

});

Selected row count

$('.DynamicGrid table tbody tr.selected').length;

Place Holder to Textbox

$('.fc_OrderNo input').attr("placeholder","Enter Order No");

$('.fc_Update_ActivityID input').attr("readonly","readonly");

Hide Columns in Grid (Fields2HideList- List Of char)

Fields2Hide = new Array();

if(ColumnList !=null)

{ var Columns = ColumnList.split(',');

for(var i = 0; i < Columns.length; i++)

{

Fields2Hide.push(Columns[i]);

}

List to Array in Apriso

List<string> _JobId = new List<string>();

for (int i=0; i<WipOrderNoListForBatch.Length; i++)

{

_JobId.Add(In_JobId);

}

JobId = _JobId.ToArray();

List to Button Display in view Operation Code

<div class="btn_selection" data-flx-iterate="i,ButtonHtmlList"> {ButtonHtmlList[i]:html}</div>

Join array as string

Result = string.Join(", ", array);

Compare a string with List of string

foreach (string Machine in MachineList)

{

if(SelectedMachineName == Machine)

{

SelectedMachineisAlternative = true;

SelectedAlternativeMachineName = SelectedMachineName;

}

Number Validation in JQuery

$(document).on('keypress','div.decimal input',function(evt)

{

var result = $(this);

result.val(result.val().replace(/[^0-9\.]/g, ''));

if (result.val() = '' && (evt.which != 46 || result.val().indexOf('.') != -1) && (evt.which < 48 || evt.which > 57))

{

evt.preventDefault();

}

});

JqxPopup

Html:

</div>

</div>

JavaScript:

$('#scheduleWindow').jqxWindow({

width: 600,

height: 200,

resizable: false,

isModal: true,

autoOpen: false,

});

C# Code:

• DebugMode code (c#):

if (DebugMode)

{

throw new OperationException(Message,"");

}

• Input Value in Screen Interface (Js)

var consoleLogEnabled = $Context.inputs.ConsoleLogEnabled;

• Output Value in Screen Interface (Js)

$Context.outputs.RackContainerNo = containerNo;

• Write MI log :

Log.Info("Exception in Machine Tracking operation: " + DateTime.UtcNow);

• Convert Scalar To List : Recipient -char, ToEmailAddress-char list

ToEmailAddress = new String[]{Recipient};

• Remove Empty String from Array :

Var ErrorList = ErrorCodes.Where(x => !string.IsNullOrEmpty(x)).ToArray();

VerificationStatus = ErrorList.Length == 0 ? MIPointValue : 0;

• Get JSON Based on input in Userformula:

JsonResult = Serializer.SerializeToJson(this.GetInputsObjectArray("")[0]);

• Get JSON Based on input in Userformula:

var payload = new

{Inputs = new

{

MachineId,

ProductNo,

ProductRevision1,

ProductRevision2,

LearningParamNames,

LearningParamTypes,

LearningParamValues,

LearningCRC,

Caller = "Apriso"

}

};

Payload = JsonConvert.SerializeObject(payload);

• Existing JSON add new field:

Newtonsoft.Json.Linq.JObject jsonData = Newtonsoft.Json.Linq.JObject.Parse(_Message);

if (jsonData.HasValues)

{

jsonData.Add("CreationTimestamp", CurrentUTCTime);

jsonData.Add("CreatedBy", CreatedBy);

}

Message = JsonConvert.SerializeObject(jsonData);

• Read From JSON List Data :

List<string> tempparent = new List<string>();

List<string> tempnumber = new List<string>();

List<string> tempsource = new List<string>();

List<string> tempproject_name = new List<string>();

List<string> tempproject_state = new List<string>();

dynamic dynJson = JsonConvert.DeserializeObject(Input);

foreach (var item in dynJson)

{

tempparent.Add(item.parent.ToString());

tempnumber.Add(item.number.ToString());

tempsource.Add(item.source.ToString());

tempproject_name.Add(item.project_name.ToString());

tempproject_state.Add(item.project_state.ToString());

}

parent = tempparent.ToArray();

number = tempnumber.ToArray();

source = tempsource.ToArray();

project_name = tempproject_name.ToArray();

project_state = tempproject_state.ToArray();

• Create Array in

Comments = new Array();

StockingPoints = new Array();

if (OperationIDList.length > 0)

{

for (var i=0;i<OperationIDList.length;i++)

{

Comments.push("");

StockingPoints.push("");

}

• Debug Mode:

if (DebugMode){

throw new OperationException("Debug mode enabled, database transactions are rolled back","");

}

• Remove Empty String form Array list

var ErrorList = ErrorCodes.Where(x => !string.IsNullOrEmpty(x)).ToArray();

• Array List to Scalar :

List<int> status = new List<int>();

WipOrderFound = false;

if (WorkOrderStatusList.Length >0 ){

WorkOrderStatus = WorkOrderStatusList[0];

}

for (int count=0; count < AWOLPWipOrderNoList.Length; count++)

{

if (VerificationStatus == AWOLPStatusList[count])

{

WipOrderFound = true;

WipOrderNo = AWOLPWipOrderNoList[count];

WipOrderType = AWOLPWipOrderTypeList[count];

WorkOrderStatus = WorkOrderStatusList[count];

ProductID = AWOLPProductIDList[count];

SequenceNo = AWOLPSequenceNoList[count];

break;

}

• JSON to LIST :

Newtonsoft.Json.Linq.JObject jsonData = Newtonsoft.Json.Linq.JObject.Parse(JsonErrorsDictionary);

string error = "";

var jsonDictionaryErrorsList = jsonData["Items"].Select(p =>

new

{

ID = (int)p["ID"],

Code = (string)p["Code"],

ShortText = (string)p["ShortText"],

MediumText = (string)p["MediumText"],

ExtendedText = (string)p["ExtendedText"]

}

).ToList();

string errWrongResource = (from lst in jsonDictionaryErrorsList where lst.Code == "BS_ERR_PREPID_WRONG_RESOURCE" select lst.MediumText).FirstOrDefault();

string errInCorrectStatus = (from lst in jsonDictionaryErrorsList where lst.Code == "BS_ERR_PREPID_WRONG_STATUS" select lst.MediumText).FirstOrDefault();

string errInWrongNoOfPrepID = (from lst in jsonDictionaryErrorsList where lst.Code == "BS_ERR_PREPID_WRONG_NO_OF_PREP" select lst.MediumText).FirstOrDefault();

• Convert JSON to string :

if (string.IsNullOrEmpty(JsonString))

return;

var MaterialLotObject = new

{

partNumber = string.Empty,

quantity = 0m,

kanbancardid = string.Empty,

uuid = string.Empty,

valueStream = string.Empty,

workStation = string.Empty,

expirationDate = string.Empty,

uom = string.Empty,

};

var outputMaterialLotObjectList = new[]

{

MaterialLotObject

}.ToList();

outputMaterialLotObjectList.Clear();

List<object> MaterialLotObjectList = new List<object>();

MaterialLotObjectList.Add(MaterialLotObject);

var ourObject = new

{

MaterialLots = MaterialLotObjectList

};

JsonSerializerSettings settings = new JsonSerializerSettings();

settings.FloatParseHandling = Newtonsoft.Json.FloatParseHandling.Decimal;

var deserializedObject = JsonConvert.DeserializeAnonymousType(JsonString, ourObject, settings);

foreach (var MaterialLot in deserializedObject.MaterialLots)

{

var deserializedMaterial = JsonConvert.DeserializeAnonymousType(MaterialLot.ToString(), MaterialLotObject, settings);

MaterialLotObject = new

{

deserializedMaterial.partNumber,

deserializedMaterial.quantity,

deserializedMaterial.kanbancardid,

deserializedMaterial.uuid,

deserializedMaterial.valueStream,

deserializedMaterial.workStation,

deserializedMaterial.expirationDate,

deserializedMaterial.uom

};

outputMaterialLotObjectList.Add(MaterialLotObject);

}

List<decimal> quantityList = new List<decimal>();

List<string> PartNumberList = new List<string>();

List<string> KanbanCardIDList = new List<string>();

List<string> UUIDList = new List<string>();

List<string> ValueStreamList = new List<string>();

List<string> WorkStationList = new List<string>();

List<string> ExpirationDateList = new List<string>();

List<string> UOMList = new List<string>();

foreach (var MaterialLot in outputMaterialLotObjectList)

{

PartNumberList.Add(MaterialLot.partNumber);

quantityList.Add(MaterialLot.quantity);

KanbanCardIDList.Add(MaterialLot.kanbancardid);

UUIDList.Add(MaterialLot.uuid);

ValueStreamList.Add(MaterialLot.valueStream);

WorkStationList.Add(MaterialLot.workStation);

ExpirationDateList.Add(MaterialLot.expirationDate);

UOMList.Add(MaterialLot.uom);

}

PartNumbers = string.Join(",",PartNumberList);

Quantities = string.Join(",",quantityList);

KanbanCardIDs = string.Join(",",KanbanCardIDList);

UUIDs = string.Join(",",UUIDList);

ValueStreams = string.Join(",",ValueStreamList);

WorkStations = string.Join(",",WorkStationList);

ExpirationDates = string.Join(",",ExpirationDateList);

UOMs = string.Join(",",UOMList);

I/p:

{"MaterialLots": [{"partNumber":"36300777","quantity":"50.0","kanbancardid":"1000385413","uuid":"D1A4C958-7C45-4F4A-B3F6-D6470853B851","uom":"m","valueStream":"87","workStation":"31A_CELL02A","expirationDate":"2024-11-11"},{"partNumber":"37300777","quantity":"20.0","kanbancardid":"1000452132","uuid":"D1A4C958-7C45-4F4A-B3F6-D6470853B851","uom":"a","valueStream":"82","workStation":"31A_CELL02A","expirationDate":"2024-11-17"},{"partNumber":"38300777","quantity":"90.0","kanbancardid":"1000356758","uuid":"E6F2B682-9G35-5B6H-H3U3-N3294646C359","uom":"s","valueStream":"82","workStation":"31A_CELL02A","expirationDate":"2024-11-08"}]}

Inventory Sync Display:

SQL:

SELECT

createdon AS "LastInvSynch_IN"

from Inventory2

where createdby='BOSS IBA1'

order by createdon desc

fetch first 1 row only

HTML :

<div class="apr-laflex-container apr-direction-vertical apr-la-fill ">

<dir class="apr-bg-gray-section apr-font-me apr-la-space-me" style="width:600px" >

<div class="apr-laflex-container apr-direction-horizontal">

<div class="apr-laflex-item ">Last inventory synch from Apriso to BOSS:</div>

<div><b>{LastInvSynch_OUT:yyyy-MM-dd HH:mm:ss}</b></div>

</div>

<div class="apr-laflex-container apr-direction-horizontal">

<div class="apr-laflex-item ">Last inventory created in Apriso:</div>

<div><b>{AprisoLastInvCreatedOn:yyyy-MM-dd HH:mm:ss}</b></div>

</div>

<div class="apr-laflex-container apr-direction-horizontal">

<div class="apr-laflex-item">Last inventory synch from BOSS to Apriso:</div>

<div><b>{LastInvSynch_IN:yyyy-MM-dd HH:mm:ss}</b></div>

</div>

</dir>

<div data-flx-bc="Grid"/>

</div>

Issue check display

SQL:

select IssueType, Count(IssueType) as IssueCount

from table(AF_MASTERDATA_INTEGRITYCHECK())

group by IssueType

Grid Query:

select IssueType, IssueDesc, Details

from table(AF_MASTERDATA_INTEGRITYCHECK())

HTML:

<span>{IssueType[i]}</span>

<span class="apr-notify">{IssueCount[i]}</span>

</div>

function setFilter(issueType)

{

console.log($(".DynamicGrid").dgGetFilters());

$(".DynamicGrid").dgSetFilters({"filter_issuetype":issueType});

}

</script>

Web service list display Grid:

SQL :

SELECT DISTINCT

WS.Name AS "WS_NameList",

WS.Enabled AS "WS_EnabledList",

WS.OperationCode AS "WS_OperationList",

--WS.Parameters AS "WS_Parameters"

PP.Name AS "WS_ProjectList",

xmltype(WS.Parameters).extract('//ProcessBuilderWebServiceType/text()').getstringval() as "WS_TypeList"

FROM WEBSERVICE WS

JOIN OPERATION_HEADER OH

ON OH.ID = WS.OperationHeaderID

JOIN OPERATION O

ON O.OperatioNHeaderID = OH.ID

JOIN OPERATION_LINK OL

ON OL.Operationid = O.ID

AND OL.IsDefaultRevision = 1

LEFT JOIN PB_PROJECT PP

ON PP.ID = OH.ProjectID

WHERE WS.Name NOT LIKE 'APR%'

ORDER BY WS.Name

HTML:

<div class="apr-font-me apr-la-space-me">Web Services</div>

<tr>

<th>Web Service Name</th>

<th>Operation</th>

<th>Enabled</th>

</tr>

</thead>

<tbody>

<td>{WS_NameList[i]}</td>

<td>{WS_OperationList[i]}</td>

<td>(server name)/Apriso/httpServices/operations/{WS_NameList[i]}<span data-flx-filter="WS_ProjectList[i] != '' &&WS_TypeList[i] == '2' ">/project/{WS_ProjectList[i]}</span></td>

</tr>

</tbody>

</table>

</div>

Performance Issue:

Server performance issue:

• Due to application log generation c drive is full;

• IIS logs in web server c drive is full

• Memory consuming more then 90 % (user not properly logout)

Application Performance issue:

• Indexing problem

• Log enabled like debugging, error, perfromance

• User has process role

• Query / operation execution taking time

Concurrency violation issue

Blog to learn

Thursday, 27 August 2026

Apriso

1 comment: