IFS assyst

Hi Team,We have a requirement to fetch ItemSerialNumber linked to an Affected User. Using below query in form but getting error. Please help.select Item.serialNumber from item as Item where (Item.product.productClass.shortCode='CELL' and Item.user.id = @*@$new.affectedUser.id@*@) Thanks,Manish Verma

Hi all,  I am looking for the javadoc domain model for the 11.6 release. It used to exist for the 10SP7 release here ...https://wiki.axiossystems.com/assyst10SP7Wiki/javadoc-domain-model … but it is no longer available. I tried https://wiki.axiossystems.com/assyst11-6Wiki/javadoc-domain-model/ based on the 11.6 Wiki URL but no dice.I tried searching different combinations of domain model and by navigating the site but no luck.Thanks!Trevor

I have been playing with v11.7 of assyst and uncovered a few minor issues during the DB upgrade in a DEV environment (from v11.3.8), so I am just posting those for your information:The DB upgrade script fails when trying to add the stored procedure RESET_EVENT_HKS, which already exists in our schema.Mitigation: delete the stored procedure before running the upgrade.Long term solution suggestion: Ideally have the upgrade script always drop the stored proc prior to creation.Migration of forms will fail if they have multiple Web Custom Groups with the same label (in design mode), DB upgrade SQL fails with a duplicate error.Mitigation: before the upgrade, change the labels in design mode to make them unique, and then add the proper display label as a customization at the Global-English level.Long term solution suggestion: allow renaming of the label during DB migration to add a suffix, for example: “…_1”, “…_2” etc.

Looking to see if I can have a conversation with anyone who has leverage the JIRA event bridge in the legacy or ETM channel capacity.Are there any current assyst users who have implemented this in their instance? We have an internal business unit that is looking to hear from other assyst customers that have leveraged it and any lessons learned, etc.Thanks!

assyst workshop: Mastering advanced workflowsHi everyone,Are you looking to maximize your productivity and efficiency? We have just the thing for you!We are thrilled to announce a new workshop series for all assyst users - Uncovering assyst’s tips and tricks. It is aimed at helping you unlock the full potential of the IFS assyst platform. What will you learn?Discover features and functionalities of IFS assyst that you may not have been aware of. Learn practical tips and tricks to streamline your workflows. Understand best practices for using IFS assyst effectively.Don’t miss this opportunity to elevate your IFS assyst experience.The first worshop is taking place next week (Tue, March 26) and it will cover Advanced Workflows. Register here: https://info.ifs.com/assyst_workshop_Mastering_advanced_workflows.html and share the link with your colleagues! We hope to see you there!

We have a requirement where we want to fetch all the items that have word “MODEL” in shortcode. Is there a way to get this in ETM?

I know that there is a feature in Assyst 11.6 to add additional affected user but we are running 11.4.3 version which does not support this feature. We have a use case where end user will be creating a request in AssystNet and will input a additional affected user in a custom lookup field and we need to add that user as a additional affected user using custom script. Did anyone achieve this using custom script using restAPI or through ETM. Would appreciate help on this.

How do you handle responses to/from users on Tasks? We don’t have the Advanced Event Monitoring license for our users, but we have many processes that involve sub tasks, such as a user termination workflow. When our workers process those tasks, they may try sending a message to the affected user for more info, etc. Of course, the affected user cannot respond to the ticket via AssystNet. How does your team handle this for those that do not have Advanced Event Monitoring enabled?

Hi Everyone,I was wondering if anyone has been able to display the Section-Unit Manager as a default value in a customizer form. We want to have certain forms, not only be assigned to certain managers, but have those manager’s names be displayed on the form itself.So for example, if a form needs Director approval, we use:$new.affectedUser.department.section.branch.division.manager.shortCodeif a form needs Divisional Manager approval:$new.affectedUser.department.section.branch.manager.shortCode if a form needs Middle Manager:$new.affectedUser.department.section.manager.shortCodeBut for Section Unit, we have a problem...(Branch Unit and Section Unit are the same thing… not sure why a “label” was used)The section unit is that weird concatenation of section_sc and branch_sc, so we are not sure on how to get the correct “Default Value Expression” to populate the field with the Section Unit Manager, or if it’s even possible.Any help would be greatly appreciated.Thanks,Kris

Hi.  I’ve found that in an assystWeb form, since moving to v11.6 (currently at v11.6.4), if you select a lookup from a list the focus is always returned to the top of the form, rather than tabbing to the next field.  Is this correctable, please?Thanks,Steven

Has anyone using ETM/IPAAS run into an unknown error with creating events or in any integration use case really where the error cause is shown as follows?Looking to see if others are experiencing this issue or if it’s truly unique to an integration we had with a servicenow vendor and our assyst instance via AGS.All that displays as the cause in the failure log of etm is this:500 - <html><head><title>Error</title></head><body>Internal Server Error</body></html>

HiI’ve been looking at our Contact User form to update it for some new custom fields that are needed and, whilst it’s been amended, wanting to do a little tidying/hiding of fields we no longer use.  One that I noticed is the Order Approval Threshold field in the Organisation section.  When I looked in the Customiser, I realised that it doesn’t appear in the Form Content list so it can’t be managed at all.  Is this correct, please?  As we don’t use it at the moment, being able to hide it would be useful.Thanks

Hi Everyone,I’m in the process of converting our Mailbox Reader config and moving it to ETM.I was able to import the template channel/mappers and got one of my mailboxes converted successfully.However, my other mailbox is a bit more complex.I have an update_pattern setup with associated email templates like this in Mailbox Reader: update_pattern = { ["\< ACK \>"] = { UPDATE_ACTION = "SERV-DEPT-ACK", ACTIONIMPPROFILE = "MBR PULSE", description_template = "template/ack_template.txt", }, ["Response/Reponse: Approved /"] = { UPDATE_ACTION = "DEC-APPROVED_APPROUVE", ACTIONIMPPROFILE = "MBR PULSE", description_template = "template/approval_template.txt", }, ["Response/Reponse: Not Approved /"] = { UPDATE_ACTION = "DEC-NOT_APPROVED_REFUSE", ACTIONIMPPROFILE = "MBR PULSE", description_template = "template/approval_template.txt", }, ["Response/Reponse: Approved"] = { UPDATE_ACTION = "DEC-APPROVED", ACTIONIMPPROFILE = "MBR PULSE", description_template

Error in IPaaS log - I’ve been looking through the log for the reason for why I cannot get into AssystETM and came across this error. Hoping someone will have a suggestion of what this error means or what I need to “fix/update”. 2024-03-12T14:54:53,036 [CDT] | ERROR | Camel (importToolProcessingContext) thread #2 - JmsConsumer[jmshealthcheck] | DefaultJmsMessageListenerContainer | 248 - org.apache.servicemix.bundles.spring-jms - 4.3.5.RELEASE_1| Could not refresh JMS Connection for destination 'jmshealthcheck' - retrying using FixedBackOff{interval=5000, currentAttempts=0, maxAttempts=unlimited}. Cause: Error while attempting to add new Connection to the pool; nested exception is javax.jms.JMSException: Could not create Transport. Reason: java.io.IOException: Transport not scheme specified: []2024-03-12T14:54:53,052 [CDT] | ERROR | Camel (importToolProcessingContext) thread #12 - JmsConsumer[imports] | DefaultJmsMessageListenerContainer | 248 - org.apache.servicemix.bundles.spring-jms

Hi Everyone,We need your input as regards our current Java setup for Assyst and we would like to move to open JDK to avoid additional cost to the licenses on this versions.Currently  on java version "1.8.0_333"Java(TM) SE Runtime Environment (build 1.8.0_333-b02)Java HotSpot(TM) 64-Bit Server VM (build 25.333-b02, mixed mode) QuestionWhat are the supported open JDK version for java to downgrade to ? We are running on Assyst version 11.6.1 build 12635We also will like to downgrading to java-1.8.0-openjdk.x86_64 : OpenJDK 8 Runtime EnvironmentWould this work with Wildfly / JBos?Looking at the Wiki page it says it is supported howver not this exact version, we need your experience here if the current version we are plannimng to downgrade to works ok with Assyst. please this is urgent Thank you Abdulrahaman

On the IFS assyst Mobile app, once logged in to our site, the Home page shows the IFS assyst logo. Is there a way of changing that logo to be something different?  

I trying to extract the value of a custom field with property type “l: system lookup”.The lookup_VAL_ID does not seem to match anything in the jptsys_web_lkup_dataAlso what is weird is we are on 11.6.3 and table jptsys_web_cust_prop is not supposed to be removed  11.5 but it is there and it is populated with something!!!here is the SQL that I use to get the “Lookup_val_ID”:(select max(convert(varchar,jc.LOOKUP_VAL_ID))     from  jptsys_web_cust_prop_cont (NOLOCK) jc              left join jptsys_web_cust_prop (NOLOCK) j  on jc.jptsys_web_cust_prop_id=j.jptsys_web_cust_prop_id            left join jptsys_web_lkup_data (nolock) drop_dwn_val on drop_dwn_val.jptsys_web_lkup_data_id = jc.LOOKUP_VAL_ID           left join jptsys_web_lkup (NOLOCK) lkup on drop_dwn_val.jptsys_web_lkup_id = lkup.jptsys_web_lkup_id           where i.incident_id=jc.entity_id            and j.jptsys_web_cust_prop_sc='REGION'      ) AS "Region / Région",

We have a single select field with answers Yes and No, and use visibility expressions to display fields based on the Yes/No selection.  We've found that when (for example) Yes is selected and values are entered for the fields dependent on Yes, if you change your mind and select No, and then enter values for the fields displayed on No, when the form is saved, all the values entered for Yes and No are written to the database. We use powerBI for our reporting and wondered if there was a way to hide these hidden completed fields from the database or if there was a way they do not get written to the database? Below is a snippet from our test database to show an example of this problem.  

I am trying to write a report that extract a custom field with custom property type of ‘l’ which is no longer listed but was part of 5.5 for system fields.In any case it fills a “LOOKUP VALUE ID” which I am trying to look up but the data schema only say“The value of a Custom System lookup field.Introduced in assyst10 SP5.5.” What table(s) are associated with custom System Lookup?

We are looking for an action type which is not visible (in the action log) to other service departments. Never. Really Never. :-) Is this possible? I take it that action types flagged as private are visible to creating service departments and current assigned service departments. This is not what we are looking for.Take care,Mathias

I am wondering if there is a database table that stores the customization details done on particular aliases via the Customizer? For example, I am looking to find what fields are visible to which aliases on specific custom forms. Is there a table that stores this? I’m looking to do this on the Item A field specifically, which is a system field.So far I’m using jptsys_def_state_grp table, which allows me to find which fields have a customization on specific aliases. Now I’d like to know what those customizations are… My organization is currently on assyst 11.2.3 if that helps.Thanks in advance!

Hello, We recently upgraded our assyst production environment to version 11.6.3, and converted off the legacy numbering system. Since the change, our implementation of the assyst Mailbox Reader and our assystETM installation are both creating events which have negative incident_ref values. This did not happen in any of our non-production environments during our testing.A couple of examples are below:  Has anyone run into this before? Thanks, Duncan

Hello  Team we are creating an integration between our AssystApp and cloud app, we have issued a new public certificate and added it to the SSL Keystore  I can see from my browser the certificate is installed successfully and appearing but when we trying to trigger the API using AssystREST the vendor team are getting this error  ::::JBO-29000: Unexpected exception caught: javax.ws.rs.ProcessingException, msg=javax.net.ssl.SSLHandshakeException: Received fatal alert: unrecognized_name  to resolve this issue I’ve added these llines to standalone.xml but yet it is still not workingany ideas ?             <server name="default-server">                <http-listener name="default" socket-binding="http" redirect-socket="https" enable-http2="true"/>                <https-listener name="https" socket-binding="https" security-realm="ApplicationRealm" enable-http2="true"  sni-host-name="true" />                <host name="default-host" alias="localhost">                 

Our Web Tutorial section of the Assyst Web Homepage has a list of Knowledge procedures that appear in a near-random order.  Is there a parameter or setting that determines what order this procedures are displayed?  Ideally, we would like to have them in alphabetical order, but also add “New” procedures at the top for a determined amount of time.

Hi All,  How to mask first 6 digits of a 10 digits number added in a field of event raised by a customer.  Digits should be hidden from the service desk ticket in assystWEB. i.e. Number to be hidden:SSN : 1234567890 After hidden:SSN : XXXXXX7890 Kindly advise. Regards,Nuwanthika