Skip to main content
Solved

About new Column search property

  • November 19, 2019
  • 7 replies
  • 340 views

Forum|alt.badge.img+7

 

Hi,

I have added a new column to window cTableWindow. I turned to queryable property to true as shown on the picture but it doesn’t show up F3 search screen.

 

Thank you.

 

Best answer by Himasha Abeywickrama

Hi@savasciftci,

 

Is the attribute you’re using an Aggregate or an Array attribute? Because, for Aggregate and Array attributes, Queryable property will always return false.

 

Also, if you go to the designer.cs file, you should see something like this for your table column,

 

NamedProperties.Put("FieldFlags", "294");

 

This is where the flags are set. The number represents text as a series of Unicode characters. You can try to set the Queryable to false and check if this number gets changed.

 

Himasha

View original

7 replies

Kasun Balasooriya
Superhero (Employee)
Forum|alt.badge.img+20

Hi,

Can you please check whether the F1 property SQL Column has a value attached to your column? 

If you dragged and dropped the column from the Dataset toolbox, the SQL column property should already have a value by default. See below: 

 

 

If you created the column from the toolbox, you must add the SQL column manually. 

 


Forum|alt.badge.img+7
  • Author
  • Sidekick
  • 37 replies
  • November 20, 2019

Hi KasunBalasooriya

 

First of all, thank you for your response.

SQL column is full and it is not reason.

 


Himasha Abeywickrama
Superhero (Customer)
Forum|alt.badge.img+18

Hi@savasciftci,

 

Is the attribute you’re using an Aggregate or an Array attribute? Because, for Aggregate and Array attributes, Queryable property will always return false.

 

Also, if you go to the designer.cs file, you should see something like this for your table column,

 

NamedProperties.Put("FieldFlags", "294");

 

This is where the flags are set. The number represents text as a series of Unicode characters. You can try to set the Queryable to false and check if this number gets changed.

 

Himasha


Forum|alt.badge.img+7
  • Author
  • Sidekick
  • 37 replies
  • November 20, 2019

Hi @Himasha Kapugeekiyanage  

Thanks for ur help. It is the answer i am lookin’ for.


Kasun Balasooriya
Superhero (Employee)
Forum|alt.badge.img+20
savasciftci wrote:

Hi KasunBalasooriya

 

First of all, thank you for your response.

SQL column is full and it is not reason.

 

Hi,

What’s the cTableWindow you are trying this on?  Are you trying to add a filed from the Dataset toolbox or are you adding a cColumn from the toolbox? 


Forum|alt.badge.img+7
  • Author
  • Sidekick
  • 37 replies
  • November 20, 2019

Hi Mr @KasunBalasooriya 

 

The reason in my column i used an aggragated function. I turned it to a function and it solved my problem. Thank you for your help. 


Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • 5 replies
  • June 20, 2024

Is there a way to save views with different column views?  Example, I am trying to save a view in Sales orders and only one 3 table views in one save and 9 in another. Seems like all my saves have to have the same columns that the user selects.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings