table box

[manoranjan_d]

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

[sunny_talwar]

field FOR? I don't see any column with header FOR? Can you elaborate on your requirement?

[manoranjan_d]

its just for, typo error i need all the all fields to be displayed only for inactive

[manoranjan_d]

sunny careply me waitig for your reply

[hemanthaanichet]

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

[manoranjan_d]

where we have to give this condition ?

[hemanthaanichet]

Hi Mano,

Attached the qvw for  your reference

Regards,

Hemanth

[manoranjan_d]

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

[hemanthaanichet]

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

[its_anandrjs]

You can use the Trigger for this

Sheet Event Trigger to be used for the selection of the Inactive Users

Regards

Anand