Thanks, we were missing the ‘&logintype=tech’ Curious as to how we should have known to add this to the end of the standard web client url?
Hi,I have used the above code and it does what I need in terms of reading the list items. Now I am trying to update them. It is a list of tasks which I want to set the status to complete in bulk. I can get the value to change on the form but not commit to the db. Here is the code I have been trying with (you can see from the comments the various attempts) Any idea how to get this working? This is being run in the TechPortal var rows = getSearchResultDataTableRows();var noTasksToComplete=0;if(confirm(getMessage('BULK_COMPLETE_CONFIRM','Information'))) { for (var rowIndex = 0; rowIndex < size(rows); ++rowIndex) { var row = rows[rowIndex]; var status=row.data['task.user_def2']; if(status=='Y') { var taskId=row.data['task.task_id']; //var rowId = getDBValue(stringFormat("select metrix_row_id from task where task_id = {0}", taskId)); //Set Status //var taskStatusTrans = generat
@Lee Pinchbeck Tried it with less than 350 records, same thing. Cant see any app param that sets this. This is on the Customer Portal Web Client. Smart client works ok
Hi @AdrianEgley, Thanks for your prompt response. I tried your XML code and it indeed worked a treat! Hi @Rwjgoedhart, Thanks also for your reply! ...i have a question however: usually the parameters would be passed in like this » @task_id -so how does it resolve the ‘@expression[task.request_id]’ how does this expression know which task it is looking at?
@Rwjgoedhart@AdrianEgley Just tested Rudy’s implementation and it works great too, ill be going with that one as its much simpler. Adrians solution was also very helpful as it has helped explain a bit more about how these things work. Thanks again guys.
Hi @Lee Pinchbeck , I had logged it as an issue as you mention, but it just got closed without being looked into. Could you reopen it and flag it for further investigation please? the case number is G2223178Thanks, Martin
@Lee Pinchbeck@AdrianEgley@Mike The FSM TechnoGeek Heres the script, the commented out section is where i tried it with an update statement. The issue is purely that it will not save the changes (They update on the screen). A Save button added to the screen also did not work.var rows = getSearchResultDataTableRows();var noTasksToComplete=0;if(confirm(getMessage('MF_BULK_COMPLETE_CONFIRM','Information'))) { for (var rowIndex = 0; rowIndex < size(rows); ++rowIndex) { var row = rows[rowIndex]; var status=row.data['task.user_def2']; if(status=='Y') { var taskId=row.data['task.task_id']; //var rowId = getDBValue(stringFormat("select metrix_row_id from task where task_id = {0}", taskId)); //Set Status //var taskStatusTrans = generateDataTransaction("task", "UPDATE", stringFormat("metrix_row_id = {0}", rowId)); //taskStatusTrans = addToDataTransaction(taskStatusTrans,
Hi @Mike The FSM TechnoGeek Thanks for the reply, however it doesn't seem to work for me. I cant see why, your code seems to make sense. Does the batch update need a commit action maybe?
Just to add, it is running internally on our domain. The emulator is setup to launch from command line using our DNS servers.
Hi, We setup a custom screen design and pointed the existing combobox to our custom global_code table using the fieldvalues in the UI Designer screen. Then, in Cuastom Meta data for the Project screen i tried defined a column def record for thast field and added a lookup for the new Global_Code list
Hi, thanks for the detailed reply. I have it setup exactly as you suggest, the only difference is that, in the screen design, the definition for the custom Global_Code table is not in the ‘Server Defaults’ section, but the upper section. The ‘Server defaults’ is not editable.
I just remembered how to achieve this. In the Person record for each customer user, you add (or not add) the ‘REQUESTCREATEUPDATE’ on the ‘Role’ tab.
@gapzop How did you overcome it?
@gapzop Okay, I overcame it by modding the app. The problem for us was that the Android Download Manager would not work with our Dev environment Network, it would just queue the files thinking it had no Network connection.I modified the app to bypass the Android Download Manager (files are queued in two places within the app) and used a file stream to stream the files form the server into the desired location on the device. You then have to add code to process the files (unzip, tell system datatbase is downloaded etc) as this is usually done by a notification from the dowload manager (which obvioulsy no longer happpens due to the mod) This mod worked well for us.
Fixed this by adding certs to the Gradle cert store
Fixed, Contract had gone into POSTEDIT for some unknown reason.
@Ruchira Jayasinghe Thanks for the response. We have now discovered however that it is not attachments that were causing our original issue. We had an error popup (timeout) and initially thought that it was the attachments not loading, but it is acutally the code that displayes the created date on the page for the Notes, we have 64 notes on the particular request. If we remove the code that subscribes the created_dttm field on the form then the request appears without issue and all the attachments load a lot more quickly
Hi @Atheeq Maharoof , This is exactly what i have tried, but the Script does not execute on the Smart Client even with ‘TextChanged’ added (i have both ‘TextChanged’ and ‘AfterValueChanged’ set up on the field in the UI designer) Even a simole client script with just an alert as you described will not fireRegards,Martin
Okay, so i tried that and that works although not what i am looking for (i need an ‘AfterUpdate’ not having it fire everytime the user presses a key) I am trying to use the script on the project screen on a custom date time field. We have two fields (a start and an end) i am trying to add validation to compare the two to ensure that the end time is not before the start time. The ‘TextChanged’ trigger does not seem to fire on these fields at all. The Lost focus does and almost does what i need, but the fires when the date time lookup is clicked which is not what i want. I need it to fire after the new value has been entered and after it has been entered, not as it is being entered.
Hi @schuster, This is client side validation. We are trying to validate entered data on the smart client before it is saved. When a client script is attached to the save button, does it perform the save first? or the script first? Martin
Hi @Atheeq Maharoof Thanks for the detailed reply. We need to do it in the smart client however, will the same solution work there too?
Hi @Shneor, I work with Angelo and have just done some more testing on this. Here are my findings.If you change the Approval Status on the Project directly on the field on the Project screen. The Notification goes out correctly with all values.In our application, the Project Approval status is typlically changed via a business rule triggered from TASK. The XML for this rule output looks like this<update_project><project><project_id>@project_id</project_id><proj_status>OPEN</proj_status><approval_status>SUBMITTED</approval_status><update /></project></update_project>This update is then captured via a second Business Rulke that send out the Notification (the same rukle that send out the notificaiton in step 1 above) However, now, the values User_def1,user_def2 a d created_by are left blank! If i run the XML from the first rule in the XML Poster, i get this result<update_project_result> <project> <proj
Hi @Lee Pinchbeck , Thanks for the reply. The thing is, the Notification Message doesnt even pick up the previous values on the Project record, all the fields that are not populated are mandatory when creating a new Project. I could understand your suggestion if the previous values were there instead, but we just get blanks. As for your secioind point, ,i just copied other rules that were originally setup by someone other than me, but i will look into doing it how you suggest. regards,Martin
Hi @Lee Pinchbeck ,Yes, see attached screenshots for the setup. Not sure how i would attach it too the output as you suggest, but i agree thats how it appears. I suspected it maybe how some BR internals work withing the system to save round trips to the server? See attachments for the setup regards,Martin
@Lee Pinchbeck Correct attachmwents added now
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
