Jags, 

One way to accomplish this is to add a column to your table. For active divisions put active. For inactive divisions put inactive. The in the view or form that is pulling the smartobject data when the form or view initializes and calls the smartobject configure the rule to filter out where the column equals inactive. Or it only shows where column_status is equal to active. I know this isn't exactly what you were looking for but I hope it helps.

Thanks,

Bryan Peters

Hi Bryan,

Thanks for your reply.  

Yes, it works if i go and configure the filter in the View Initializing on Smart Object configuration.  

But i have to do it for all the Forms which are using this Divisions Drop Down List on live environment.

Is there any other alaternative ways to do it...?

Thanks,

Jags

Jags,

 You would have to sort this in each process you built using that SmartObject. I have never tried to directly order a SQL table for this purpose but You can try ordering the Divisions column. I think the syntax would be something similar to below. Keep in mind you can always create a SQL view of the table and just create a Smartobject off of the view.

SELECT column1, column2, ...
FROM table_name
ORDER BY column1, column2, ... ASC|DESC;

Or..

SELECT * FROM DB Name
ORDER BY Division DESC;

I do not know if any of this will work for you but it might be worth a shot.

Thanks,

Bryan Peters