It’s working ! Thanks!
@Saranga Amaraweera thanks!@Shneor this is my script:CREATE VIEW AC_TASK_DURATION_VIEW ASSELECT TASK_ID,(SCHED_TASK_DUR_MIN/60) AS DUREE_HEURE_J,(SCHED_TASK_DUR_MIN/60)+ FLOOR((SCHED_TASK_DUR_MIN/60)/8)*16 AS DUREE_HEURE_JNFROM TASK The message has changed ! The erros is from here?
@Saranga Amaraweera @Rwjgoedhart @Shneor Hi,Thanks for your reactivity !But sadly, it’s not working… I have the same message.I can consult my view with the SQL Query (ex :select top(100) * from ac_task_duration_view).What i did and complete with your messages:1 - I create my view in SQL Server management2 - I add it in Custom Metadata with all column3 - I add the relationship with task in Custom Metadata:4 - In Ui designer, I create the relationship in the “Child Relation Editor” (and I can access of columns in the “Add screen fileds” 5 - I refresh the cash and restart the IIS. Is it right?Renaud
Thanks for you answer. I refresh the cache and close FSM sessions. But it doesn’t work. I always have the same message.
Hello,Sorry for my late feed back but I let down the case.And finally, it works after reinstall the server… Something magical !There’s only one case that’s not work it’s with the value =”REPAIR”. Thanks for your help.
@Roel van Zwieten Which parameters? In color settings i try with the keyword “Red” and after the hexacode color (#D84256).and i used for the VALUE parameter the Code Value in the task_type table.Is there another parameters? in AppParam for example? or a limitation in colors choice (with official list...)?
Salut !J'ai essayé d'utiliser cette fonction mais cela ne fonctionne pas. C'est encore bleu !Avez-vous une idée?Merci
Hi Lee,Unfortunatly, it’s not working.In the expression column, I wrote : “ROUND(TASK.USER_DEF_NUM1/8)”A warning message indicated : The expression ‘ROUND(TASK.USER_DEF_NUM1/8)’ contains unexpected syntax. The exprexpression contains more operands than operators. Do you have any idea? Best regards. Renaud
@Lee Pinchbeck Hi, Thanks for your good ideas!My parameter is not from an input field but the result of a calcul with a division. Best regards. Renaud
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.
