Skip to main content
Nintex Community Menu Bar
Solved

How can i edit the existing Smart Object

  • July 13, 2017
  • 3 replies
  • 3 views
  • Translate
J

 Hi there,

 

Can any one please advise me for editing an existing Smart Object which is used for displaying the Divisions from Divisions Table.

This is directly created on the Divisions Table and now there are some of the Divisions are no need to display and they are not Active(Not Active=0).

I want to edit this Smart Object to add this Condition for not displaying the Not Active=0 divisons on the list.  Is this possisble ??

If this Smart Object created on Stored Proc i can able to modify the Stored Procedure and republish this Smart Object and it won't affect  any of the Smart Forms.

Please advise me how i am going to achieve this or any other alternative solutions.

 

Regards,
Jags.

 

 

Best answer by BryanPeters

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

View original
    Did this topic help you find an answer to your question?

    3 replies

    B
    Forum|alt.badge.img+8

    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

    Translate
    J
    1 person likes this
    • J
      Jags
    J
    • Jags
    • Author
    • 1 reply
    • July 14, 2017

    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

     

     

     

    Translate
    B
    Forum|alt.badge.img+8

    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

    Translate

    Reply


    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie Settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie Settings