isaque.almeida

Hi there I have done it by SPEL code

Hi Everyone, I need to add child incident list that are here on incident: IncFilhos.jpg (Attached) add to related incidents list on the tab 'Parent/Child Relationship', subtab 'related incidents list' on related problem, if possible also child of child. ProbVinculados.jpg (Attached) According to my seaches I need to configure detail_pr.htmpl in the line bellow, but I dont know how to do it to add child list and probably a dataset to add child of child. <PDM_MACRO name=tab title="Incidentes Vinculados" height=300 id=att_inc src="OP=SEARCH+FACTORY=in+QBE.EQ.problem.id=$dob.id+KEEP.forPRtoIN=1+KEEP.PR_PERSID=$args.persistent_id+KEEP.PR_ID=$args.id+KEEP.PR_REFNUM=$args.ref_num"> I appreciate any help. Thanks in advance.

Hey everyone, I need to certificate that a specific internal document is updated depending on the demand. So I created a request worflow task "Update Document" and set to the category. Now, I want to prevent that analysts set the ticket status as Resolved if that task is 'Pending'. I appreciate if someone could help me to achieve that. Thanks in advance.

Solved. The values are string and are compared as string and not as date. With both values, did : zstart_date = new Date(document.......)

Hi all. I developed a JavaScript function to prevent that call_back_date field be less than alg.time_stamp date (activity date). Date is in format DD/MM/YYYY The problem is that it's seems like comparing if the day of call back date is greater than day of activity date. Even if the month is greater, if the day is minor it's considering call back less than activity date. I attached a screenshot with an example. I appreciate any help that let me to solution. Thanks and regards. function zValidateSchedDate(){ var zStartDate, zSchedDate; var zSatus = document.main_form.elements["SET.status"].value; zStartDate = document.main_form.elements['SET.alg.time_stamp'].value; zSchedDate = document.main_form.elements['SET.call_back_date'].value; if((zSchedDate <= zStartDate) && (zSatus == "atdschedule")){ zDisplayMessage("Schedule date needs to be a future date!"); return false; }else{ return true; } }

Hi experts, after I migrate mdb and CA SDM from server (source and target version 17), when search incidents, the list does not load and when search by especific numbers it is not found as you can see attachments. Checking stdlogs I discovery this search is trying to execute a query with columns wich does not exist in call_req table. for example: call_req.actual_comp_date , call_req.current_wrkshft , call_req.est_comp_date , call_req.start_date. Just to check if it works, I create these fields in SQL Design and it works. However other problems like that happen. Can someone help me to understand what may have happened? After install SDM in the new server I follow this procedure strictly: https://docops.ca.com/ca-service-management/17-1/en/administering/moving-the-ca-mdb-data-from-the-source-to-the-target-systems I also attached some piece of stdlog.stdlog.txt stdlog.txt

Hi, after a lot of tries it worked like this: type != 'I' AND group = U'A9CD563B7420B747929459DC8F91C645' We are denying Incidents for this the group. Thanks for your efforts henning1518. I appreciate it. Good lucky

Hi Hennig, Thanks for helping however when I create a constraint only with "Type != 'I'" it restricts all incidents, even for other groups.

Hello Service Desk Experts, I need to restrict users open Incidents for a Specific group. Only for incidents, request should works. So I'm trying to do this by Data Partition constraint of creation. Eg. Type: Create Table: Call_Req Constraint: type != 'I' AND group != U'A9CD563B7420B747929459DC8F91C87' ***My problem is that this constraint is blocking not only Incidents, but also Requests.*** I already try something like that but it also blocks Requests too. type != 'I' AND group.last_name != 'name_of_the_group' (type != 'I') AND group.id != U'A9CD563B7420B747929459DC8F91C645' I would appreciate if someone can help to achieve that. Thanks in advance.

Hi Black, thanks for responding. I move the code to detail_alg.htmpl, so the validation can be done on the resolution moment. Thanks again. Hugs.

Hi experts, I have the list of symptom codes on my usp_symptom_code table as follows: id del sym 900 0 Application Not Responding 901 0 Error Message 902 0 High CPU Usage 903 0 Slow Response 904 0 System Making Noise 905 0 Unable to Connect 906 0 Unable to Log in 907 0 Unexpected Results 908 0 Unable to Boot 400001 0 Phone Not Responding 400002 0 Phone Error Message 400003 0 Phone Password Forgotten 400004 0 Phone Slow Response 400005 0 Phone Unexpected Results 400006 0 Phone Unable to Start What I want to dos is: When I open a new incident, if choose some category like 'HARDWARE.CELULAR%' just symptom codes related to it appears. This is my code on "detail_in.htmpl": var catCelular = 0; <PDM_LIST PREFIX=celularList WHERE="ref_num = '$args.ref_num' AND category.sym LIKE 'HARDWARE.CELULAR.%'" FACTORY=cr> // $celularList.id catCelular = 1; </PDM_LIST> if(catCelular == 1) { <PDM_MACRO name=dtlDropdown hdr="Symptom" attr=symptom_code lookup=no whereclause="id IN (400001, 400002, 400003, 400004, 400005, 400006)"> }else{ <PDM_MACRO name=dtlDropdown hdr="Symptom" attr=symptom_code lookup=no whereclause="id IN (900, 901, 902, 903, 904, 905, 906, 907, 908)"> }; When I create a new incident, before I choose some category it is ok, it is showing only symptom codes not related to category 'HARDWARE.CELULAR%' but when I choose one of these categories the options are not filtered. I hope I was able to be clear, I will be thankful if someone could help me on this. Thanks in advance. Bye.

Hi SDM experts, I'm very newbie on SPEL code. if ( !is_null(assignee) && status == "OP") { status = "WIP" ; How can I change it into a SPEL code? I want that SPEL code check 'assignee' field, if it is not null and it status is equal to 'Open', so set status to 'Work In Progress'. I'm talking about cr object. Can you guys help me?

Hi guys. On the Knowledge Documents Categories in Knowledge tab on SDM we have folders and subfolders created to put documents. Some of them have documents other does not. Well, what I need is a SQL Query to show how many docs we have in each folder or at least show if folder is empty. Do you guys know how it is possible? If somebody can help me I would appreciate it. Thanks a lot.

Hi guys, I would like to know how to create a popup confirm message when trying to cancel a ticket. For example: If I try to change a ticket status for canceled I receive a popup message like this: Do you really want to cancel this ticket? Options: OK (Proceed with cancelation) No (Close pupup) Can you guys help me? Thanks in advance!

Hi Asan Jolison, Firstly, using Web Screen Painter you should create a column on Schema Designer, for example: z_desvio_processo as SREL – Boolean type Save and Publish. You need to stop SDM and run pdm_publish command. On order_status_changed.html you should insert a PDM_MACRO, for example: <PDM_MACRO name=dtlDropdown hdr="Desvio de Processo" attr=z_desvio_processo > Don’t forget to run pdm_webcache I hope it helps. Good luck