Jump to content

Veritas

Members
  • Content count

    59
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Veritas

  • Rank
    Level 4 Contributor

Profile Information

  • Gender
    Male
  • Location
    Egypt

Recent Profile Visitors

424 profile views
  1. I need last change workflow when complete change order automatically close
  2. I need to make Outage start time and end time required for all incidents (cannot close) when impact is entire organization.
  3. I need to make change start date and duration required for emergency change order.
  4. I Need to make attachment required for some request area I created spel file cr::z_req_attmnt(...) { if (category == "pcat:5109") { send_wait(0, top_object(), "call_attr", "lrel_attachments_requests", "sync_fetch", "STATIC", format("cr = '%s'", persistent_id), -1, 0); if (msg[1] == 0) { set_error(1); set_return_data(format("Attachments are required for [%s] area", category.sym)); return; } } } and created mod file MODIFY cr POST_VALIDATE z_req_attmnt() 1000 FILTER (EVENT("INSERT")); and add them in majic folder Its working but while attached file it give the same error, so I can't save request I need to apply for Employee interface only
  5. Can anyone help me?
  6. [Solved] as i'm added prpval in ctab table and in data partition made constrain view value='property value'
  7. I need to make data partition for employee interface to view some properties value be informed that i'm added prpval in ctab table
  8. Thank you so much Case Resolved with below query SELECT dbo.chg.chg_ref_num AS [Change no], dbo.chgcat.sym AS Category, dbo.usp_change_type.sym AS Type, dbo.chg.summary, dbo.ca_owned_resource.resource_name, dbo.ca_owned_resource.serial_number, dbo.ca_resource_family.name AS [Family Name], dbo.ca_resource_class.name AS Class, dbo.chgstat.sym AS Status FROM dbo.chg INNER JOIN dbo.usp_lrel_asset_chgnr ON dbo.chg.id = dbo.usp_lrel_asset_chgnr.chg INNER JOIN dbo.chgcat ON dbo.chg.category = dbo.chgcat.code INNER JOIN dbo.usp_change_type ON dbo.chg.chgtype = dbo.usp_change_type.id LEFT OUTER JOIN dbo.chgstat ON dbo.chg.status = dbo.chgstat.code LEFT OUTER JOIN dbo.ca_resource_family INNER JOIN dbo.ca_owned_resource ON dbo.ca_resource_family.id = dbo.ca_owned_resource.resource_family INNER JOIN dbo.ca_resource_class ON dbo.ca_owned_resource.resource_class = dbo.ca_resource_class.id ON dbo.usp_lrel_asset_chgnr.nr = dbo.ca_owned_resource.own_resource_uuid
  9. Kindly be informed that I need to create report with Change order no, Category and configuration item Name and configuration item serial linked in this change order.
  10. Kindly be informed that I need to create report with incident no, Category and configuration item Name and configuration item serial
  11. configure mailbox

    Could you please tell how you solved this case step by step?
  12. I need your help to add another fields when export active incidents to Excel like (Closed Date, Description and Category)
  13. I need your help to add another fields when export active incidents to Excel like (Closed Date, Description and Category)
  14. KIndly be informed that i made data partition for Departments are below: 1- Table "Call Req" , Type "View" and Constrain "group.last_name IN 'Department Name' OR customer =@root.id" 2- Table "Change_Request", Type "View" and Constrain "group.[group]member_list.member IN @root.id" 3- Table "Change_Request", Type "Pre-Update" and Constrain "group.[group]member_list.member IN @root.id"
×