Hello everyone
I have a database called garage.
In it I have 2 columns, the first is named car, the second license plate.
For example :
Car = Audi Blue
License plate = ZE-34-HE
I have a page containing information obtained by APIs that cannot be modified, including the License plate (ZE-34-HE)
I’d like to be able to display the car (Audi Blue) contained in the database on this same page from the License Plate.
I can find all the cars with a “Do a search for” but not the Audi that matches the plate.
Could you please help me?
hergin
2
You will simply add a constraint to your Do a search for
to find the cars with the plates not in the list of that API call. See an example below:
You can try using find and replace twice, once for ( and another for ) to remove those from value provided by API or use regex to do it.
Thank you for your reply @boston85719 , I’ve tried and it doesn’t work.
hergin
6
I thought you are trying to exclude the audi. Then you should do the same and use is in
after the plate, instead of isn't in
in this picture.
jguerin
7
@hergin Thanks for your help. I tried but it doesn’t work. I haven’t been able to put your good advice into practice.