When you create a new datasource it always includes all columns of the table. If I only want to use a few columns (yes all mandatory columns are of course included) is the only way to define a view and then use that view or is there another way to only use the columns you need.

Can I for example in a panel only put all required fields plus a few other ones or will that create issues? If you have a table with 60 columns and most of the time only deal with a subset of those, defining a view for every variation seems a bit long winded.

asked 30 Mar '14, 23:49

Raymond's gravatar image

Raymond
24328
accept rate: 0%


Hi Raymond,

Regarding your question: Can I for example in a panel only put all required fields plus a few other ones or will that create issues?

Yes sure you can. You can use a subset of columns on any panel.

Kind Regards,
Yalim

link

answered 31 Mar '14, 02:53

Yalim's gravatar image

Yalim ♦♦
2.8k5
accept rate: 21%

Thanks Yalim

(31 Mar '14, 02:56) Raymond

Hi Raymond,

If you will not perform DML operations through this datasource, you can always write your custom select statements in the datasource definition after selecting "Query" as Based On option.

In Formspider, there is no way to specify the columns to be used in datasource level. But in any case, you can only use the columns that you need in your panel declaration, referencing only some columns of a datasource in a panel won't create any issue.

Regards,
Ibrahim

link

answered 31 Mar '14, 03:07

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
1.5k5
accept rate: 25%

Thanks Ibrahim. Just wanted to make sure.

(31 Mar '14, 03:53) Raymond
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×64
×3

Asked: 30 Mar '14, 23:49

Seen: 913 times

Last updated: 31 Mar '14, 03:53


© Copyright Gerger 2017