Stored Procedure Array Input

Question

Can we pass a list of numbers to input parameter of SP? Is it possible. 
 a!storedProcedureInput( name: "group_ids", value:local!groupids (It is a list of number) ), 
 It's not working as input parameter is defined as INT on DB side but we are passing list of integers.

Aryan · Answer

Yes, I also think we cannot pass list of integers. But even if you want to pass list, pass them in a string separated by any delimiter and then split them inside the SP. Refer to the below thread: https://community.appian.com/discussions/f/plug-ins/11690/execute-stored-procedure-is-not-taking-multiple-values-as-input

Mike Schmitt · Answer

Pass in a list as a comma-separated string, then in the procedure itself you can use functions like FIND_IN_SET (depending on exactly what you need to do with it of course), to act directly on the list.

ganeshbabuj · Answer

For MariaDB - Plus we need to make sure there is no comma in the value passed in, when Appian build the query space gets added before all value so use below on where condition on Procedure 
 AND (p_input IS NULL OR p_ input = '' OR FIND_IN_SET(TABLE.COLUMN_NAME, REPLACE(p_input,' ','')) > 0)

Stored Procedure Array Input

Top Replies