Skip to main content

Hi All,

  • May 15, 2023
  • 1 reply
  • 3 views
pavan.bhara13
Level 4
Forum|alt.badge.img

Hi All,

 

I have an interesting requirement, where i need to find the data type of the column (table field) in PQL.

 

Ex :

Implementation is done in Views and knowledge model:

 

Case_Key = 400100200300,400A00200400

Variable ${CK} = Case_Key

 

Requirement ==> Case when ${CK}= String then ${CK} else to_String(${CK}) END

 

Any insights on this would be much appreciated. TIA!

1 reply

marc.v
Level 2
Forum|alt.badge.img+6
  • marc.v
  • Level 2
  • May 15, 2023

What possible data types could be given?

If you use the function CONCAT and you give it one single parameter (i.e. CONCAT(${CK}) ), it will return a STRING whether the variable was a STRING, INT or FLOAT.

Community Code of ConductAccessibility statement