0 votes

Hello Efficy Team,

A customer have a list of multivalue, pointing on ACC_ACCOUNT.
We want to show the result in FormFieldCustom.

Is there a better way than this ?

<%Delay(1)%>RunQuery(id=listOfUsers$FIELD$, sql=|
    select value from string_split(
    (select $FIELD$ from proj$cide where k_project = :param1
    ), ';') where value <> ''
|, param1='%%GetKey()')%>

<dt>
    <%Delay(1)%>GetDataGrid(query='listOfUsers$FIELD$', templateText=|
        <#repeat>
            <%Delay(2)%>GetUserName(param='<#F=value>')%>
        </#repeat>
    |)%>
</dt>

(as you may have guessed, this is still Efficy 10sp2+. But any suggestion for Efficy 11> are welcome !)

Thanks in advance,

Loïc

asked in Efficy/ Client side by (460 points)

1 Answer

+1 vote
Best answer

Tried with this?

<%GetField("$FIELD$", type="multivalue", tableid="1000", separator=", ")%>
answered by (6.8k points)
selected by
1,167 questions
1,425 answers
1,717 comments
325 users