Nevermind, got it working
Thanks @Shneor Cheshin, apparently I was already very close. But with the help of your example I was able to make it work!
@mkuehnl@Anjula Priyanath How did you setup the sync rule? At my side, after a initialisation, the attachments are not synced to the mobile device due the attachment sync rule.
@Shneor Cheshin Type of sync error doesn’t matter, happens if there is 1 or more error(s). It also doesn’t matter if the stuck messages are related or not (e.g. same task). I reproduced it with the default IFS design, by adding a savechanges() update script to a custom button. setControlValue("task", "task_status", "ACCEPTED");var res = saveChanges();I beginning to beleive it’s a IFS baseline bug, it’s working fine in Android (as mentioned by @SAMLK). I openend a case at IFS already a while ago, but no solution yet.
@jevin.fernando Thanks, that worked!
@Lee Pinchbeck, Because then we pick the most up to date last sync date, not the sync date that’s connected to device X. Will it be correct? Probably most off the cases.However next to that, it seems that the last_sync_dttm from person_mobile isn’t updated in mobile if you query it (in mobile). The sync rule is on Real Time on is sending all records (*). In short regarding the use case:Sometime a tech is in a area without any mobile coverage. So the app in in “offline” status. Also we had some rare cases that the app is stuck in ‘offline’. We want to display the status more clearly to the users.
@Lee Pinchbeck, thanks. so I guess to is no way to identify the current device the user is currently using. Besides checking the last sync date time, which is not preferred.
Hi @SAMLK,Tanks, I can overwrite the values, but indeed empty values are not allowed. It seems only possible to force an empty value by sql. That will leave a empty space (field) on mobile, it will not hide the field.
@SAMLK ah ok. Thanks!
Hi @SAMLK ,Thanks. do you mean to create a custom view? I believe it’s not possible to use a calendar in a custom view. Regards,
Hi @BrianG ,Thanks,“It is common to create a view to sync to mobile if you only need to view the data and not update it in the mobile client”We have a scenario where we the data also can be modified/deleted. A batch all isn’t preferred due to performance. But I understand it’s not possible with a custom view, I need to create a table for that. We don’t have enough permission to create a new table via SQL Server Management. Do you know if creating a table via SQL will work? For example:CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype,);
@Shneor Cheshin You can set the flag ‘Required’ to false, for field TASK.TECH_SIGNATURE_ID. This was not possible on the previous screen (DebriefSignature)
Hi @BrianG ,Thank you.“The sync rule must be based on a database TABLE for inserts/updates/deletes”Is it possible to create a new database table, besides via a sql view with a custom metadata?
Hi @Shneor Cheshin, We want to achieve that a user can call a set of data via mobile.Which then is getting synced. This way we won’t have to import large sets of data, but the user can call them on demand
@brian.gummin “As an Attachment API List screen, the Task ID is no longer used in the file name. The new file naming convention for Task attachments is task_{PersonId}_{DeviceSequence}_YYYYMMDDHHMISS.” Do you know if there is an way to add the task ID or relate the attachment to thet task ID? We need to add the signature to the task attachments, But there is no way to identify the task anymore
Issue was using the deprecated screen “DebriefSignature” , instead of the new “DebriefReview” screen. The new screen however, handles the use of the Technician signature differently.
@nimesha.kalinga thanks!
Hi @nimesha.kalinga ,Thanks for the reply. Is there something missing in your query? Because JulianDay is not definend? “'JulianDay' is not a recognized built-in function name.”
Hi @Kalpani Dissanayake I understand that. But I don't want to change the number of days, those are fine. But also based on a condition. Like don't count if task.type != repair.
Hi @Kalpani Dissanayake Thanks, but those only contol the amount of days. I want also to exclude some tasks by condition. Isn’t there somewhere a query that is managing the count?
Just discoverd that when you tilt(rotate) your phone, the scripts are then suddenly start working...
Hi @Marcin Drozdowski Xml is fine, and all parameters are included. I also have an extraxt rule. Is an Batch-Delta sync rule only for updating existing records, and not capabele of sending a DELETE transaction?
Hi @nimesha.kalinga, Thanks, that worked!
Hello @Shneor Cheshin It will show the ID’s, but now the variable will only contain the last value from the loop. In the end I would like to have the variable “myID” containing all ID’s from the loop.
Seems when no records are found, there is no push.
Already have an account? Login
No account yet? Create an account
Enter your username or 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.
