Forum Discussion

jnixon's avatar
jnixon
Advocate II
6 years ago
Solved

how to pass multiple optional parameters to a custom function?

I've experimented, but I have not come up with a solution for this scenario: My Custom function accepts three parameters, the last two of which are optional. I want to pass parameters one and three ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Make sure that your second argument has no type. You will then be allowed to pass a null value as the second option. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Make sure that your second argument has no type. You will then be allowed to pass a null value as the second option. 

  • jnixon's avatar
    jnixon
    Advocate II
    6 years ago

    Thanks Mike - back to the rescue!

    That works indeed.  Testing further, i found that this will also work with passing null, and with the added benefit of validating the data type of the parameters:

     

    (P1 as text, optional P2 as nullable text, optional P3 as nullable text) =>

    let

       T1 = "P1 = " & P1,

       T2 = if (P2 = null) then "; P2 = null()" else "; P2 = " & P2,

       T3 = if (P3 = null) then "; P3 = null()" else "; P3 = " & P3,

       Return = T1 & T2 & T3

    in

       Return

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hey J, I forgot that you could use nullable text. I wish more of the standard PQ functions would use them.