Filter table based on user input values and also filter data in table based on child records

  • 2
  • Question
  • Updated 3 years ago
  • Answered
I have added 10 different account fields on the page.Based on the user entered values in these account fields,I need to display data in a table.Please let me know how to filter data in a table based on user entered values.Also,two of the fields entered by the user are child record names,based on these child record names I need to fetch all the parent account records and display in the table.Please help!
Photo of Anjali Kumar

Anjali Kumar

  • 310 Points 250 badge 2x thumb

Posted 3 years ago

  • 2
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb
The comments in this post might help: https://community.skuidify.com/skuid/...
Photo of ravi teja

ravi teja

  • 238 Points 100 badge 2x thumb
SELECT Opportunity.Opportunity_Name,
                             Opportunity.Opportunity_Owner,
                             Opportunity.Amount,
                             Opportunity.Close_Date
                        FROM Opportunity
                       WHERE Account__c IN
                            (SELECT AccountId
                             From User
                             WHERE username=:UserInfo.getUsername())];
        return recordList;


this is used to get user id and u have to apply filter conditions im also new to this
Photo of Zach McElrath

Zach McElrath, Employee

  • 49,056 Points 20k badge 2x thumb
You can add a "Result of Subquery" Condition to your Opportunity Model in Skuid to limit to just Opportunities whose AccountId field , or a custom field Account__c, is the result of a SOQL Sub-query. When creating the Condition, select "Result of Subquery" for the Condition Value Type, "User" for the Join Object, "AccountId" for the Join Field. Then, click the plus icon on the Condition to add a Sub-Condition. Set the Sub-Condition's Field to "Id" / User Id, and set the Value Type to "Running user attribute", which will default to the "User Id" user info property.



Photo of Anna Wiersema

Anna Wiersema

  • 10,890 Points 10k badge 2x thumb
Yes!  I would say check out the link that Raymond posted. You could also use Model Actions instead of Buttons so that, for example, whenever a field on that Account Field Editor is edited, it would run a series of Actions via the Action Framework to query the table.  The only thing is the actions might fire before the user is ready, so tying them to a button would prevent that.
Photo of ravi teja

ravi teja

  • 238 Points 100 badge 2x thumb
hii Anna

I am Btech graduate student of final year we are doing a project on salesforce im absolutely new to this i have a small doubt on conditions they are 4
 filterable off
filterble on
Always on
Always off im not understanding where to use the correct one can u tell about them

if u dont have any time just post any pdf file here
Thanking you
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb
Here is a video tutorial: http://youtu.be/e8EGGnI-8Fk
Photo of ravi teja

ravi teja

  • 238 Points 100 badge 2x thumb
Thank u raymond