Skip to main content
Solved

BR: Expression to clear input field

  • March 29, 2023
  • 6 replies
  • 99 views

Forum|alt.badge.img+1

FSM 6U4
7327

I am trying to amend a BR so that it clears the input field at the end. I used expression = original(task_ext.*). However, getting an error “data member specified by *** cannot be found”.

 

Am I using an incorrect expression?

Alternatively, what other way can I clear input field at end of BR?

 

Thank you.

Best answer by Shneor Cheshin

Hey @tgenden 

You another issue, not in the BR.

I created the same logic to remove description from TASK (task status is mandatory). So when description is changed the description is removed.

 

Please read here about your issue

FSM - Data Member Specified by 'column name' cannot be found | IFS Community

Cheers!

6 replies

Jon Reid
Hero (Employee)
Forum|alt.badge.img+18
  • Hero (Employee)
  • March 29, 2023

The = sign for the value sets the field to null, at least in a XML update. 


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • March 30, 2023

Thank you for the suggestion. I tried it, but it threw up an ‘unexpected syntax’ error.

 

 


Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • March 30, 2023

Hey @tgenden 

Just leave all the fields empty. 

Example of removing a task description

Cheers!


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • March 31, 2023

thanks @Shneor Cheshin for the suggestion. However, it gives me the following error. 

I’m wondering if there is some logic loop causing the block since, I am trying to clear the input field itself. 

 

For instance, in your example. Would it be possible to clear the “task_status” field back to null in the end?

thank you.

 


Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • Answer
  • March 31, 2023

Hey @tgenden 

You another issue, not in the BR.

I created the same logic to remove description from TASK (task status is mandatory). So when description is changed the description is removed.

 

Please read here about your issue

FSM - Data Member Specified by 'column name' cannot be found | IFS Community

Cheers!


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • April 5, 2023

@Shneor Cheshin  I found out the root cause. 

The field I am trying to clear is on the task_ext table. However, the XML FSM posts is trying to clear field on task.user_def36 which does not exit. It should be clearing task_ext.user_def36 instead. I updated the BR and was able to clear another field that was on the task table so the example you showed works in that case. thank you.