APEX高亮行根据列比较(APEX hightlight row according to column comparison)

APEX高亮行根据列比较(APEX hightlight row according to column comparison)

我在APEX中有一个报告，显示了两个表的JOIN。 两个表都具有例如电话号码的值。 如果两个电话号码不匹配，我希望该行高亮。

我查看了Actions> Format> Highlight中的突出显示选项，但似乎我只能将列值与特定值进行比较而不是另一列。

我对APEX很新，所以我可能会错过一些明显的东西！ 我已经阅读了其他问题和答案，但他们似乎正在处理更复杂的事情。 他们谈到制作一个不可见的列并改变它的价值，但我不知道我会怎么做。

谢谢你的帮助！

I have a report in APEX which shows a JOIN of two tables. Both tables have a value for, for example, telephone number. If the two telephone numbers do not match I want the row to be highlihgted.

I looked at the highlighting options in Actions>Format>Highlight but it seems I can only compare a column value to a particular value and not another column.

I'm very new to APEX so I might be missing something obvious! I've read other questions and answers but they seem to be dealing with more complex things. They spoke about making an invisible column and changing the value of that but I'm not sure how I would do that.

Thanks for any help!

最满意答案

在查询中创建一个伪列以标记感兴趣的记录。 然后比较国旗：

SELECT a.phone, b.phone ,CASE WHEN a.phone = b.phone THEN 1 ELSE 0 END AS match FROM a, b WHERE a.id = b.id

Create a pseudo column in your query to flag records of interest. Then compare to the flag:

SELECT a.phone, b.phone ,CASE WHEN a.phone = b.phone THEN 1 ELSE 0 END AS match FROM a, b WHERE a.id = b.id