Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Hi All, One of our customers have raised following concern,“is there a function in IFS that can accept SQL statements and return the results in a table format?”Does anyone have an idea about this? 

Hello all,I had a working Report Designer on my old laptop (Win10 Pro). Since I have a new laptop (Win11 Pro) and installed the Report Designer again, the application starts correct but I cannot connect to IFS. I have looked into the other questions on this forum but the solutions mentioned did not work for me. Can anyone help me out ?System is Win11 Pro, IFS10 Upd10, Report Designer as shown below.  I also have PL/SQL and the Oracle client installed, that works fine. Also connecting Excel to the IFS database gives no issues. Just the Report Designer fails.  

Hi All,Is there any way to define a sample values specially for TEXT fields in the projection attributes so that it can be viewed from API Doc Viewer?Currently you can only see ‘It is a Text’ but customers prefer a sample value instead.e.g.Post Code: “SW1A 0AA” 

Can I check if Oracle Java (JRE, SE & JDK) is used in IFS Cloud application? Meaning installed in any of the servers (Mgmt, App, Artifact & DB) in client hosted AWS server even in client PC/Laptop? If yes, any replacement such as Open JDK such as Redhat JDK or Amazon JDK (Amazon Corretto)?

Hi, It does not appear when I add a new method in the service file I created. After first creating the service file and sending it to the databaseI'm adding a method to the projection file. In the plsvc file, I specify the data that the method will bring. The method I just added to the svc file I opened with the open api does not come.I'm waiting for your help.

Hello,Where can I find and modify the entity “BusObjRepresentativeOrderQuotation”? On the Representative 360 page, on the sales quotation tab, I would like to add a field for created date, but there doesnt seem to be a way to. The Entity is not listed on the entities page nor on the entity configuration page where I would like to add a custom field to said entity.Any and all advise would be appreciated.Thanks,Bryan

Hello, Why can’t I find api explorer window in IFS10?See attachedThanksRoss 

Hi I’m trying to automate the AnalysisResult with the projection AnalysisResultHandling.For now i’m unable to store the result values in the control plan.Are there any documentation how to create a analysis based on a contol plan and the upload the result with this service?I can see the QmanSampleValue and change it but its not seen by the aurena interface.? Like the binding between the analysis and the result is missing. If I use the aurena debugger i can se it call thispatch /AnalysisResultHandling.svc/ResultDataVirtualSet(Objkey='FFD1F40E0D880120E0530A0C0847CC2E')/VariableResultsArray(AnalysisNo=18008,DataPoint=4,ResultNo=1)?odata-debug=json"get "/AnalysisResultHandling.svc/ResultDataVirtualSet(Objkey='FFD1F40E0D880120E0530A0C0847CC2E')?odata-debug=json"post "/AnalysisResultHandling.svc/ResultDataVirtualSet(Objkey='FFD1F40E0D880120E0530A0C0847CC2E')/IfsApp.AnalysisResultHandling.AnalysisNormVirtual.CompleteNormVi

Hi, I’m trying to set up a event action. I call a REST endpoint from my event action.I try to format my POSTed message as json. How can invalid characters, like {} “, in my data be handled? Is there a function for escaping texts?Thank you!

