Hi @Naveen Boga ,Thank you for the response, Yes I have tested without where condition and then it loads values without any issue, but with the where condition it shows nothing.Hi @sweta68 ,Thank you for the response, I will test your solution and let you know.
@Django , @NaveenThank you for your suggestion, but I cannot find AutoRefresh property for sequenceID field. is this because of it’s a custom field?
Thank you @Naveen Boga , @darylbowman for the clarification.
hi @sweta68 ,I tested your solution but issue remained the same. Didn’t work as expected. Any idea you have ?
Hi @Naveen Boga , @sweta68 , @darylbowman sorry for the delayed update, I applied the suggested constant to the query but it shows me an error.CS0305: using generic type 'where<unary operator>' requires 1 type argumentshow can I solve this? appreciate if you can help me on this as well. Thanks.
oh @Naveen Boga , sorry for the mistake, There was an additional bracket in the query, that was the issue. apologize you again. Thanks.
Hi @Naveen Boga ,small favor please, If I need to add another condition to above query to restrict loading SOOrder.OpenQty == 0 orders, how can I do it?. I could see some conditions like Greater<decimal0> , the idea of this like greater than 0 isn’t it? if so, how can I apply with the above query? appreciate if you can help me on this as well. Thanks.
HI @andriikravetskyi35 ,sorry for being late to reply.APProformaDiscount is a custom table and the code is attached herewith. thank you.
Hi @sweta68 ,Thank you for your response. I tested your solution but the issue is still not solved and remained the same. Do you have any other idea on this? Thanks.
Hi @Naveen Boga ,Thank you for the response and I will test your solution and update you. btw, Is there any difference between SetValueExt and SetValue? I couldn’t find out any proper answer for this.
@Naveen Boga .thank you for your explanation. Then it’s better to use setValueExt instead of setValue in these kind of scenarios right? however I applied your suggestion to the code and tested but seems like it leads to an infinite loop with setValueExt showing me an unhandled exception error but with setValue, there is no error but the field updated issue is not solved.
Hi @Naveen Boga Genius! your solution worked. Thank you very much. And also @zfebert56 thanks for you as well for sharing what you know on this.
Hi @Naveen Boga ,the string list is added to below custom DAC filed in SOline.I’m not aware about the first point that you mentioned about size of the string list DAC. can’t I define like above. and also how can I change the view into correct one.?
Hi @Naveen Boga actually I defined the APProformaItemList.SODicountCode field as only a string field. it’s not a string list field. will that be the issue then?
@Naveen Boga ,If we need set this kind of string list value, we need to have same set of values defined both in two fields? is that true? Now actually I have set these string list values in soline for testing my development. I gonna publish it to another test server, so in that server, Usrdiiscountcode field can have different string values,so to assign correct value, same string values should be defined in my SODiscountCode DAC as well?
@Naveen Boga ,sorry for being late to reply. your solution worked. Thank you very much for your favor.cheers.
Already have an account? Login
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.