Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
in the table BOX i want to display the field FOR inactive user. how to do this in the table box and in the straight table?
example data
ID | USERNAME | LASTNAME | FIRSTNAME | NAME | ACTIVE_INACTIVE |
1 | A | XXX1 | XXX1 | AA1 | ACTIVE |
2 | B | XXX2 | XXX2 | AA2 | INACTIVE |
3 | C | XXX3 | XXX3 | AA3 | ACTIVE |
4 | A | XXX4 | XXX4 | AA4 | INACTIVE |
5 | B | XXX5 | XXX5 | AA5 | ACTIVE |
6 | C | XXX6 | XXX6 | AA6 | INACTIVE |
7 | A | XXX7 | XXX7 | AA7 | ACTIVE |
8 | B | XXX8 | XXX8 | AA8 | INACTIVE |
9 | C | XXX9 | XXX9 | AA9 | ACTIVE |
10 | A | XXX10 | XXX10 | AA10 | INACTIVE |
11 | B | XXX11 | XXX11 | AA11 | ACTIVE |
USE
field FOR? I don't see any column with header FOR? Can you elaborate on your requirement?
its just for, typo error i need all the all fields to be displayed only for inactive
sunny careply me waitig for your reply
Hi Mano
in Straight table we can achieve it like below
only(ACTIVE_INACTIVE= 'INACTIVE')
In Table Box we can achieve it like below
Sample:
LOAD ID,
UN,
LN,
FN,
N,
Act_Inact
FROM
(ooxml, embedded labels, table is Sheet1)
where Act_Inact = 'INACTIVE';
Regards
hemanth
where we have to give this condition ?
Hi Mano,
Attached the qvw for your reference
Regards,
Hemanth
no while i loading in the script i need all the details but while displaing in the front end i need only the inactive user details
Hi Mano,
what you are asking is not possible with table box. It can be achieve through straight table
attached qvw will give what your thought of requirement.
Regards
Hemanth
You can use the Trigger for this
Sheet Event Trigger to be used for the selection of the Inactive Users
Regards
Anand