Skip to main content
Solved

Additional attributes and formatting datatype

  • November 2, 2022
  • 1 reply
  • 106 views

Forum|alt.badge.img+5
  • Do Gooder (Customer)
  • 5 replies

Hi!

When using the “Additional Attributes” in FSM6, there is currently a limitation in regards to the data-type being sent to PSO.

As of now it is possible to send columns from the tables which has a datatype of DateTime, but this is not sent to PSO (which does not “understand” the datatype DateTime) and datatype field is omitted when the xml towards PSO is created.

Is there a way to override this, other than changing it in metadata (which also would make this an issue when viewing the field on a screen/changing it/performing logic(BR/Scripts etc))?

Baseline datetime field request_dttm is sent as marked up in the image, baseline :
 

Since there are datatypes selectable on fields in FSM, would it not be beneficial to also be able to choose the datatype to be sent to PSO when creating an Additional Attribute?

At least have it default to “STRING” when parsing the xml…

 

Best answer by tomgreenwood

Hi Bjorn,

You may already know this but datetime isn’t a valid datatype in PSO for Addtional_Attribute:

If you believe FSM should convert fields holding a timetime value to a string please raise this as a support case with IFS.

Kind Regards,

Tom

View original
Did this topic help you find an answer to your question?

1 reply

tomgreenwood
Superhero (Employee)
Forum|alt.badge.img+24
  • Superhero (Employee)
  • 423 replies
  • Answer
  • November 28, 2022

Hi Bjorn,

You may already know this but datetime isn’t a valid datatype in PSO for Addtional_Attribute:

If you believe FSM should convert fields holding a timetime value to a string please raise this as a support case with IFS.

Kind Regards,

Tom


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings