idlist

OnBeforeGet Methods are mainly used for search filter tasks. You typically use the Method to overwrite search conditions. Not sure if you can use idlist, but I would try this:

this.setAttribute("idlist", ...);

return this;

This is what I have now. Comes back as "Not a Single Item". Any Suggestions?

Dim tmpInn As Innovator = Me.getInnovator()
Dim dd_parm0 As String = tmpInn.getUserID()

if dd_parm0 = ("C87129C35EBE4AD7AF9F8C012DDE8C5B") Then
Dim i As Integer
Dim xx As String = CStr(CCO.Session("arasSESSID"))

For i=0 To me.getItemCount()-1
Dim currentW As Item = me.getItemByIndex(i)
Dim SQL As String = "SELECT DISTINCT ........ = " +  "'" + xx + "')"

SQL = String.Format(SQL, xx)
Dim res As Item = currentW.getInnovator().applySQL(SQL)
If Not res.isError Then
Dim nb As String = res.getProperty("nb", "")
currentW.setAttribute("idlist", nb)
End If
Next i
Return me
End If

You "get not a single item" error message cause there is no single item.

Use a newError message to let yourself display the content of me/this. You will notice that "me" contains the search query, not the query result. That´s the reason I mentioned that onBeforeGet is mostly used for search filters. So you cannot loop through the items, cause you only have one (the search query itself).

What is your use case? The current concept looks like the beginning of a performance disaster waiting to happen 

It can lead to problems if you applySQL/AML calls in a loop. If using "idlist" in a loop like this, it will probably only overwrite the idlist over and over again. Try to design your SQL query in a way, that it already will return the final comma separated idlist that you than can use like this:

me.setAttribute("idlist","id1,id2,id3,...");
return this;

And this one
     Dim res As Item = currentW.getInnovator().applySQL(SQL)
should better be
     Dim res As Item = tmpInn.applySQL(SQL)

Good luck :)

You "get not a single item" error message cause there is no single item.

Use a newError message to let yourself display the content of me/this. You will notice that "me" contains the search query, not the query result. That´s the reason I mentioned that onBeforeGet is mostly used for search filters. So you cannot loop through the items, cause you only have one (the search query itself).

What is your use case? The current concept looks like the beginning of a performance disaster waiting to happen 

It can lead to problems if you applySQL/AML calls in a loop. If using "idlist" in a loop like this, it will probably only overwrite the idlist over and over again. Try to design your SQL query in a way, that it already will return the final comma separated idlist that you than can use like this:

me.setAttribute("idlist","id1,id2,id3,...");
return this;

And this one
     Dim res As Item = currentW.getInnovator().applySQL(SQL)
should better be
     Dim res As Item = tmpInn.applySQL(SQL)

Good luck :)