You are viewing limited content. For full access, please sign in.

Question

Question

Stored Procedure - Is there a multiple output limit?

asked on November 10, 2025

I use this stored procedure where my input is a Document ID and Document Number where it should return the latest Revision Number, Title, and Entry ID.

But it will only return one item at a time.

So now we are using three stored procedures instead:

  1. [aacustom_getRevisionByDocIdDocNum]
  2. [aacustom_getTitleByDocIdDocNum]
  3. [aacustom_getEntryIdByDocIdDocNum]

 

Does Laserfiche Forms have a limit on passing output values back to Forms?

0 0

Answer

SELECTED ANSWER
replied on November 12, 2025

Turns out, it's a bug that's been fixed in V12. We will eventually upgrade. For now, we have three stored procedures that output each desired item ... and it works.

1 0

Replies

replied on November 10, 2025

Can you try checking the "as new sets" option in the lookup? that will convert all rows in the lookup output to a row on the form.

2 0
replied on November 10, 2025

It won't let me. It's grayed out.

0 0
replied on November 11, 2025

That is likely because your stored procedure only returns one result. In your original post you mentioned "return the latest Revision Number, Title, and Entry ID" which implies just one. If possible could you share one of the stored procedures and a screenshot of the result set it produces?

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.