Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to find a way to have a selection of 2 fields with a button.
What I basically want is a button that shows
Sold items that are marked as 'Sold' in the field 'Status'
OR
Sold items that are marked as 'Sold' in the field Inventory
so basically a button with:
Select in Field: Status OR Inventory
Search String: *Sold*
is that somehow possible?
Hi,
If You have
Field,Status,Inventory
A, a, Sold
B, Sold, b
..........
If You select A, You exclude B.
However ,You can add to script
Load *,
If(Status='Sold' or Inventory='Sold',1) as Flag;
Load * from .......; // or SQL Select * from ...;
Then in Your Button -> Select -> Action -> Select in Field Flag -> 1.
Also You can use expression like
Sum({<Status={'Sold'}>+<Inventory={'Sold'}>} Value)
in your objects.
Regards,
Antonio
Basically you want to select Items, right?
Try creating a button with action Select - Select in field
Field:
Item
Search string:
='=Status like ' & chr(39) & '*Sold*' & chr(39) & ' or Inventory like ' & chr(39) & '*Sold*' & chr(39)
Well the simplest and most straightforward approach I think might be to have a small two column table generated like this in your load script:
AbsolutelySold:
LOAD
Item,
(Status = 'Sold') AS DefinitelySold
RESIDENT
TableWithTheField_Status;
LOAD
Item,
(Inventory = 'Sold') AS DefinitelySold
RESIDENT
TableWithTheField_Inventory;
If the two fields are in the same table you can simplify it like this:
AbsolutelySold:
LOAD
Item,
(Status = 'Sold' Or Inventory = 'Sold') AS DefinitelySold
RESIDENT
TableWithTheTwoFields_Status_and_Inventory;
In you application you can have the field DefinitelySold in a list box and that will act as your button.
@swuehl you are the boss, what an elegant solution, I had to play with the syntax a bit but now it is working,txs
Hi @swuehl
I know this is very old post but I have similar requirement.
I tried to use the same logic and it didn't work.
the Item field you mentioned here is not in context.
can you please elaborate little more?
Hi @bwohletz
I have similar requirement like this, it the syntax worked?
you just have Status and Inventory fields but not sure how Item came into context.