Skip to main content
Question

how to concat in a lobby data source


Forum|alt.badge.img+6

In the IFS lobby data source. How do you go about appending a ‘$’ to the front of a value?

 

Below is what I am attempting to concat in the column:

CONCAT(‘$’, round(SUM(&AO.Customer_Order_Line_API.Get_Base_Sale_Price_Total(ORDER_NO, LINE_NO, REL_NO, LINE_ITEM_NO)),0))

Forum|alt.badge.img+8
  • Sidekick (Partner)
  • November 13, 2023

Hi,

 

You can write it with “||” between the different variables/values:

 

‘$’||round(SUM(&AO.Customer_Order_Line_API.Get_Base_Sale_Price_Total(ORDER_NO, LINE_NO, REL_NO, LINE_ITEM_NO)),0)

 

For ex, if order_no=100 and line_no=2 :

sql query :
      SELECT ‘Order: ’||ORDER_NO||’ - Line : ’||LINE_NO
 
      FROM CUSTOMER_ORDER_LINE

result :
      Order: 100 - Line: 2

 

BR, 

Pierre


Manulak
Hero (Customer)
Forum|alt.badge.img+8
  • Hero (Customer)
  • November 13, 2023

Hello @bpamlin 

Use it as follows - works like a charm.

Chr(36) || round(SUM(&AO.Customer_Order_Line_API.Get_Base_Sale_Price_Total(ORDER_NO, LINE_NO, REL_NO, LINE_ITEM_NO)),0)

 


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