Thanks @SAMLK I tested with the map option, but I think when you specify a primary path that is different to the table name, it doesn’t work , where it still tries to do an insert/update Attempt1 (without specifying the map) Attempt2 (map specified. Tries to do an insert)Maybe you can try the same by changing the primary path to something else in your example..Also, I tried the JSON syntax and it didn’t work. I guess that’s not supported :/
@SAMLK Thanks.I tried it and it worked as following, A couple of things,looks like there isn’t a way to get this to work with a map yeah?and would you know the syntax for this in JSON?
@SAMLK I didn’t have it setup with only the allow delete option. But to test your suggestion, I did that But looks like it still tries to update
@Shneor Cheshin sorry for the late reply. got distracted with some other stuff.Thanks for that reply.Your view would work. But as you can see, now we have to hard-code the timezone, and this isn’t really ideal. I had a similar workaround applied already, by adding 11 hours to the plan start date because I know that’s the time diff with UTC 😅.But this doesn’t work, since within Australia itself there are different timezones from which users access the same application. So, I guess this is something that RnD will definitely have to solve, as this is such a small issue that’s causing big pain! For now we have reverted back to the dateonly mask to get rid of the time part altogether
@Shneor Cheshin “As I wrote, you will need to cut the values. I suggested substring expression, but need to test this approach.”I tested this, but still doesn’t work because the string it cuts the values from is itself incorrect. In the above screenshot I have attached you can see how the user_def11 holds the business rule string converted value, and how it is incorrect to start with (27th instead of 28th).Same happens with the SQL query, any sql function used is applied on the server which holds datetime in UTC 😪
@Shneor Cheshin Thanks for the response. The issue with the dateonly mask and its handling of the dates falling in different timezones is a really frustating bug.We changed the field mask from dateonly to datetime to sidestep this very issue. But now we’ve run into to the issue of filtering for plan_start_dttm irrespective of the time. I gave a try with your suggested options.Business rule with a string user_def doesn’t seem to work because it still “sees” the UTC time. I believe by ‘SQL script’ you meant client scripts? Client script would pick up the client time, and probably we can do this on a screen event. But this wouldn’t be practical for adjusting for all the existing data 😒This seems to be quite the challenge 😐
@Shneor Cheshin Yes, both custom metadata and UI designer were set to dateonly for the field. @Morris The user computer is in the brisbane timezone (utc+10). The database stores the utc time. so, whenever a dateonly mask is applied to a date field (plan_start_dttm in our case), and we try to save it at such a time where the client day and the utc day fall on different days (in our case before 10 a.m in brisbane), the client shows the date only part of the utc date. But, when we have a datetime mask applied instead, the dates are shown as per the client’s timezone.
@Shneor Cheshin This can be observed under the task tab of the request screen,
@Shneor Cheshin Thanks.In this ticket which is kind of similar to this, you have answered as following, 2 options I can suggest:Create a “regular” field and set it’s URL with a business rule or client script. Create a client script and set the URL dynamically. Set the script on any event you wish.I’m curious about the 1st option. Is it possible to set the URL dynamically for a regular field with a B.R or client script?and by url, did you mean this or this?
@Shneor Cheshin interesting.Can you show the configuration for the double click setup? (does this also work with a field on the header level?)
Hi @Miraj Try out this query on your SQL query tool so that the same query must work on the package deployment. IF OBJECT_ID('c_data_view') IS NULLBEGINEXEC('CREATE VIEW c_data_view AS SELECT TOP 10 * FROM REQUEST')ENDELSEBEGINEXEC('ALTER VIEW c_data_view AS SELECT TOP 10 * FROM REQUEST')END make sure the package deploying user has the EXECUTEDBQUERY, EXECUTEDBEDIT functions enabled under the role Thanks mate. This works
@Shneor Cheshin Thanks. yes, running separately works. although, I am trying to use a “create or alter” type of statement to get this to work in one go. To give some context, when we create views and the corresponding metadata for it, we can save the view script as following So when we deliver to another environment, if the sql against this Table Script is present it automatically creates the view. The issue I have is when we make changes to an existing view and update the table script with a new sql. Now, “Create VIEW” no longer works becasue the target environment already has the view, and thus our changes don’t get automatically deployed upon delivery.This is why I was exploring the option of using “CREATE OR ALTER” so that it would create if the view is not there or alter it if it were there.
@Shneor Cheshin
Thanks @Shneor Cheshin
Thanks @JuniSihombing @Shneor Cheshin
Hi @Shneor Cheshin,One of our customers has reported the same. Do we have any updates on this? I am not able to see the above logged ticket due to access limitations.Is this identified as a bug?
@João Martins Sorry for the late reply, I checked what you’ve pointed out and I see that the response for errors are sent in text format instead of xml. This I believe is something IFS needs to fix (may you could raise a ticket). Should be a pretty straightforward fix from their end
You could use the url “M5WebService.asmx/ProcessMessage” with authorization info under the authorization tab
Thanks @roklde 🙂
Thanks for that detailed answer @Shneor Cheshin
@Hasara Dinu Thanks for that. I believe this works with an SQL type function but not with an XML one .The reason I am using an xml function is because I want to extract a value from the function response and set it to a field and this needs to be done before mapping.
@Anjula Priyanath So in your case, did you have to rebuild the apk (like doing a customization with Android Studio etc) ?
@Shneor Cheshin Yes, for most of the fields I use the mapping tab, which works fine.The scenario here is, I’m trying to create a part with a supplier part. when I do this, if the supplier does not exist I want to create the supplier first using a process (integration function) and then use the created supplier_id in the supplier part creation. so, I am trying to pass the values needed for the supplier creation function, from the csv.
@Shneor Cheshin So as per the screenshots I posted, I’m trying to get the values from the csv file for those respective fields and pass it on to the integration function.In the example above, first row of csv:supplier (TRN_SUP04) address_id (1121)phone (452544356)
@Saranga Amaraweera Thanks heaps for this wealth of info!
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.
