Filter Condition of Slice

AppSheet AppSheet Q&A
, ,
1

Hi! Hope all of you are fine. Please help me create a slice following the similar condition below-

It is a SQL Query-
SELECT Item_Info.[Item Info ID], Item_Info.[Item Name]
FROM Item_Info where EXISTS(select * from approved_po_items where approved_po_items.pobasicid=‘f8b1a6e8’ and approved_po_items.[item info id]=item_info.[item info id]);

Explanation:
It will be shown only the data from the Item_Info Table those can be found in the approved_po_items Table and pobasicid filed equal to ‘f8b1a6e8’.

Please suggest me whether I can make a slice from Item_info Table following the relations with approved_po_items Table.

I played around IN and AND expression, but no success.

Please it is crying need of your help.

Kind regards.

2

Hi @shahappsheet

You may want to show us the structure of the table involved, in order to better understand how to build the yes/no expression you are looking for.

From what I read:

shahappsheet:

It will be shown only the data from the Item_Info Table those can be found in the approved_po_items Table and pobasicid filed equal to ‘f8b1a6e8’.> > Please suggest me whether I can make a slice from Item_info Table following the relations with approved_po_items Table.

You are looking for something like this:

AND(
  [pobasicid ]="f8b1a6e8",
  IN([_THISROW],approved_po_items[keyColumn])
)

What did you try so far ?
Did you have a look to this post, too ? it may help you:

Edit: expression correction

1 Like
3

Thanks @Aurelien. I will post the tables. Thanks again.

4

Hi @Aurelien ! Thanks a lot for your kind help. My Problem is solved. Instead of making a slice, I have used the “Valid If” Event and used INTERSECT Function and I got what I wanted. Actually, it is a result output between two tables. In SQL it is used EXISTS. Anyway, Thanks Again.

3 Likes