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

Is it possible to use sums on fields in workflows? Here’s the SQL query for what I am trying to get using workflows:select sum(quantity)  ,activity_seqfrom SCH_OF_WORK_EST_RES_SUMwhere project_id = <<project id here>>and resource_type_db = 'PROJECT_RESOURCES'group by activity_seq So I would like to get the sum of the PROJECT_RESOURCES values for each particular activity sequence and then insert this value at the activity level to a certain field.  Trouble is, I don’t know how to get the sum using workflows.  I’m sure it’s somewhere in the documentation or examples, but I’m not sure where. This is the entityset I’m pulling the values from currently: ${Reference_SchOfWorkEstimateResourceSummary_Set[0].ActivitySeq}$[Reference_SchOfWorkEstimateResourceSummary_Set[0].HoursQuantity}  

I am trying to create a before workflow that will change the MchCode value entered by the user to something else.  At first, I was getting a recursion error by calling the FunctionalObjectHandling projection for the create.  That obviously didn’t work.   Does anyone know how to have the workflow just change the variable on the way to the original projection call?  I tried just using a workflow with a script component to make the change and I can see the change in the observation but that isn’t actually what is saved. We are in Cloud 23r1.

Hello,I now how to create a Command and add it to the command group but I would like to something like the screenshot below, which is to link with a Link Navigation the record value, how can I do this?  

Hi allIFS Apps10 UPD15We have recently updated our Delivery Note Crystal report and added some additional views to pull in some extra data we require. The report runs ok locally in Crystal Reports running as the IFSAPP user, but fails when run though IFS with error: No pdf report returned from crystal web serviceI have turned Crystal logging on which shows error: ‘The table could not be found’. Detailed screenshot below.From the log it seems to show successfully getting access to a number of views but then hits a problem with CUSTOMER_ORDER_LINE_CFV. The view definitely exists and I don’t think this is a permissions issue as they look the same across other views the log seems to show as being ok, but I don’t know where to go now. Searching the forum hasn’t turned up anything similarDoes anybody have any suggestions as to what the problem is?Thanks in advanceChris  

Hello,We are trying to test IFS10 Mobile Applications on IFS-TEST environment. I have installed TouchApps Server according to documents. I can access customer portal screen without any certificate problem over laptop.I installed same certificates to android phone with root ca certificate but IFS10 Account Manager is giving an error like that.“Could not establish a secured connection with the Identity Provider”I tried to access TouchApps server over the phones browser. It is showing NET:ERR_CERT_AUTHORITY_INVALID error, but i can ignore it.I am stuck at this point of installization. Do you have any suggestion?  

Hi, i have implemented a lov field in Project definition page wich contain the addresses of all customers and i’ve managed to successfully filter based on the customer that is currently selected  but part of my requirement is to also populate that field with the address for that customer that was selected in bussiness opportunity, i have also created a field that references that address and im getting the address id succesfully but how do i use that ID to set the default value for the field?Currently the project created has the field ad the end of this group emptyand we want it to be this way, with the address that is comming from bussiness oportunity​​​​ 

We are currently calling IFS REST API CustomerOrderHandling.svc/CustomerOrderSet from our external tool to create customer order.The Customer Order Set POST method allow to creat one single order, is there a way to pass multiple order information in the same call? like an array of orders to create.  

Hi all, Is there anyone who can provide me the all steps to Initiate a prepare database for IFS 10 Thank you

Is it possible to delete the measured value from the measurement history at the test point of the object? I can only mark the value as wrong.The integration API contains "Delete entity from EquipmentObjectMeasSet", but it returns an error:There are many measured values ​​at the test point in the measurement history, and since the older values ​​are no longer needed, I would need to delete them.The second reason is that I write the values via RestAPI, and if the test point has an extensive measurement history, the time to write a new value is disproportionately extended.deleting the record from the measurement history.So, is there any possibility of removing the measured values ​​from the measurement history on the object, or will those records remain in IFSCloud forever?

dear all, we want to create an event below.I need a SQL query and steps to create this. I would be very happy if you could explain it step by step as I am a beginner.When a purchase request is created for purchasing materials with a standard package size larger than 1, we want the user to receive a warning on the screen: 'You can only enter the quantity in x (standard package size) or its multiples of the purchased material. 

Hi, I’m trying to pass an aditional header key to a http call from IFS9. If I use the below Routing Address, my additional header parameter will show in options in the response, but if I look at what headers IFS is actually sending it is not there. I send the request to an http endpoint that i control and read the headers from there. Here are the headers: {"Accept":"text/html, image/gif, image/jpeg, */*; q=.2","Connection":"close","Content-Length":"43","Content-Type":"text/xml; charset=UTF-8","Host":"***.pythonanywhere.com","User-Agent":"Java1.8.0_60","X-Forwarded-For":"***.***.***.***","X-Real-Ip":"***.***.***.***"}    I need to send an aditional key. Can anyone help explain how to do that?    

We have granted the activity “VirtMapPositionManagement” to a permission set but with this action user can see the map position as well as insert and update the position. We want to give users read-only access.Can we grant the Map positions as read-only? Thank you in advance for your help and support. 

Unsure if I am missing something. Is there a reason why the Startup behvaiour section isnt available on some screens?Part Cost as an example below, 

