Skip to main content
D
deeptis0004
September 27, 2023
Question

Multiple string value generated in view in one record

  • September 27, 2023
  • 3 replies
  • 0 views

Hiii, i want to fetch multiple string value seperated by semi colon through query in one column like (123456;234565;456789;234567;124567). How we can do that

    3 replies

    stefanhelzle0001
    stefanhelzle0001
    September 27, 2023

    I am not sure what exactly you mean with "multiple string value seperated by semi colon through query in one column" ?!?

    But you can use joinarray() to merge a list into a string with a separator of choice.

    D
    deeptis0004Author
    September 29, 2023

    I have two Id one I'd is integer one is string if user select multiple integer Id and string Id either integer value or string value on the basis of that filter in the export to excel value should come so I have made SQL query rule for that for this selection how we can do through SQL in appian

    D
    deeptis0004Author
    September 29, 2023

    Like this( Id('234','456')OR Id2('234.X.1','3456.C.1')) and same rule input is using for both id

      Terms & ConditionsAccessibility statement