Which table in the Agile Database to look for MULTITEXT attributes?

I looked into PAGE_TWO and PAGE_THREE values but the columns having MULTITEXT type attributes are not present.

TIA.

Add Comment
9 Answer(s)
Best answer

Hi, 
Did you try AGILE_FLEX table?

Agile Angel Answered on April 10, 2015.
Add Comment

What version are you using?  What Class are you trying to change? 

Under Items there are multitext attributes on both page 2 & 3.   Set Filter By Type at the top of the page to multitext to view.

Do you have admin privileges?  Make sure Visible includes No.  This appears to be an issue with your set-up or privileges.

Agile User Answered on April 9, 2015.
Add Comment

I am using 9.3.1.1 and trying to look for the columns in Agile DB. I have DB Administrator privilege.

Agile Angel Answered on April 9, 2015.
Add Comment

Attributes are configured through the Admin interface;   Do not configured in the underlying DB.

RE: Which table in the Agile Database to look for MULTITEXT attributes?

Go to Admin Tab>Data Setting>Classes>Subclass Type[eg Parts]>UserInterface Tabs> PageTwo>Attributes

Agile will handle DB configuration behind the scenes.

Are we getting on the same page?  Why are you looking at the “Agile DB”?

Agile User Answered on April 9, 2015.
Add Comment

Thanks for your reply, but iIwant to find the tables in the DB.

I am writing a SQL to fetch values from one of the MULTITEXT fields and cannot find the table which stores it.

Thanks!

Agile Angel Answered on April 9, 2015.
Add Comment

Thanks!! It is the TEXT column in AGILE_FLEX table.

Agile Angel Answered on April 14, 2015.
Add Comment

You are welcome! Does it answer to your question?

Agile Angel Answered on April 14, 2015.
Add Comment

Yes!!

Agile Angel Answered on April 15, 2015.
Add Comment

Please mark it as correct answer 🙂

Agile Angel Answered on April 15, 2015.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.