Established Member.. AlekseyG
Established Member..
503 views

Table component tokens in UI rules

Hello!

 

Tell me please whether it's possible to get the value from TC row by another column's value using TC tokens in UI rule?

 

"Commands, Tokens, and Validations Guide and Reference" guide describes how to get the value by row seq number ([REQD.T.EMPLOYEE.TE="1".VP.NAME]) only. But i want to "filter" by the other column's value.

 

Thanks in advance!

0 Likes
7 Replies
Absent Member.. AlfredoMonasi Absent Member..
Absent Member..

Re: Table component tokens in UI rules

Hi AlekseyG,

 

The tokens for table columns are TE.P.TOKEN and TE.VP.TOKEN.

 

 

Regards,

 

Alfredo

0 Likes
Established Member.. AlekseyG
Established Member..

Re: Table component tokens in UI rules

Hello Alfredo!

 

I need only those rows where the column has specific value. i wonder how to filter using tokens.

0 Likes
Absent Member.. AlfredoMonasi Absent Member..
Absent Member..

Re: Table component tokens in UI rules

Why don't you use a CASE CONDITION with the token in the where part????

0 Likes
Established Member.. AlekseyG
Established Member..

Re: Table component tokens in UI rules

I need to get the result right after Table Component field change. So i can't select from DB because the data there is not updated by the moment. 

0 Likes
Absent Member.. AlfredoMonasi Absent Member..
Absent Member..

Re: Table component tokens in UI rules

Hi AlekseyG,

 

I dont understand what you want to accomplish. Imagine that you have this table

 

COL1   COL2    COL3-Result

1            1             2

3            1             4

3            2             5

 

As far I understood you if you change the value of COL2 or COL1 you want to update the COL3, right?

 

You can achieve that by using Table UI Rules, using the TE.P.COL1 / TE.P.COL2 tokens. If you just want to update them under certains values you can set the values on the table rules.

 

Alfredo

0 Likes
Established Member.. AlekseyG
Established Member..

Re: Table component tokens in UI rules

Hi Alfredo!

 

Taking your example I want to select the sum of COL1 values where COL2='1'

0 Likes
Absent Member.. AlfredoMonasi Absent Member..
Absent Member..

Re: Table component tokens in UI rules

Hi AlekseyG,

 

I think that the only way to achieve is after save with a SQL function that add the values according your second column. I usually do this in a rule when the page is load and update a field on the request.

 

Regards,

 

Alfredo

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.