Skip to main content

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!

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.


Reply