Solved

Additional attributes and formatting datatype

  • 2 November 2022
  • 1 reply
  • 76 views

Userlevel 2
Badge +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…

 

icon

Best answer by tomgreenwood 28 November 2022, 10:47

View original

1 reply

Userlevel 7
Badge +23

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