Hi Experts,
Can anyone help me to get custom searc...
# generals
Sudhakar T
03/01/2023, 1:11 PMHi Experts,
Can anyone help me to get custom search results.
Req::: Export list of items where the class of the child item does not match the class of the parent item.
How to do while doing this procedure of criteria??
m
mightyd3
03/01/2023, 1:25 PMDo could export all the items, and have one result field be the Parent Item... Class, and work excel magic on it.
or you can create a search criteria formula that is something like Formula (Numeric), case when {class} IS NOT {parent.class} THEN 0 ELSE 1 END. (and filter it to the 0 result. (probably also want criteria to exclude any items without a Parent Item)
thankyou 2
mightyd3
03/01/2023, 1:26 PMNot sure what the parent field is so that formula is probably wrong, just a heads up.
👍 1
n
NElliott
03/01/2023, 2:58 PMin the case of subitems or children in matrix items the parent field is... wait for it... "parent"
thankyou 1
s
Sudhakar T
03/01/2023, 4:46 PMI got a soln from this. Thank you every one.
👍 1