- Posts: 3
- Thank you received: 0
Will images show up in the table or just the file name?
Thanks
Please Log in or Create an account to join the conversation.
Hi,
You have two options:
If your data contains a html tags (i.e. <img src="myimagedir/myimage.jpg">) than the images will be shown automatically.
If your data contains only file names, than you can create a database view, that adds a html tag to your data. Please check FAQ to learn how to do it.
Please Log in or Create an account to join the conversation.
Thanks - that was helpful. One more question, please, before I buy -
I am using Community Builder and will want to show tables within user profiles, and I will want to filter a table based on certain CB fields (tagged in brackets, like [cb_zipcode]). Once a grid has been set up, can the initial filter or SQL statement be adjusted dynamically by the grid command that calls the grid? For example, another software uses {$REQUEST ...} tags in the SQL query to load variables from the URL into the query. Is there some equivalent way in your component of changing the query based on new content being viewed or passed?
Thanks, again.
Please Log in or Create an account to join the conversation.
Hi,
In the backend there is an "Addition Where Condition" option available, where you can set a custom where condition. You can also use a few parameters such as @user_id, @article_id which are replaced with the current values during the runtime.
If you want to filter by zip code, you have two options:
- create an appropriate database view that contains user id
- with a little bit of php coding you can create a custom parameter that you can use in the where condition.
Regards
Please Log in or Create an account to join the conversation.
I saw those optional WHERE conditions, but I need to filter on dynamic data that my not be related to the user, but rather a profile being viewed by the user. I know some php but I don't know if I can write the code that will access fields from the community builder table for a profile being viewed.
Please Log in or Create an account to join the conversation.
Hi,
There is another possible option where you can set the search parameters through url. Maybe it would suit you more.
www.toolsjx.com/support/3-suggestions/12...provided-by-url#1215
Please Log in or Create an account to join the conversation.