It's all about the answers!

Ask a question

removing a row based on two columns

Bryan Omes (111) | asked Feb 25 '22, 7:30 a.m.

 I got a 4 column table being generated on RPE. the RPE is sourced from 2 data source in Doors Module. 

Module 1 is the main datasource where we populate the first and second column which would loop in each record to populate the entire page while the third and forth are columns linked to the second datasouce that would rely on the condition based on the first datasource.

Since there's a possibility that column 3 and 4 would not have any data if it didn't match with the criteria/condition indicated to populate these columns.

is there any way for me to remove these rows if the value of column 3 and 4 are both empty?

One answer

permanent link
Subramanya Prasad Pilar (4.6k14) | answered Feb 25 '22, 9:27 a.m.

Easy way is to place the row inside the query and apply the criteria/condition on the row.

Bryan Omes commented Feb 25 '22, 1:05 p.m.

i like to do that way also, but right now, im working on a already established template, where what it does is doing a loop within the module and individually check if its matches with the condition set it.

Basically the main Module has a attribute/column that is currently linked to the second module. what the original code does is check if the linked value has a attribute that matches with the criteria indicated. if it does, the resulting value would be another attribute/column within the second module.

also, im still trying to learn doors and there's a ton of stuff that im still un-aware of. 

Your answer

Register or to post your answer.