Previous Next

Search

1. RelatedUserInfo.js - Forcing a sort by LastModified date

   

   Question by Eugene_Rack · January 2017 · Home› General Discussion

   Hello all Hope someone knows how to do the following. Using the Search User to find a user then loading the user details, I click on the Requests the user has against their name. The returned values are in any order. I would like to modify the relateduserinfo.js to sort by lastmodified column automatically when selecting…

2. Re: Recurring Notification Subscription

   

   Comment by Justin_Workman · April 2018 · Home› Service Manager

   AND LastModified > [now+10m] ?

   2 results

3. Re: Get Last Modified date for PowerBI report from SQL

   

   Comment by Chris_Sprague · June 2020 · Home› General Discussion

   Final Scripts, if anyone else is doing PowerBI custom reports. This is for live, SQL, not DW. These are made to be joined together and give you combined IR/SR/MA reports. Combined as table WorkItems Calculated Column for last modified #if there is no lastmodified, then set to end date, if no end date, set to opendate. Last…

   2 results

4. Re: Is it possible to use GETDATE in SQL Queries with the Dashboard API

   

   Comment by Peter_Muttenthaler · February 2022 · Home› Analyst Portal

   Hi @Jan_Schulz for me its working but you've forgotten a bracket: SELECT DisplayName, LastModified FROM [dbo].[WorkItem] where LastModified >= (DATEADD(day, -1, GETDATE())) take care which database you've selected in Cireson ;)

   2 results

5. Re: SCSM - Last Modified Date Manager for IR and SR

   

   Comment by fe_fe · January 2017 · Home› Community Uploads

   Hi Connor, It could be usefull if you made it possible to just replace one LastModified date with a custom one that I set. Also, I'm not that comfortable with editing the SCSM DB directly. Is it possible to edit LastModified date through Powershell?

6. Re: Custom Forms - System.Domain.User

   

   Comment by Jeff_Lang · June 2023 · Home› Analyst Portal

   this one is working for us, but it's not often we add custodians on non hardware assets though "name": "ConfigurationItemsForWhichThisUserIsACustodian", "rows": [ { "columnFieldList": [ { PropertyName: "ConfigItem", type: "multipleObjectPicker", ClassId: "62F0BE9F-ECEA-E73C-F00D-3DD78A7422FC", PropertyToDisplay: {…

   3 results

7. Re: Cannot constrain multipleObjectPicker control to display certain classes

   

   Comment by Geoff_Ross · June 2019 · Home› Service Manager Portal Feature Requests

   Hey Chris, I believe this is possible with the property 'scoped: true' eg columnFieldList: [ { PropertyName: "ConfigItem", type: "multipleObjectPicker", ClassId: "7AD221E0-E4BB-39A8-6514-33B60BBA46F5", Scoped: true, Disabled: true, PropertyToDisplay: { DisplayName: "Name", "ObjectStatus.Name":"Status",…

8. Re: Clear old items from the portal

   

   Comment by Geoff_Ross · January 2021 · Home› Analyst Portal

   @Sean_Terry Did the lastmodified table repopulate? How long did you give it?

   2 results

9. Re: No Serviceoffering's with the new Catalog Item group

   

   Comment by Justin_Workman · July 2020 · Home› Analyst Portal

   @Andreas_Voigt - So did truncating lastmodified and restarting cachebuilder fix your issue?

   2 results

10. Re: Incident not showiung in portal

    

    Comment by Brian_Wiest · March 2017 · Home› Analyst Portal

    Restart the Cireson Cachebuilder. Also recommended to Truncate Table LastModified in the SQL database.

    2 results