I want to return unique values from a data store using just a rule and query. Th

james.franklin over 9 years ago

I want to return unique values from a data store using just a rule and query. This is what I have so far but I can't seem to figure out how to leverage the target field array. for the union function to operate on.
=union(todatasubset(rule!GetAllLrules().PUB),todatasubset(rule!GetAllrules().PUB))
So the .PUB part delivers the data sub set how do I then navigate to the field within it?
Ideas and outright solutions most welcome.
Thanks, James

Discussion posts and replies are publicly visible

Parents

0 Mike Schmitt
Certified Lead Developer
over 9 years ago

Can you clarify a bit? Off the top of my head:
1) why are you calling todatasubset() on the rule outputs?
2) what is the sub-field you're trying to get the unique values of?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Mike Schmitt
Certified Lead Developer
over 9 years ago

Can you clarify a bit? Off the top of my head:
1) why are you calling todatasubset() on the rule outputs?
2) what is the sub-field you're trying to get the unique values of?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data