Skip to main content
Solved

CF is not displayed in SQL view

  • Oct 30, 2024 6:59 AM UTC
  • 11 replies
  • 222 views
Sidekick (Customer)
Forum|alt.badge.img+10
  • Ed22
  • Sidekick (Customer)

Hello,

 

I created Custom Field in this entity, but when I open my SQL view, it is not there, what should I do?

Should I switch on toggle List Of Values for this CF, or there is other option?

Thanks 

 

 

Best answer by Marcel.Ausan

@Ed22 can you paste your SQL query here?

I think you are executing more than select * from IFSAPP.SALES_PRICE_LIST_PART_CFV if you are getting the invalid identifier error.

View original

11 replies

Hero (Customer)
Forum|alt.badge.img+10
  • Ozgun BAL
  • Hero (Customer)
  • Oct 30, 2024 7:06 AM UTC

Hi @Ed22 ,

 

Please tray to add “_CFV” after your view.

 

For example: Customer_order_cfv.

 

CFV means custom field view.

 

Hope it helps

Ozgun Bal

Kind Regards
Sidekick (Customer)
Forum|alt.badge.img+10
  • Ed22
  • Author
  • Sidekick (Customer)
  • Oct 30, 2024 8:02 AM UTC

I created Custom Field CF_AAA_CISLO, but I had this error: 

 

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Marcel.Ausan
  • Ultimate Hero (Partner)
  • Oct 30, 2024 9:07 AM UTC

@Ed22 if you added the Custom Attribute in the Sales Price List entity, then you should run the below query. Are you getting the CF?

select * from IFSAPP.SALES_PRICE_LIST_CFV

 

https://www.linkedin.com/in/marcelausan/
Sidekick (Customer)
Forum|alt.badge.img+10
  • Ed22
  • Author
  • Sidekick (Customer)
  • Oct 30, 2024 9:13 AM UTC

it says table or view does not exist

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Marcel.Ausan
  • Ultimate Hero (Partner)
  • Oct 30, 2024 9:45 AM UTC

@Ed22 is this the 1st CF created in the SalesPricelIst entity? Did you Publish the entity configuration?

Can you provide a screenshot of the SalesPriceList entity configuration please?

https://www.linkedin.com/in/marcelausan/
Sidekick (Customer)
Forum|alt.badge.img+10
  • Ed22
  • Author
  • Sidekick (Customer)
  • Oct 30, 2024 9:47 AM UTC

I added this CF in entity SalesPriceListPart, should I add to the SalesPriceList? 

 

 

Sidekick (Customer)
Forum|alt.badge.img+10
  • Ed22
  • Author
  • Sidekick (Customer)
  • Oct 30, 2024 9:52 AM UTC

 

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Marcel.Ausan
  • Ultimate Hero (Partner)
  • Oct 30, 2024 10:00 AM UTC

@Ed22 OK, got it now. You need to query the IFSAPP.SALES_PRICE_LIST_PART_CFV view then.

https://www.linkedin.com/in/marcelausan/
Sidekick (Customer)
Forum|alt.badge.img+10
  • Ed22
  • Author
  • Sidekick (Customer)
  • Oct 30, 2024 10:03 AM UTC

I have still error which is in picture 1: ORA00904 CF$_AAA_CISLO: invalid identifier

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Marcel.Ausan
  • Ultimate Hero (Partner)
  • Answer
  • Oct 30, 2024 11:56 AM UTC

@Ed22 can you paste your SQL query here?

I think you are executing more than select * from IFSAPP.SALES_PRICE_LIST_PART_CFV if you are getting the invalid identifier error.

https://www.linkedin.com/in/marcelausan/
Sidekick (Customer)
Forum|alt.badge.img+10
  • Ed22
  • Author
  • Sidekick (Customer)
  • Oct 31, 2024 7:54 AM UTC

Thank you, I solved this. Problem wasnt in this CF problem was in another CF, I removed wrong CF and it works.

Terms & ConditionsAccessibility statement