How To filter Complex Table Row

[Former Member]

Hi,

I create a Complex Table like this :

ID    |     Property_filter

------------------------------------

1      |    T

2      |    T

3      |    F

4      |    F

5      |    F

6      |    T

In some add/edit screenset, I have to show in a Complex Table Search only the row with Property_filter = "T".

What is the right index structure for my complex Table ?

Thank you in advance.

[bill_froelich · Accepted solution]

Giacomo,

Here are the high level settings needed

• Create an index on Property_Filter

• Create an index on ID with a parent of Propety_Filter (commonly named ID by Property_Filter)

• On your screen for the Complex Table search field
  • Search Index  - ID by Property_Filter
  • Parent Value - Rule returning T
  • Set your Display Field and Return Field as needed

--Bill

[Former Member · Accepted solution]

Thank you Bill, your solution works just fine. I have another case for you:

Complex Table Structure

ID    |     Property_filter       |  Description

----------------------------------------------------------------

1       |    T                        | A

2      |    T                        | B

3      |    F                        | A

4      |    F                        | A

5      |    F                        | A

6      |    T                        | B

7       |    X                        | B

8       |    X                        | B

9       |    X                        | B

10     |    X                        | B

In some add/edit screenset, I have to show in a Complex Table Search only the row with Property_filter = "T" AND "F" .

Question 1. What is the new index structure for my complex Table ?

Question 2. Is it also possible to have unique description? If question 1. has a solution, i think i will get duplicate description row. The best result for me is:

             | Description     |

---------------------------------

ROW 1.| A                     |

ROW 2.| B                      |

[bill_froelich · Accepted solution]

Question 1: You can't do and conditions for parent child indexes.  you would need another column to filter on that has value TF say for example for all T and F rows.  Then the process is the same to use it.

Question 2: I don't know what you are trying to accomplish so I can't say for sure.  The Complex Table drop down de-dups values in the list so if you have two rows with the same description you will only see one in the list.  For Complex Table Search it would show both rows.  Feel free to elaborate on your scenario in a new thread and I can try to answer.

--Bill