We have tried this way but no results.table // order // prefix // where conditionx table //300 //fr // rl_id=fr_sys_id sys_history_line //200 // hl // hl_set=rl_sys_id sys_history_set // 100 // rl // kindly assist
How to create create report based on string value and if 1st 2 values are unique then i want to show in one single line bar chart Ex: HYD Campus - Main BlockEx: HYD Campus - 12nd BlockEx: HYD Madhapur - Block Ex: Pune - Mumbai MainEx: Pune - Head off...
HI All, I have below requirement...I am trying to develop a report to calculate the sum of a field which is created as a string field. When I tried to create a report it doesn't give me an option to select this field. IS there any other way to accomp...
All,I have a business requirement to restrict the list of CI choices based on selected category/subcategory on the incident form.So for example, we have a category = Hardware and a Subcategory = Computer. In the configuration item field I'd like to h...
I want to get the list of all the ITEMs from all of my SCTasks. 1. Get all SCTasks assigned to is (dynamic) one my groups. (assignment_groupDYNAMICd6435e965f510100a9ad2572f2b47744) 2. Get all Items from all the SCTasks in the query. SCTASK > RITM > R...
I am trying to create a unique QR for every record of a custom table. I have spent hours applying various solutions currently present on community but unable to generate any QR code (the best I was able to create a barcode). Maybe I lack fundamental ...
Hi All, I am trying to create tasks when there is an error in flow designer. Is there a way we can make a flow error out to test this scenario? Can we create a error is any step of flow? Thanks!
when change record state get changes to schedule then planned start date and planned end should be mandatory and display warning message under planned end date fields(message :please select start and end date
Dear All, We have configured a simple notification for a complete catalog and the catalog is having 90+ catalog items.The mail was sent out from the system since the notification is triggered, but suddenly from few days this notification has stopped ...
Hi When we submit proposal for new Standard Change request and request is approved. It pops up the message twice as ; Info Message At least one of flow, workflow or execution plan should be filled. Otherwise, when order is placed, then even on approv...
Hello,I have the problem that the users with the itil role cannot update incidents in the form view. It is possible to update on the list.Do you have any idea what I can check? I see the ACL for write is true, but it isnt work. Best regardsJustin
Hello all,I want to execute the scheduled import 3 times in the flow. And if it has given error then incident will be created. I have tried this below is screen shots and script using custom action. But by doing it. It is creating execution records m...
Hello all, I am back with another question. I have a catalog item that 'User 1' fills out and is sent to 'User 2' to process. On the catalog item, I have hidden fields that 'User 2' will fill out. Currently, it's set up so when 'User 2' goes in to...
Is there any possibility to bring an email into the interactive filter of the dashboard? I need this value from the sys_user table, but it is not showing up.
| User | Count |
|---|---|
| 36 | |
| 23 | |
| 20 | |
| 10 | |
| 9 |
