Connector Function for And and OR

Developer
1

Dear all,
I want to Build connector function below is my requirement.
I have “Component Table”, table having 5 Field,
1.Component Name- datatype Text Field.
2.BackFlush-datatype Boolean Field.
3.Direct Initiate-datatype Boolean Field.
4.Direct Process–datatype Boolean Field.
Direct Initiate =Yes and Direct Process=Yes = front Flushed
I want connector function that will return only “non-flushed” components.

Thanks in advance

2

Hey @kkale -

Are you pulling this data from a Tulip table or some other data source?

From tables this is fairly easy, as the API allows filters to be passed in as query parameters. See this example below. In this case, I am checking to see if the is_in_stock field is equal to True.

Table:

image
image586×554 26.4 KB

Connector Function:

image
image3014×1106 229 KB

If you are going to another data source (HTTP connector to not tables, or SQL connector) the approach will be slightly different, but I can give you some guidance if that is the case.

Pete

3

Hello @Pete_Hartnett
thanks for the instance support
I am pulling the data from tulip table.
but in my case Direct Initiate =Yes and Direct Process=Yes = front Flushed combination of these two is = front flushed component.
other one is backflushed component.
I want connector function that will return only “non-flushed” components.

4

Could you describe the exact combination logic, that leads to “non-flushed”?

So you could do a filter logic any: NOT Direct Initiate ; NOT Direct Process
This would include everything but both true.

BUt I’m not sure if that is what you are looking for.

1 Like
5

Hello @thorsten.langner ,
I have Backflush component that would be Boolean.
but Front Flush = Combination of (Direct Initiate and Direct Process) that would be both “True”

6

for you want to check for

Backflush “no” and (Direct Initiate “no” or Direct Process “no”)

?

You could achieve this, to make an api call on the or condition (Direct Initiate “no” or Direct Process “no”).
And then you filter the outputs by the and condition (Backflush “no”).

This can be done in the connectro function output itself, by using Jason Query.

2 Likes
7

@thorsten.langner
I want this Backflush “no” and (Direct Initiate “no” and Direct Process “no”).

8

So what is your issue? The title of this thread is “And and OR” but I cant see any or here…

So just use a filter on the api with an “all” condition and add these three…
Exactly as Pete discribed in his post, but you add filters.1.field … and filters.2.field …

9

@thorsten.langner ,
Thanks for the suggestion, I will implement it and let you know.

Regards,
Kiran