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

Question

Question

Cloud Insert Lookup Table Rule - Get Key

Laserfiche Cloud Rules
Updated December 13, 2022
asked on December 12, 2022 • Show version history

If I want to get the key, for the row I just created with an insert rule, it does not seem to be a return value. I see EvalResult, which I assume is the row count but not the key.

Does this mean there should be another rule to lookup based on the data just entered and return the key or is there a smoother way to do this?

I want the key so that I can remove the row from the table when we are done with the data and the data used to create the rule could be different at that time as the business process steps are completed and data is being updated.

0 0

Answer

SELECTED ANSWER
replied on December 12, 2022

The key is the same as an Index field in SQL, it only get's created once the entry is made into the DataTable.

Typically in the cases where I would need something like the Key returned immediately, I would also populate the BPID into a field in the table as welll to tie it to my instance, so I can query by just the BPID to return the Key or whatever else I need from that row

0 0

Replies

replied on December 12, 2022

What I have done is when I populate the data into a Table in Forms, I also populate the Key field into a hidden field, so I can reference it in the case I want to update or delete that row in my DataTable. In your case I expect you would need that query to get the Key info.

0 0
replied on December 12, 2022

How do you get the key info? With another rule that passes all the same information to it, just to return the key?

0 0
SELECTED ANSWER
replied on December 12, 2022

The key is the same as an Index field in SQL, it only get's created once the entry is made into the DataTable.

Typically in the cases where I would need something like the Key returned immediately, I would also populate the BPID into a field in the table as welll to tie it to my instance, so I can query by just the BPID to return the Key or whatever else I need from that row

0 0
replied on December 13, 2022

Yea maybe using the key isn't a good idea, if it can't be returned as an output immediately upon row creation. I want to keep the total rules consolidated as much as possible and don't like having another rule just to get the key back.

By passing the BP guid I can use that instead and do it all in one shot. Thanks!

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

Sign in to reply to this post.

Details
Related Posts
Loading ...