AnsweredAssumed Answered

clear droplist variable on data card

Question asked by James Santangelo on Jun 18, 2015
Latest reply on Jun 22, 2015 by James Santangelo

Like • Show 0 Likes0
Comment • 10

Is it possible to clear a droplist variable? I have a data card for our "ECN" process document where the droplist will list the users from a specific EPDM Group. The droplist group is a pulled from the SQL database. This droplist variable (Task Owner XXX) is currently used to allow people to search where they have been assigned a task for a specific "ECN". If someone selects someone there is no way to clear or blank out that droplist.

I was thinking of adding a Button that would clear the "Task Owner XXX" specific variable via a Command String but am unsure of what command would be. I'm open to other methods. Thank you.

Charley Saint Jun 22, 2015 12:16 PM

Correct Answer

Hey James,

Sorry, stick it before the order by, didn't take that in as a possibility.

See the reply in context

No one else had this question

Outcomes

Jeff Sweeney Jun 18, 2015 10:27 PM

If your list is a text list, you can make the first row of your list be an empty line. I would investigate a way to make one of the records returned by your SQL statement be an empty string.

Actions

James Santangelo @ Jeff Sweeney on Jun 19, 2015 5:12 PM

I'm not a SQL person so I will try to see if I can find something I can hack.

Is there any way to just clear the value of a variable on the data card?

Actions

Tim Webb @ James Santangelo on Jun 19, 2015 5:35 PM

On a transition just set the variable value to empty. Should do the trick.

Hope this helps!

Tim CEPA

http://www.equivaq.com

Actions

James Santangelo @ Tim Webb on Jun 19, 2015 8:02 PM

That won't work for this as I am trying to clear the variable of the droplist when someone is editing the data card.

Actions

Charley Saint @ James Santangelo on Jun 22, 2015 1:31 AM

Hey James,

At the end of each query just add 2 lines

Union All

Select ''

That will add a blank line to each query

Actions

James Santangelo @ Charley Saint on Jun 22, 2015 12:14 PM

I tried adding those two lines to the end of the SQL query for that list that generates the values for the droplist and I get an error:

Actions

Charley Saint @ James Santangelo on Jun 22, 2015 12:16 PM

Hey James,

Sorry, stick it before the order by, didn't take that in as a possibility.

Actions

James Santangelo @ Charley Saint on Jun 22, 2015 12:21 PM

Working as intended. Awesome. Thank you.

Just as a side, any suggestions on how to teach myself a bit more on the SQL side of things? My current only programming experience is in some beginner python. I'd like to harness the power of reports derived from the SQL database.

Actions

Charley Saint @ James Santangelo on Jun 22, 2015 12:24 PM

I liked this course, it may be a bit much if you don't already know some SQL though, but give it a shot:

SQL | Stanford Lagunita

It is based on standard SQL which is a bit different from MSSQL, but the differences are pretty minimal

Actions

James Santangelo @ Charley Saint on Jun 22, 2015 12:35 PM

Thank you for the suggestion.

Actions

10 Replies

Jeff Sweeney Jun 18, 2015 10:27 PM
Mark Correct
Correct Answer
If your list is a text list, you can make the first row of your list be an empty line. I would investigate a way to make one of the records returned by your SQL statement be an empty string.
Like • Show 0 Likes0
Actions
- James Santangelo @ Jeff Sweeney on Jun 19, 2015 5:12 PM
  Mark Correct
  Correct Answer
  I'm not a SQL person so I will try to see if I can find something I can hack.
  
  Is there any way to just clear the value of a variable on the data card?
  Like • Show 0 Likes0
  Actions
  - Tim Webb @ James Santangelo on Jun 19, 2015 5:35 PM
    Mark Correct
    Correct Answer
    On a transition just set the variable value to empty. Should do the trick.
    
    Hope this helps!
    Tim CEPA
    http://www.equivaq.com
    Like • Show 0 Likes0
    Actions
    - James Santangelo @ Tim Webb on Jun 19, 2015 8:02 PM
      Mark Correct
      Correct Answer
      That won't work for this as I am trying to clear the variable of the droplist when someone is editing the data card.
      Like • Show 0 Likes0
      Actions
  - Charley Saint @ James Santangelo on Jun 22, 2015 1:31 AM
    Mark Correct
    Correct Answer
    Hey James,
    
    At the end of each query just add 2 lines
    
    Union All
    Select ''
    
    That will add a blank line to each query
    Like • Show 1 Like1
    Actions
    - James Santangelo @ Charley Saint on Jun 22, 2015 12:14 PM
      Mark Correct
      Correct Answer
      I tried adding those two lines to the end of the SQL query for that list that generates the values for the droplist and I get an error:
      
      Like • Show 0 Likes0
      Actions
      - Charley Saint @ James Santangelo on Jun 22, 2015 12:16 PM
        Unmark Correct
        Correct Answer
        Hey James,
        
        Sorry, stick it before the order by, didn't take that in as a possibility.
        Like • Show 1 Like1
        Actions
        James Santangelo @ Charley Saint on Jun 22, 2015 12:21 PM
        Mark Correct
        Correct Answer
        Working as intended. Awesome. Thank you.
        
        Just as a side, any suggestions on how to teach myself a bit more on the SQL side of things? My current only programming experience is in some beginner python. I'd like to harness the power of reports derived from the SQL database.
        Like • Show 0 Likes0
        Actions
        Charley Saint @ James Santangelo on Jun 22, 2015 12:24 PM
        Mark Correct
        Correct Answer
        I liked this course, it may be a bit much if you don't already know some SQL though, but give it a shot:
        
        SQL | Stanford Lagunita
        
        It is based on standard SQL which is a bit different from MSSQL, but the differences are pretty minimal
        Like • Show 1 Like1
        Actions
        James Santangelo @ Charley Saint on Jun 22, 2015 12:35 PM
        Mark Correct
        Correct Answer
        Thank you for the suggestion.
        Like • Show 0 Likes0
        Actions

clear droplist variable on data card

Outcomes

Related Content

Recommended Content