HI,
I am facing issue in perspective’s table as a component error.
printing dataset giving this result - “com.inductiveautomation.ignition.gateway.datasource.BasicStreamingDataset@56be9d7f”
[{‘style’: {‘backgroundColor’: ‘#95F985’},
‘value’: {‘Serial number’: ‘QIP_WO_-2’, ‘Description’: ‘’, ‘StatusChangedBy’: 24, ‘WorkStationId’: 6, ‘Account number’: ‘1234567’, ‘Operator comments’: ‘approve’, ‘Quantity’: 1, ‘Lot id’: ‘123343’, ‘Requested by’: ‘Aditya Patil’, ‘Workstation’: ‘01-Actuator Subassembly’, ‘Component id’: ‘200011’, ‘FromScada’: True, ‘WorkOrderId’: 11542, ‘Approved by’: ‘Aditya Patil’, ‘Assembly number’: ‘QIP_WO1’, ‘Requested date’: 2022-02-28 06:50:45.29, ‘Select’: 0, ‘Id’: 85, ‘RequestedBy’: 24}}]
style is used to highlight (special purpose ). but when i process the data from this table this table get empty but after that and console returns and table gives component error
- Please format your code correctly. Placing code directly into text makes it difficult to read/parse, and introduces characters which make it impossible to paste directly into tools which would be used to help you. I had to go into a text editor and replace all of the quotes from your code before I could use your code at all. Please use the code formatter tool (
</>)
Here’s your code properly formatted:
[
{
"style": {
"backgroundColor": "#95F985"
},
"value": {
"Serial number": "QIP_WO_-2",
"Description": "",
"StatusChangedBy": 24,
"WorkStationId": 6,
"Account number": "1234567",
"Operator comments": "approve",
"Quantity": 1,
"Lot id": "123343",
"Requested by": "Aditya Patil",
"Workstation": "01-Actuator Subassembly",
"Component id": "200011",
"FromScada": True,
"WorkOrderId": 11542,
"Approved by": "Aditya Patil",
"Assembly number": "QIP_WO1",
"Requested date": 2022-02-28 06:50:45.29,
"Select": 0,
"Id": 85,
"RequestedBy": 24
}
}
]
-
When I put this into a Table as the
datavalue, I encounter no issue - so the problem must stem from something else you’re doing to the Table or the dataset. You mention that you process the data for the table and the Table becomes empty and it’s AFTER that which the error occurs. So we need to know what you’re doing at THAT time if we’re to help you. -
As a minor note: please don’t use spaces for your object keys. We believe we’ve done everything we can to safeguard that sort of usage, but if you look in the Designer you’ll see lots of “invalid key” warnings in the Property Editor because I don’t think we officially support spaces in object keys.
Tip: use the </> code formatting button to preserve indents and apply syntax highlighting. There’s a pencil icon under your post so you can edit it to fix it. Please also use capitals and punctuation for clarity and legibility.
[
{
"style": {
"backgroundColor": "#95F985"
},
"value": {
"Serial number": "QIP_WO_-3",
"Description": "",
"StatusChangedBy": 24,
"WorkStationId": 6,
"Account number": "09080",
"Operator comments": "",
"Quantity": 1,
"Lot id": "090",
"Requested by": "Aditya Patil",
"Workstation": "01-Actuator Subassembly",
"Component id": "200010",
"FromScada": true,
"WorkOrderId": 11548,
"Approved by": "Aditya Patil",
"Assembly number": "QIP_WO1",
"Requested date": {
"$": [
"ts",
192,
1646316569842
],
"$ts": 1646301162380
},
"Select": 0,
"Id": 165,
"RequestedBy": 24
}
},
{
"style": {
"backgroundColor": "#95F985"
},
"value": {
"Serial number": "QIP_WO_-3",
"Description": "",
"StatusChangedBy": 24,
"WorkStationId": 6,
"Account number": "09080",
"Operator comments": "",
"Quantity": 1,
"Lot id": "87879",
"Requested by": "Aditya Patil",
"Workstation": "01-Actuator Subassembly",
"Component id": "200009",
"FromScada": true,
"WorkOrderId": 11549,
"Approved by": "Aditya Patil",
"Assembly number": "QIP_WO1",
"Requested date": {
"$": [
"ts",
192,
1646316569842
],
"$ts": 1646301162423
},
"Select": 0,
"Id": 166,
"RequestedBy": 24
}
},
{
"style": {
"backgroundColor": "#95F985"
},
"value": {
"Serial number": "QIP_WO_-3",
"Description": "",
"StatusChangedBy": 24,
"WorkStationId": 6,
"Account number": "09080",
"Operator comments": "",
"Quantity": 1,
"Lot id": "",
"Requested by": "Aditya Patil",
"Workstation": "01-Actuator Subassembly",
"Component id": "200020",
"FromScada": true,
"WorkOrderId": 11550,
"Approved by": "Aditya Patil",
"Assembly number": "QIP_WO1",
"Requested date": {
"$": [
"ts",
192,
1646316569842
],
"$ts": 1646301162467
},
"Select": 0,
"Id": 167,
"RequestedBy": 24
}
}
]
After completing order i move that row to another table but still after approving few orders it gives component error
- The above data is passed before error is occurred.
- Refresh start : 1 shows it still has one item in list.
plz provide the scripts you use to “pass data”
system.perspective.print("Refresh Start")
refreshActiveDataList = Project_Mako4.PartRequest.GetActivePartRequestData.GetActivePartRequestData()
self.props.data=refreshActiveDataList
select trnPart.Id, trnPart.PartNumber as 'Assembly number',trnPart.Description ,trnPart.SerialNumber as 'Serial number', trnPart.Comment as 'Operator comments'
, trnPart.AccountNumber as 'Account number', trnPart.Quantity,trnPart. RequestedBy ,trnPart. WorkStationId ,trnPart.LotId as 'Lot id',trnPart.ComponentId as 'Component id'
,mstUser.FirstName+' '+mstUser. LastName as 'Approved by',trnPart.StatusChangedBy
,trnPart.RequestedDate as 'Requested date' , mstP. Name as 'Workstation' ,mstU.FirstName+' '+mstU. LastName as 'Requested by',0 as 'Select', FromScada as 'FromScada', WorkOrderId
from TRN_RequestedPart trnPart left join MST_Plant mstP on (mstP.Id=trnPart.WorkStationId)
left join MST_User mstU on (mstU.Id =trnPart.RequestedBy) left join MST_User mstUser on (mstUser.Id =trnPart.StatusChangedBy) where Status = 'Approved'
order by trnPart.ModifiedDate desc
In short on this query it applies style
Thats really not enough to know what you are doing…
wait are you puting a dataset in the value? or a jsonobject?
because the data code you provided is jsonobject, but you are talking/name datasets?