Dear IFS experts,I get an error message when refreshing the cache:Can somebody support?

Do you have to have ‘administrator’ system privilege to be able to modify ‘Scheduled Database Tasks’ set up by another user?Re help notes: View Schedule: navigates to the relevant task schedule. Once the task schedule is opened the schedule can be edited if necessary. but editing of the schedule is allowed only for the creator of the schedule or an administrator. User receiving the error ‘You are not allowed to change this schedule XXXX, since it was not scheduled by you’. 

Hello, I am getting the following error when trying to set up a lobby element of type Power BI.It seems that the Data group is having loading issues.Also, we successfully set up a Power BI report through Report Manger.It can be viewed via Power BI Reports without errors.Help woul be really appreciated for this matter.IFS Cloud version : 22R1SU17Regards,Trishen

Hi All,I’m trying to find a way to get a table sorted (decr) at the opening of a specific screen (Shop orders).I’ve been through a lot of topic, but cannot find my answer nor a list of syntax possibilities. The issue I face is not about setting a behavior at the page startup, which can be done easily, but rather how to sort a table based on a specific field (Start Date) with advanced search. If someone has an idea about that or documentation about IFS Aurena Advanced search (no SQL), I’m all ears ! Thanks, 

We are trying Use the IFS restful APIS via odata in Excel. Is it possible to use SSO for this type of connection? Please note this is IFS application 10 .

All the columns have disappeared from the Remote Warehouse → Users Screen. I am unable to RMB in the grey space to select Column Chooser. When I try it just adds a new record to the screen. How do I clear this in User Profile?Thanks, 

We are on 23.1.8 and have started the release update process to move to 23.2.5.When we reach the Order Delivery step, the job runs for approx. 5 hours and then fails.The error log shows 2 issues, one with core IFS code - we’ve been advised that will be fixed in 23.2.6 and one relating to an area we have developed, which will need to be redeveloped once we have updated to 23.2.X.Rather than waiting until 16th May for 23.2.6 we would like to ‘delete’ the release process we have started in Release Studio and try again with an earlier 23.2 release (23.2.4 for example).Is this possible?  If so, how do we do it?

Hi, I’ve had a look and a stab but looking for some assistance...I have a new process going in, which requires searching on the ‘Receipt Reference’ field of the Manual Supplier Invoice when matching the invoice.The PO number is not, and can not be, brought though when created via EDI.Can anyone advise how in Apps10 you can Index a field so it will search faster. The process works perfectly, but with the delay to search it will kill it from an End-User perspective.Thanks as always, Matt

Hi there,I hope this message finds you well. I'm currently working on setting up a system to send monthly emails to all employees. However, I'm facing a challenge in compiling the list of employee emails to include in the distribution.Could you please provide guidance on how to gather the email addresses of all employees and store them in the 'emp_mail_' variable? Any help or suggestions would be greatly appreciated.Thank you in advance for your assistance.Best regards,Deepal emp_mail_:=  'a@gmail.com' , b@gmail.com,c@gmail.com' ; COMMAND_SYS.Mail(sender_      => 'IFS Applications!',                 from_        => '&USER_EMAIL',                 to_list_     =>dest_mail_ ,                 cc_list_     => '',                 bcc_list_    => '',                 subject_     => 'text',                 text_        => 'Text',                  attach_      => '',                  rowkey_      => '',                  mail_sender_ => 'MAIL_SENDER1');

Hi everyone,I have a IT1 apps10 testing instance that until recently was working fine, now all of a sudden certain deployments have stopped working - namely ifsapp-main (in MainServer), ifsapp-int and ifsservices in IntServer.  When I try and restart them I get the error “ Error occurred while performing startApplication : Failed to start the application with status failed”Can anyone point me in the right direction to sort this out?

Hello, Regarding SSRS Quick Reports in IFS Cloud,When we run a SSRS report from the quick reports for the first time it asks to enter the SSRS username and password, but it would be all good for the rest of the session.But ones we log off and login it is still asks to enter the username and password. Is this the intended behavior or is there a setting which we can use to avoid this?

Hi AllI am faceing ”SEARCH_DOMAIN_ERRORS” while i trying to build the IFSPROD environment.Does anyone have or idea? How to resolved? Environment : Linux Oracle 19.16c ,Ifs bulid APP10UPD11 Deploy IFS Applications Database Objects**********************************************************************!!!Error deploying file fndbas\ApplicationSearch.apv at 27-OCT-22 17:51:18!!!Error occurred while executing Plsql BlockDECLARE   PROCEDURE Alter_Column_Comment (      view_name_   IN VARCHAR2,      column_name_ IN VARCHAR2,      comment_     IN VARCHAR2)   IS      stmt_ VARCHAR2(32767) := 'COMMENT ON COLUMN ' || view_name_ || '.' || column_name_ || ' IS ''' || REPLACE(comment_, '''', '''''') || '''';   BEGIN      EXECUTE IMMEDIATE stmt_;   END Alter_Column_Comment;BEGIN   Alter_Column_Comment('SEARCH_DOMAIN_ERRORS', 'search_domain', 'PROMPT=Search Domain^');   Alter_Column_Comment('SEARCH_DOMAIN_ERRORS', 'index_name', 'PROMPT=Index Name^');   Alter_Column_Comment('SEARCH_DOMAIN_ERRORS', 'text