HomeRules

Getting Truth Table / Matrix Table details Messages in this topic - RSS add reply

MichalD
MichalD
Posts: 1


4/14/2021
MichalD
MichalD
Posts: 1
I've only been working with this tool a short while, but I'm already a fanboy smile.

As to my question:
Is there a way to pull information that is stored in a rule rather than running it?

E.g. I have a rule table that returns true or false based on what string is passed into it. The matching strings are defined in the rule.

Can you extract the list of strings that the rule specifies?

E.g. from the rule table below I'd like to extract a string array {"Assigned to", "Estimate", "Hours spent"...}



This is both relevant to matrix rules and truth tables.

If this is not possible, is it possible to populate a truth tables/matrix rule's details automatically? Something having it pull the list of matchin strings from e.g. a flow? (so in the example above, I'd like to have a flow that returns a list of strings {"Assigned to", "Estimate", "Hours spent"...} and the rule populates its axis from that flow)

Thanks!
0 link reply with quote
Marcus Paige
Marcus Paige
Administrator
Posts: 74


4/14/2021
Marcus Paige
Marcus Paige
Administrator
Posts: 74
Hello Michal,

We can go about this in a few ways. One method would be to create a flow structure to store the input to the Truth table/matrix rule and its returned result. The created entity would only exist during the run of the flow, so we wouldn't have to worry about these entities needing to be stored our existing outside of runtime. For more information on flow structures, we can refer to the following document: https://documentation.decisions.com/docs/creating-simple-flow-structure

Another method would be to enable rule audit history and rule audit phrase history on the truthtable/rule. This stores the input/output values of the rule in the database. I'm still verifying whether there is a step to pull this data, but in the meantime, we could write a query integration to pull these values from the database. The values are stored in the table rule_audit_phrase_history. The following query will return all values in the table that equal your input to the rule:


SELECT * FROM rule_audit_phrase_history

where value_data='$RuleInputHere'

.I've also included documentation below around rule audit history and creating query-based steps in Decisions.
https://documentation.decisions.com/docs/use-rule-audit-history
https://documentation.decisions.com/docs/parameterized-queries
0 link reply with quote


(Ctrl+Enter)




Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software