Hi,Any clue how this could be done in an easier way?SELECT SUBSTR(string_x_,                                                                    -- 1st param for SUBSTR                                (INSTR(string_x_, 'IDENTITY') + 9),                        -- 2nd param for SUBSTR                                (INSTR(string_x_, '^', INSTR(string_x_, 'IDENTITY')) -          --3rd param for                                  (

When using active directory user integration on IFS10, we have a requirement to use an extension attribute from active directory to be used for FndUser.DirectoryId - active directory attribute. This is failing due to the error “Reference to an unsupported AD attribute”. Please advise if you had a requirement like this and encountered the same error. Was it resolved on IFS end or with Active directory settings? Thanks in advance!  

Hello,Is there a way we can link the entity ‘SurveyAnswersEntity’ which is in projection ‘WorkTaskSurvey’ with entity ‘JtTask’ in projection ‘WorkTaskHandling’? Currently, we have the entity ‘JtTaskSurveyAnswers’ which can be linked to ‘JtTask’ but there is no Description for the survey answer in this entity. Therefore, we would like to link these entities to fetch the description and other required information from ‘SurveyAnswersEntity’.Please let me know if there is a possibility. Kind RegardsPriyanka Cecilia

Do we have a way to show Admin Customer (IFS Cloud / IFS Cloud Services) basic system information ? Memory usage, CPU usage, list of most bigger tables/files. Customer only get an alert when memory usage is greater than 90%, but would like to monitor the instance memory usage.  

Hi therehow do i find the ‘“GetPartyTypeWidgetInfo” projection in cloud please, i cannot seem to find this projection , would appreciate a screen shot please ThanksM

As far as I can see it is not possible to edit the Characteristics Template in the Aurena Assortment masks:  In the Enterprise Explorer it is possible to modify the charateristic template:   Is there a work around for the Aurena Client that I did not find?

I have IFS Cloud 22R1 installed in a Cloud (VM) service provider and for the moment there is no reverse proxy server. No DNS settings setup yet.We can access IFS over the internet, with a host file entry at local machine, since we have a public IP at MT server (Ubuntu). Local machine host file is as below.222.123.188.199 is the public IP as shown above. (Not the real IP I’m using)I can load landing page as below.https://xxx-tst.xxxxxx.cloud/main/ifsapplications/web/startI have configured with Azure AD and if I tried log in with Azure AD, I’m getting an error.

Community,Trying to set up ZPL printer in IFS, and follow a poster to set up in Application Server Task, but I cannot see job type “PrintAgent” in Job type drop down list. question:why we cannot see this PrintAgent job type?  if we need to install Print Agent, where to install? IFS application server or end user client? should PrintAgent is mandatory? our company seems like never install PrintAgent before, we still can print report via network printer.Thank you.

Hi all, I am interested to know if Aurena Bot is still an active part of IFS Cloud solution (23r1)? There doesn't appear to be much documentation about it from what I can see, and any use cases, or examples. So I was wondering, is it something IFS are planning on decommissioning?

On the Available Lines for Shipments page there is a field named Available Qty, but I don’t know where it’s coming from - the View is SOURCE_LINE_SHIPMENT but that field doesn't seem to be in that view. It also doesn’t appear to be a custom field. Does anyone know where that field is coming from? 

Will I ever learn to love Cloud over IEE?  I’m looking at a Routing for a part number 123-XYZ-NN66-8579/A.  I want create a new Inventory Part for  123-XYZ-NN66-8579/B.  How I long to be able to highlight the part number in the Routing, click CTRL+C and then open the Inventory Part screen, click ‘+’ and then CTRL+V.   If anyone has a similarly slick alternative I’d love to hear from you Thanks, Community!:-) Linda 

I have set up all the fields within a form and have saved this as a temple. This took a few hours to create, and I want to see if there is an opportunity to share this with other users in my team to save the pain of having each user having to set this up 

Hi,I’m not sure whether or not i’m imagining this but….When you select a quantity of for example Purchase Orders to be printed even when they are sorted into Order No. on screen you then select ‘Print Order Work Copy’ to print the orders and they print out in a different order than what was selected (sorted).Is this something that anyone else has come across or is it just me ? Ordered by Order No. 

Hi. I have an customer that tries to use barcode 3 of 9 in a crystal report quick report. We have installed the 3 of 9 font into the server running the crystal report webservice, and also installed it into the client machine. Still the barcode is just presented as *<number>*. Is it not alowed with custom font’s in IFS cloud?Do we need to add the 3 of 9 font into any of the docker containers (IFS-REPORTING-CR) and if that’s the case how to do it? Bug??

Hello All,There is a limitation in Cloud that we cannot add/update custom attributes to JtExecutionInstance entity. Therefore, I’ve created a custom entity and associated it with JtExecutionInstance as shown below.Custom Entity: Created a custom entity with few attributes. Projection Configuration: Created a projection configuration and linked both JtExecutionInstance and STJtExecutionInsExt. Page Designer: Using page designer in Work Task screen, I’ve created a List for the custom entity. Added this list to the Assignment tab as shown below with the Binding.

Hi, I have a validation field in the application interface as follows: Respective value for the each field will be set as a string from the backend(.client or .plsvc file). Just wanted to know is there a way I can get to translate the highlighted content of these fields(eg: Value Required)? Thanks in advance! Regards,